Data & Databases
Modelling data, and what happens when there's a lot of it.
Relational Fundamentals
The model, the query, and the two mechanisms — indexes and the planner — that decide whether it returns in 2ms or 2s.
6 topics
Transactions & Consistency
What happens when two requests touch the same row at the same time, and which anomalies your isolation level still allows.
5 topics
Postgres in Depth
The database you will actually be using — its index types, its JSON support, and the two operational failures that bite everyone.
7 topics
Schema Design & Migrations
Turning a product feature into tables, and changing those tables later without taking the product down.
6 topics
Choosing a Datastore
What each family of store is actually good at, and why "Postgres until it hurts" is usually the right default.
5 topics
Scaling Data
The moves you make when one database stops being enough — and the consistency you give up for each one.
6 topics
Vector Data
Storing embeddings next to the rows they describe — the database half of retrieval.
3 topics
Data Pipelines
Getting data out of the product database and somewhere useful, without lying about it.
4 topics