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
#architecture
Articles tagged “architecture” on SQLPress — 3 in total.
3 articles
NoSQL
Document or Relational: Read-Time or Write-Time Cost
Relational modeling describes the entities and lets queries follow. Document modeling inverts that, and the inversion is the whole trade.
· 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