Skip to content

Path 1

Foundations for every database

How 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 completed ยท about 235 min

After this path you can

Outcomes

  • Explain why one engine is fast to write and another fast to read, from how it stores data
  • Predict the anomalies an isolation level allows before they reach production
  • Reason about replication lag and quorums with real numbers
  • Choose a database for a workload and defend the trade-offs

Lessons

  1. 1Storage engines: B-tree versus LSM treeWhy Postgres updates pages in place and Cassandra only ever appends: what each design costs on writes, reads and disk, measured on real Postgres 18 and Cassandra 5.0.Foundation30 min
  2. 2Indexes and access patternsWhen an index is used, what it costs on writes, and why Postgres lets you index anything while Cassandra answers only the queries you designed for.Foundation30 min
  3. 3Transactions and isolationThe anomalies concurrent transactions cause, which each Postgres isolation level prevents, and what Cassandra offers instead: one partition and compare-and-set.Intermediate30 min
  4. 4Replication and lagHow Postgres streams changes to replicas and Cassandra writes to all of them at once, why replicas fall behind, and what synchronous commit waits for.Intermediate30 min
  5. 5Consistency models and quorumsWhat a reader may see when data has several copies, why overlapping quorums (R + W > N) give fresh reads, and what each choice costs when replicas are down.Intermediate30 min
  6. 6Partitioning and shardingHow data is split: Postgres partitions a table by range, Cassandra hashes every partition key onto a ring of nodes, and a bad key puts all the load on one machine.Intermediate30 min
  7. 7Data modelling for access patternsPostgres models the data and joins at read time; Cassandra models the queries and writes data once per query. How to design each and keep copies in step.Intermediate30 min
  8. 8Choosing a databaseHow to choose between Postgres and Cassandra from access patterns, invariants, scale and failure tolerance, backed by the real output from this path.Intermediate25 min