Blog

Databases posts

Postgres, SQLite, and MongoDB in real workloads: slow aggregations, lock contention, index design, and schema changes that have to ship without downtime.

2 posts in Databases

Sorted by newest first

Server racks with glowing indicator lights inside a clean data centre

Databases24 Jun 20268 min readReader favourite

SQLite Returns SQLITE_BUSY During Concurrent Writes in Drizzle ORM

Two background jobs writing at the same time turned a reliable SQLite database into a source of intermittent failures. The database was behaving exactly as documented, and my connection setup was quietly asking for trouble.

Rows of illuminated server racks receding down a data centre aisle

Databases13 May 20267 min read

MongoDB Aggregations Get Slow the Moment You Sort on an Unindexed Field

A dashboard query went from forty milliseconds to nine seconds after one product decision: show the newest results first. The pipeline was fine. The sort had nowhere to run except memory.