3 ms·
SQLite has had a WAL (write-ahead log) since 2010. Admittedly, it is not the default. [1] [1] https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
by toxik 2y ago
SQLite has had a WAL (write-ahead log) since 2010. Admittedly, it is not the default. [1]
[1] https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
- Sammi 2y ago* Not the default in the original c library ... except it is the default in language wrappers like better-sqlite3 for nodejs. It's probably unlikely that you're consuming the upstream sqlite c lib directly with its intentionally antiquated defaults. You're much more likely using a provider that has tweaked the defaults to more modern standards.
- jamal-kumar 2y agoI found the old wrappers to be really messed up and buggy compared to the new nodejs builtin that works charmingly well Do you know any details about those tweaks you mention because it would be very nice to know what edge cases I gotta watch out for using any of these
- cute_boi 2y ago> new nodejs builtin Do you mean this node js 23 sqlite api[1]? [1] https://nodejs.org/api/sqlite.html https://nodejs.org/api/sqlite.html
- Sammi 2y agoBeen running better-sqlite3 in production for a long time and it's been fast and reliable for me. Looking at their github stats and open issues and prs, it looks like the project is healthy.