Pgroll: zero-downtime, undoable, schema migrations for Postgres

1. pgroll

   1 21 4,469 9.5 Go

   PostgreSQL zero-downtime migrations made easy

   

   An example would make this more concrete.

   This migration[0] adds a CHECK constraint to a column.

   When the migration is started, a new column with the constraint is created and values from the old column are backfilled using the 'up' SQL from the migration. The 'up' SQL rewrites values that don't meet the constraint so that they do.

   The same 'up' SQL is used 'on the fly' as data is written to the old schema by applications - the 'up' SQL is used (as part of a trigger) to copy data into the new column, rewriting as necessary to ensure the constraint on the new column is met.

   As the sibling comment makes clear, it is currently the migration author's responsibility to ensure that the 'up' SQL really does rewrite values so that they meet the constraint.

   [0] - https://github.com/xataio/pgroll/blob/main/examples/22_add_c...

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. reshape

   2 18 1,736 5.9 Rust

   An easy-to-use, zero-downtime schema migration tool for Postgres

   

   Cool stuff! Do you have any thoughts about how this compares to https://github.com/fabianlindfors/reshape?

4. pg-osc

   3 8 561 6.3 Ruby

   Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

   

   Great to see more innovation in this space! How does this compare to?

   https://github.com/shayonj/pg-osc

5. quantumdb

   4 1 61 0.0 Java

   Zero-downtime schema evolution for PostgreSQL

   

   Very cool! Congratulations to the authors on the release! I'm the author of a similar (zero-downtime migration) tool for PG called QuantumDB[0]. It was the first (to my knowledge at least) tool to support foreign keys, by creating table copies (keeping those in sync using triggers), and exposing multiple schemas through a custom database driver. I never got to production-ready version unfortunately, but I'm happy this one did. I'm seeing a lot of familiar concepts, and it looks well thought out.

   [0] https://github.com/quantumdb/quantumdb

6. atlas

   5 72 6,315 9.7 Go

   Manage your database schema as code (by ariga)

   

   Check out: https://github.com/ariga/atlas

   (I'm one of the authors of this project).

7. migra

   6 25 2,935 0.0 Python

   Like diff but for PostgreSQL schemas

   

   Forr postgres, how does the schema diffing aspect compare to migra?

   https://github.com/djrobstep/migra

   I'm asking because, although migra is excellent and there are multiple migrations tools based on it (at least https://github.com/bikeshedder/tusker and https://github.com/blainehansen/postgres_migrator), issues are piling up but development seem to be slowing down

8. tusker

   7 9 221 5.8 Python

   PostgreSQL migration management tool

   Forr postgres, how does the schema diffing aspect compare to migra?

   https://github.com/djrobstep/migra

   I'm asking because, although migra is excellent and there are multiple migrations tools based on it (at least https://github.com/bikeshedder/tusker and https://github.com/blainehansen/postgres_migrator), issues are piling up but development seem to be slowing down

9. postgres_migrator

   8 7 96 7.5 Rust

   A postgres migration generator and runner that uses raw declarative sql.

   

   Forr postgres, how does the schema diffing aspect compare to migra?

   https://github.com/djrobstep/migra

   I'm asking because, although migra is excellent and there are multiple migrations tools based on it (at least https://github.com/bikeshedder/tusker and https://github.com/blainehansen/postgres_migrator), issues are piling up but development seem to be slowing down

Suggest a related project