PGConf NYC 2021 - Managing PostgreSQL changes for the Agile DBA by Ryan Booz

Managing PostgreSQL changes for the Agile DBA by Ryan Booz Whether you are the PostgreSQL DBA for an Agile, Sprint-based team, or a Developer with DBA responsibilities, you may feel like the development bottleneck at every turn. Managing migrations with your ORM of choice is easy but often error-prone and hard to manage as the project grows. Or worse yet, maybe your schema and change management is a folder full of poorly commented SQL scripts saved to a local folder. Surely there's a better, SQL-centric way to manage PostgreSQL as code, test changes, and deploy updates - right? Yes, there is! In this session, we'll explore the current state of tooling to manage PostgreSQL schema and code changes. By demonstrating the process from database creation to deploying changes, you'll see how common tools like Sqitch, FlywayDB, pyrseas, PostgresCompare, and others can provide the foundation you need to transform how you manage PostgreSQL changes within your daily work. By the end of the session, you'll be ready to tame your rogue PostgreSQL databases, managing changes and migrations with ease, and become the envy of the development team.