SQLite
WAL Mode: One Writer, Many Readers
SQLite's default journal blocks readers during a write. WAL mode does not, and that single difference decides whether SQLite suits a concurrent service.
· 2 min
tag
#reliability
Articles tagged “reliability” on SQLPress — 3 in total.
3 articles
PostgreSQL
Connection Pool Sizing: Why More Connections Make It Slower
Past the point where the server can execute work in parallel, adding connections adds queueing rather than throughput — and moves the queue somewhere worse.
· 4 min
PostgreSQL
Transaction Pooling Breaks Only Under Load
Transaction pooling is what makes PgBouncer worth deploying, and it silently removes session state your application may depend on.
· 3 min