Database Engine Internals
Step 2 in the Databases path · 8 concepts · 0 problems
0 / 8 complete
📘 Learn Database Engine Internals from zero
A from-first-principles walkthrough that assumes no prior knowledge (generated in the enrichment pass, grounded in the source lessons).
Lessons in this topic
- ○The Buffer Pool & Page Cache
- ○Write-Ahead Logging & Durability
- ○The Cost-Based Query Optimizer
- ○B-Tree vs LSM-Tree Storage Engines
- ○MVCC & Snapshot Isolation
- ○Database Engine Internals — Bitmap Scans, Buffer Pins & Latching, Deadlock Detection (Deep Dive)
- ○Online Schema Change at Scale — Expand-Contract, Batched Backfill & Shadow Tables
- ○Database Connections & Pooling — Why 5,000 Connections Melt Postgres