Teaching elephants to fish 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.
- PGConf NYC 2021 - Teaching elephants to fish by Ryan Booz ( Download)
- PGConf NYC 2021 - Teaching elephants to fish by Ryan Booz ( Download)
- PGConf NYC 2021 - Managing PostgreSQL changes for the Agile DBA by Ryan Booz ( Download)
- Advent of Code 2022 - Day 1 with PostgreSQL ( Download)
- What you'll learn from my session - Ryan Booz ( Download)
- Ryan Booz on everything PostgreSQL at PASS 2023 | PASS Data Community Summit ( Download)
- My favorite ways to learn more about PostgreSQL w/Grant Fritchey & Ryan Booz |Path To Citus Con Ep05 ( Download)
- 2019 CodeMash Lightning Talks - Ryan Booz ( Download)
- Dok Specials - Ask us anything about Postgres ( Download)
