Database Engineering: Storage Engine Internals
Three posts on how databases physically store and recover data — pages, heap files, B-Tree vs LSM-Tree, and the Write-Ahead Log that guarantees nothing is ever lost.
Curated learning paths with focused episodes. Filter by status and sort by what matters.
Three posts on how databases physically store and recover data — pages, heap files, B-Tree vs LSM-Tree, and the Write-Ahead Log that guarantees nothing is ever lost.
Three posts on the SQL that separates mid-level from senior developers — window functions, CTEs, EXPLAIN plans, query optimization, and deliberate schema design trade-offs.
Five posts covering what every developer must know about databases — from how a DBMS works and how to design schemas, to SQL, indexes, and transactions with ACID.
Five deep-dive posts on the algorithmic techniques behind every hard interview problem. Sorting, recursion, dynamic programming, greedy, and divide & conquer — with the reasoning frameworks that make optimal solutions feel inevitable.
Master the 6 data structures that appear in 80% of technical interviews. Each post goes deep on one structure — how it works under the hood, every interview pattern it unlocks, and the exact templates that win offers.
Before you write a single line of code, you need to think like an interviewer. This 3-part foundation series covers the mindset, the math, and the pattern recognition framework that separates candidates who get offers from candidates who get stuck. Start here — everything else builds on this.
Results