topic / databases
Databases
Storage engines, indexes, and transactions from the inside.
What a database does between your query and your answer: page layouts, B-trees, write-ahead logs, isolation, and why 'just use an index' is never the whole story.
4 articles · 1 video · 5 total
Articles
Why Your Query Is Slow (And It's Not the Index)
Buffer pool misses, WAL contention, lock waits, and connection pooling — the non-index causes of database slowness.
How SQL Query Optimizers Think
Cost-based optimization, join ordering, and statistics — why your query plan changed overnight and what to do about it.
The Anatomy of a Database Transaction
ACID is a slogan; the write-ahead log is the mechanism. How a transaction commits, why the WAL exists, and what isolation levels actually change.
Why Databases Use B-Trees (and Not Hash Tables)
Indexes are shaped by the physics of disk and memory. What a B-tree is, why hash indexes can't replace it, and what the shape of the tree says about your database.
Videos
Explore adjacent
Depth, delivered weekly
One technical dispatch a week on databases and the systems around it.
One technical dispatch per week. No noise.