Zero-downtime and reversible schema migrations with pgroll

pgroll (github.com/xat...) is an open source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated. This includes ensuring changes are applied without locking the database, and that both old and new schema versions work simultaneously (even when breaking changes are being made!). This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks.
Xata 🦋
This presentation and demo was brought to you by Xata (xata.io/), the serverless data platform for PostgreSQL. The full recording can be found here: • How to perform Postgre...
Follow Xata on Twitter: / xata
Come chat data with us on Discord: xata.io/discord

[@Jason-wx1tv]

Can you demonstrate how to work this into ci\cd?