pgroll

pgroll

"Zero-downtime, reversible, schema migrations for Postgres"

I love this kind of thing. This one is has a really interesting design: you define your schema modifications (adding/dropping columns, creating tables etc) using a JSON DSL, then apply them using a Go binary.

When you apply a migration the tool first creates a brand new PostgreSQL schema (effectively a whole new database) which imitates your new schema design using PostgreSQL views. You can then point your applications that have been upgraded …

apply binary brand design downtime etc json kind love migration migrations postgres postgresql schema tables them tool zerodowntime