Articles
Written deep dives
Long-form articles with diagrams, code samples, and references. Each one complements a video on the channel.
indexinginternals
B+ Trees Explained: The Data Structure Powering Almost Every Database Index
If you've ever added an index to speed up a query, you've likely used a B+ tree without knowing it. This article walks through how they work, why they're so good at what they do, and how databases use them to turn table scans into lightning-fast lookups.
Jun 12, 2026 · 5 min read
concurrencypostgresql
MVCC Demystified: How Postgres Handles Concurrent Transactions
Multiple users, one database, no locks — here's how Multi-Version Concurrency Control actually works under the hood, with diagrams showing exactly what Postgres stores and when it cleans up.
Jun 8, 2026 · 4 min read