§ 02.02 — Databases & Modeling
Data that grows cleanly.
Schemas built for how your data actually changes over time — fast queries, clean migrations, and indexes that are measured, not assumed.
schema · entity-relation diagram
§ Performance — Indexing is strategy
340 ms → 3 ms
The right index on the right column eliminates full-table scans. We profile production queries before adding indexes — not after users complain.
No index340 ms · full-table scan
B-tree index8 ms · orders.user_id
Partial index3 ms · WHERE status='open'
§ Capability — What we model
Built to outlast v1
01
Schema design
Tables shaped around your domain, not an ORM's opinion — normal forms where they help, denormalised where they don't.
02
Migrations
Every change is versioned, reversible and safe to run with zero downtime on a live database.
03
Indexing strategy
We profile queries first, index what's actually slow, and explain-plan every critical path.
04
Replication & backups
Read replicas, point-in-time recovery and tested restore procedures — before you need them.
Let's talk data