pg-online-schema-change
Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL [Moved to: https://github.com/shayonj/pg-osc] (by shayonj)
reshape
An easy-to-use, zero-downtime schema migration tool for Postgres (by fabianlindfors)
Our great sponsors
pg-online-schema-change | reshape | |
---|---|---|
8 | 16 | |
82 | 1,632 | |
- | - | |
3.6 | 7.4 | |
about 2 years ago | about 1 month ago | |
Ruby | Rust | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg-online-schema-change
Posts with mentions or reviews of pg-online-schema-change.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-02-21.
-
pg-osc: Zero downtime non blocking schema changes in PostgreSQL
I wanted to share a new CLI tool (pg-osc) I built to make it easy and safe to perform schema changes and backfills in PostgreSQL.
-
pg-osc: Zero downtime schema changes in PostgreSQL
You can read more in depth here in the blog post and/or check out the Github repository: https://github.com/shayonj/pg-online-schema-change
- Show HN: Pg-osc: Zero downtime schema changes in PostgreSQL
- Zero downtime online schema changes in PostgreSQL
- PostgreSQL safe zero downtime schema changes
- pg-online-schema-change – tool for running safe schema changes in PostgreSQL
-
Zero-downtime schema migrations in Postgres using Reshape
This is very interesting, thanks for sharing. I had been noodling on the concept of zero downtime schema changes in postgres as well, and recently started https://github.com/shayonj/pg-online-schema-change. Its inspired by pg_repack and pt-online-schema-change (mysql).
I will give this a spin! Kudos
reshape
Posts with mentions or reviews of reshape.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-03.
- Show HN: Reshape – Zero-downtime schema migrations for Postgres
-
Pgroll: zero-downtime, undoable, schema migrations for Postgres
Cool stuff! Do you have any thoughts about how this compares to https://github.com/fabianlindfors/reshape?
-
Postgres schema changes are still a PITA
From what I know, there is only one project that tries something close to this: the relatively recent Reshape. It uses Postgres views to expose the two versions of the schema and triggers to upgrade/downgrade the new data. It doesn’t do the constraints part as described above, but shows that this approach is possible. Combined with the Xata pull request based workflow, I think the ideal system described above is possible!
-
Conceptually how do you handle deploys of SQL related things (table definition, scripts, stored procs etc) in a CI/CD way?
My idea is not unique. Reshape is similar, but bigger in scope.
-
The operational relational schema paradigm
This is precisely what I did for my automated zero-downtime migration tool and it works pretty well: https://github.com/fabianlindfors/reshape. At least for Postgres, simple views like these have almost no overhead as queries are simply rewritten for the underlying table.
-
Changing Tires at 100mph: A Guide to Zero Downtime Migrations
Anybody interested in this subject might also be interested in a tool for Postgres I’ve been working on, Reshape: https://github.com/fabianlindfors/reshape. It aims to fully automate away all the pain and manual steps zero-downtime migrations normally requires :)
- Reshape: An experimental, easy-to-use, zero-downtime migration tool for Postgres
-
PostgreSQL at Scale: Database Schema Changes Without Downtime
This post is absolutely terrific and has been been my main reference for Reshape, an automated, zero-downtime schema migration tool: https://github.com/fabianlindfors/reshape
- When Postgres blocks: tips for dealing with locks
- Reshape
What are some alternatives?
When comparing pg-online-schema-change and reshape you can also consider the following projects:
gh-ost - GitHub's Online Schema-migration Tool for MySQL
pgroll - PostgreSQL zero-downtime migrations made easy