Database DevOps - It is Possible!
summary
Argues that databases can be part of continuous delivery by scripting migrations into version control and automating them with Flyway, an open‑source tool downloaded over 11 million times that tracks changes in a schema history table. Cites survey numbers: ~66% of teams still omit the database and >40% deploy DB changes weekly, causing bottlenecks. Shows a Jenkins pipeline using Flyway migrate (and commands like baseline, validate, clean, repair) to apply the same scripts from dev through CI; demo migrations run end‑to‑end.
AI-written summary · about
chapters (20)
- 0:00Introduction to Database DevOps
- 1:41DevOps Foundations
- 4:02Breaking Down Silos
- 6:18State of Database DevOps Survey
- 8:09Automating the Pipeline
- 10:21Dora Report Findings
- 11:54Overcoming Technical Challenges
- 13:33Managing Test Data
- 16:02Handling Database Drift
- 17:38Zero Downtime Strategies
- 20:02Rollback and Recovery
- 22:14Introducing Flyway
- 24:26Core Flyway Commands
- 26:01Advanced Flyway Usage
- 28:23Flyway Integrations
- 30:34Flyway Best Practices
- 34:05Workflow Tips
- 36:06Live Demo: Committing Changes
- 38:46Live Demo: Pipeline Execution
- 41:27Summary and Q&A
related talks
45mEnabling Continuous Delivery with Database Practices
36mUnlocking the Benefits of Database DevOps and Automation
31mDevOps Practices for the Database Team
01h 00mContinuous Integration and Delivery for Databases
50mBringing DevOps to the Database
27mDevOps and the Database Bottleneck
33mBringing DevOps To The Database
11mLightning Talk: Continuous Delivery…except for Database Changes