Re:We’re pretty happy with SQLite and not urgently intereste...
by lucaspiller on Monday June 20, 2016 @09:58AM
(#11938038)
Yeah the WAL basically makes "concurrent processes reading/writing to the same database" work magically, where as without you'll get all sorts of issues and timeouts. I don't know why it isn't enabled by default, or at least more prominently advertised as an option.
[ Parent
| on HN ]
Re:We’re pretty happy with SQLite and not urgently intereste...
by SQLite on Monday June 20, 2016 @11:39AM
(#11938693)
Initially, WAL mode was off by default because older versions of SQLite do not support it, and it is a property of the database file. Thus, a database created in WAL mode would be unreadable by older SQLites. But WAL has been available for 6 years now, so it might be reasonable to make it the default. We will take your suggestion under consideration. Thanks.