Teaching Elephants to Fish - Managing PostgreSQL Schema and Code Changes

Explore the world of PostgreSQL schema and code management in this informative conference talk from PGConf NYC 2021. Discover how to overcome common challenges faced by PostgreSQL DBAs and developers in Agile environments, such as managing migrations and avoiding development bottlenecks. Learn about SQL-centric approaches to manage PostgreSQL as code, test changes, and deploy updates efficiently. Gain insights into popular tools like Sqitch, FlywayDB, pyrseas, and PostgresCompare, and understand how they can transform your PostgreSQL change management process. By the end of this 20-minute presentation, acquire the knowledge needed to tame rogue PostgreSQL databases, streamline migrations, and elevate your development team's efficiency.