- Context: in a team, the database schema constantly evolves — people add tables, remove things, change the schema
9:48. - Solution: manage schema changes over time with versioned scripts kept in git, just like normal source code
10:26. - Example evolution
10:26:- v1 —
userstable with onlyidandname. - v2 — add
emailtousers. - v3 — add a new
orderstable.
- v1 —
- Benefit: you can track the evolution of the database across versions; the alternative — one giant SQL file — "doesn't work"
10:26.
Chapter notes
11 — Migrations
Amigoscode · 13:17 · English