3 ms·
tangent: in modern SQLite, are writes still serialized? That's my main concern when choosing a tech stack for an app that might have thousands of writes happeni
by yowmamasita 1y ago
tangent: in modern SQLite, are writes still serialized? That's my main concern when choosing a tech stack for an app that might have thousands of writes happening on peak periods
- simonw 1y agoYes they are, but if you benchmark thousands of writes a second you'll likely find that SQLite does just fine. You might start running into problems at tens or hundreds of thousands of writes a second, though even then you may be OK on the right hardware.
- soamv 1y agoYes, but: https://sqlite.org/wal.html https://sqlite.org/wal.html
- markusw 1y agoI wrote about this back in 2022, still applicable today: https://www.golang.dk/articles/benchmarking-sqlite-performance-in-go https://www.golang.dk/articles/benchmarking-sqlite-performan...