04.3.5 · Skill in Data engineering

Schema migrations

Changing the database structure safely while the product keeps running.

Migrations evolve the schema in versioned steps. Safe migrations avoid locking tables and stay compatible with the code running before and after the deploy. Expand and contract patterns let you change data without downtime.

Your status · Schema migrations

Not startedLearningComfortable

Saved in this browser only. It colours this skill's tile on your map.

Resources

articleStart here
Parallel change ↗
Danilo Sato (martinfowler.com) · 6 min
Expand, migrate, contract. The pattern behind changing schemas and APIs without breaking running code.
articleGo deeper
Evolutionary database design ↗
Pramod Sadalage and Martin Fowler · 40 min
How to change a database schema in small, safe steps alongside the code that uses it.

Tools

none yet

Tools for this topic are being researched.