Version Your Databases with Flyway
summary
Flyway manages database schema migrations by storing ordered SQL migration files and recording applied scripts in a flyway_schema_history table to make databases reproducible. At Canal+ they use Bitbucket and Jenkins to build a Docker image and run Flyway migrations automatically against PostgreSQL, using commands like baseline, validate, info, and (paid) undo; the talk notes the need for DB-specific SQL and team coordination to avoid conflicting migrations.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 3:27Why version databases
- 6:15Flyway quick start
- 9:23Canal+ workflow
- 10:04Flyway vs alternatives
- 12:07Conclusion
related talks
46mDatabase DevOps - It is Possible!
45mRewriting History: From Database Versioning Tools to Practice
52mManaging PostgreSQL changes for the Agile DBA
01h 10mReal World Iterative Database Development
49mThe Ultimate Showdown of Database Migration Tools
36mUnlocking the Benefits of Database DevOps and Automation
20mGetting Started Quickly with DB DevOps
44mThe Ultimate Showdown of Database Migration Tools
