Get the latest tech news
pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated. This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks. On migration start, it will perform all the additive changes (create tables, add columns, etc) in the physical schema, without breaking it.
Or read this on Hacker News