Notes
Study notes I keep for myself. Each one is a full pass over a topic: the concept, the code, the trap, and a recall checklist at the end.
- 01
Designing APIs
HTTP semantics, idempotency, pagination, versioning and error contracts — the parts of API design that come up when someone asks you to defend a decision.
14 sections
- 02
Relational Data Models
Normalization, keys, constraints as design, isolation levels and write skew — modelling data so that the invariant survives the code that forgets it.
13 sections
- 03
Diagnosing Slow Queries
Reading EXPLAIN ANALYZE, join strategies, index selection and the cases where the query was never the problem.
13 sections
- 04
Safe Database Changes
Expand and contract, the locks DDL really takes, batched backfills, and shipping schema changes to a live system without downtime.
11 sections