Managing PostgreSQL changes for the Agile DBA
summary
Experience managing thousands of tenant databases leads to concrete tradeoffs: Sqitch gives deploy/verify/revert SQL-centric steps, FlywayDB adds repeatable migrations and paid undo support under Redgate, pyrseas exports a YAML one-file-per-object state that makes diffs and branching practical, and PostgresCompare produces GUI schema diffs but misses TimeScale hypertable internals. Demos show generated migration scripts, verification failures, and when tools succeed or require manual tweaks — so choose by whether it produces auditable SQL, verifications, and repeatable rollouts.
AI-written summary · about
chapters (19)
- 0:00Introduction
- 2:35Other presentations
- 2:53What will be covered
- 4:22The problem
- 8:26Getting involved
- 9:19Learning the team
- 10:40What is devops
- 15:38State of change management
- 16:30Manual process
- 16:50Join the circus
- 17:39Current State of Database Change Management
- 21:25Manual State
- 22:50PostgreSQL Compare
- 29:05StateBased
- 36:50ORM
- 39:22SQL migrations
- 40:51Migration tools
- 43:04Sketch
- 49:10Conclusion
related talks
30mPuny to Powerful PostgreSQL Rails Apps
36mUnlocking the Benefits of Database DevOps and Automation
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success
29mYour database migrations are bad and you should feel bad
48mDevOps Discovery: Navigating the Database Landscape
20mCrossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
36mPostgreSQL: Ups, DevOps...
16mVersion Your Databases with Flyway