Your database migrations are bad and you should feel bad

Date: 2017-09-08
Time: 20:30 - 21:20
Room: Mission
Level: Intermediate

It's really hard to work with database schemas. But schemas are actually good. Enforcing structure and consistency of data is good. The trouble is
that people get frustrated with the tooling.

Existing migration tools all make it far too hard. When you have to worry about version numbers and migration files each time you want to make a change, it makes it every change a chore. It's tedious, manual, error-prone, and hard to test.

When it's harder than it should be to change your schema, it becomes hard to
manage your data properly, harder to rapidly prototype, and an operational
overhead each time you make a change.

Fortunately, we can do better! We'll discuss a radically different approach to managing schema migrations, using new tools and workflows to make it much faster, mostly automatic, fully testable, and more reliable.


Robert Lechte