Daniel Reyes
Production Postgres for App Developers
Indexes, transactions and migrations that don't wake you up at 3am.
3 sections · 7 lessons · 0:00 total
$129
One-time payment · Lifetime access
About this course
You know SQL. This course is about what happens when real traffic arrives: slow queries, lock contention, zero-downtime migrations and idempotent webhooks.
Curriculum
01Reading the database
2 lessons- EXPLAIN ANALYZE, demystifiedPreview--:--
- Index design by access pattern--:--
02Correctness under load
3 lessons- Transactions and isolation levels--:--
- Row locks and SELECT … FOR UPDATE--:--
- Idempotent webhook handlers--:--
03Change without downtime
2 lessons- Expand/contract migrations--:--
- Backfills that don't melt the primary--:--