LIVE
2 articles
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's Highlights This week, we dive into SQLite's build process with SQLITE_DQS=0 issues, explore optimized PostgreSQL Docker images leveraging io_uring, and discuss best practices for multi-tenant PostgreSQL...
May 26, 2026 · 4 min read
Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency control: reads never block writes, and writes never block reads. Its locking system has 8 table-level lock modes and 4 row-level lock modes, and the conflict tables in the documentation tell you exactly which...
May 26, 2026 · 8 min read