Schema Design & Migrations

Normal forms and denormalization, precomputed aggregates, soft deletes, online schema changes, and backfills.

0 / 5 solved
0/5 solved
Question Tags Difficulty Success
1. Rename Without Downtime
expand-contract-migrationzero-downtime-migration +1
Easy —
2. The Hot Counter
denormalizationprecomputed-aggregates +1
Medium —
3. Invalid But Still Costly
create-index-concurrentlymigrations +2
Medium —
4. Two Writes One Truth
dual-writeoutbox-pattern +1
Hard —
5. One Alter Two Outcomes
online-schema-changealter-table +2
Hard —

Up next

5 of 5 questions here are still unsolved.