Managing PostgreSQL Changes for the Agile DBA - Exploring Tools and Techniques

Explore effective PostgreSQL change management strategies for Agile DBAs in this 52-minute conference talk from PGConf NYC 2021. Discover SQL-centric approaches to manage PostgreSQL as code, test changes, and deploy updates efficiently. Learn about tools like Sqitch, FlywayDB, pyrseas, and PostgresCompare to streamline schema and code changes. Gain insights into transforming your workflow, from database creation to deploying updates, and overcome common challenges faced by DBAs in Agile, Sprint-based teams. By the end, acquire the knowledge to tame rogue PostgreSQL databases, manage migrations with ease, and become an invaluable asset to your development team.

Introduction
Other presentations
What will be covered
The problem
Getting involved
Learning the team
What is devops
State of change management
Manual process
Join the circus
Current State of Database Change Management
Manual State
PostgreSQL Compare
StateBased
ORM
SQL migrations
Migration tools
Sketch
Conclusion