News for hackers. Stuff that matters.
Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by andersmurphy on Wednesday July 29, 2026 @05:31AM (#49095171)
I would only recommend sqlite if you know what you are doing (and/or prepared to learn it inside out). It's more of a build your own database primitive (often you'll have multiple sqlite databases for different things). Which can be incredibly rewarding and deliver amazing performance outcomes, simple ops, etc.

I see the migration argument come up a lot. But, in practice with sqlite you'll be using projections where you have a source of truth database (event log) and project off it into disposable/expendable sqlite databases. So schema changes are often just delete and rebuild the projection.

There are no comments on this comment yet.