Comment on Litestream: RevampedComments−yowmamasita1ytangent: 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−simonw1yYes 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.−markusw1yI wrote about this back in 2022, still applicable today: https://www.golang.dk/articles/benchmarking-sqlite-performan...−soamv1yYes, but: https://sqlite.org/wal.html
Comments
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
Yes 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.
I wrote about this back in 2022, still applicable today: https://www.golang.dk/articles/benchmarking-sqlite-performan...
Yes, but: https://sqlite.org/wal.html