SQLite DB: simple, in-process, reliable, fast (2024)

Big fan of SQLite and am using it in many local and production contexts.

all writes to a single database are serialized (sequential), there is only one writer at any given time

Whilst I love it, this a major constraint to keep in mind and the one that makes me reach for postgresql.

So it's not just not about throughput, it's about contention - a single write lock effectively means no long-running transactions. For many workloads that’s fine. But if you need real concurrent writes, it becomes a bottleneck quickly.