Exercises

# multi-milestone build projects drilling the data-storage concepts.

❯ cat documents/

Build your own database Exercise 2026-08-08
A SQLite-style storage engine written from scratch — REPL to pager to B-tree to WAL — until pages, indexes, and durability stop being diagrams.
Build your own database — subject Subject 2026-08-08
The build spec for a SQLite-style engine — REPL grammar, row and page formats, pager, B-tree node layouts and splits, WAL with crash-proof replay, and a secondary index.
End-to-end ELT pipeline Exercise 2026-08-08
The modern data stack on a laptop — ingestion to warehouse to tested dimensional marts, orchestrated with backfills and shipped through CI like software.
End-to-end ELT pipeline — subject Subject 2026-08-08
The work statement for the laptop-scale modern data stack — DuckDB + dbt layers and tests, a star schema with an SCD2 dimension, idempotent ingestion with late data, orchestrated backfills, and CI gates.