Skip to content
Learn

Databases in production

How databases store, index, isolate, replicate and partition data, and how to choose one. Every lesson compares Postgres and Cassandra on the same problem, with real output from both.
  1. Understand
  2. Compare engines
  3. Run it for real
  4. Diagnose
  5. Choose

Learning paths

  1. Path 1: Foundations for every databaseHow data sits on disk, is indexed, isolated, replicated and partitioned, and how to model it. Each lesson compares Postgres and Cassandra on one problem.
    0/8 lessons

Coming next: Relational in depth: Postgres and Wide-column in depth: Cassandra.

How the evidence is made

Query plans, traces and statistics marked Real database output come from running the lesson's lab against real PostgreSQL 18 and Apache Cassandra 5.0 in Docker. The labs are in the repository, so you can run them yourself and get the same kind of output. Every build checks that each one matches its captured run word for word.