[yowmamasita]

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]

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.

[markusw]

I wrote about this back in 2022, still applicable today: https://www.golang.dk/articles/benchmarking-sqlite-performan...

[soamv]

Yes, but: https://sqlite.org/wal.html