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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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