django-pg-zero-downtime-migrations
pg-osc
Our great sponsors
| django-pg-zero-downtime-migrations | pg-osc | |
|---|---|---|
| 1 | 6 | |
| 503 | 477 | |
| - | - | |
| 7.0 | 7.9 | |
| about 3 hours ago | 14 days ago | |
| Python | Ruby | |
| MIT License | MIT License |
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.
django-pg-zero-downtime-migrations
-
Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails
While it hasn't been updated in a while, fundamentally https://github.com/pombredanne/django-zerodowntime would be a base for building similar check logic in a DB agnostic way on Django. It has some of the most important checks in place, but could obviously do with adding more sophisticated checks.
For Django users using PostgreSQL you can use https://github.com/antonioIrizar/django-check-migration-wtf or https://github.com/yandex/zero-downtime-migrations or https://github.com/tbicr/django-pg-zero-downtime-migrations to provide similar functionality to the library this post links to, depending on your exact use case of course.
pg-osc
-
Pgroll: zero-downtime, undoable, schema migrations for Postgres
Great to see more innovation in this space! How does this compare to?
https://github.com/shayonj/pg-osc
- Want to avoid MySQL but find PlanetScale really appealing
-
Changing Tires at 100mph: A Guide to Zero Downtime Migrations
Postgres has some less robust tooling, at least both of these carry the "experimental" tag:
https://news.ycombinator.com/item?id=29825520
https://github.com/shayonj/pg-osc
But, still, they do it for you.
- Alter PostgreSQL tables without locks and downtime
-
pg-osc: Zero downtime non blocking schema changes in PostgreSQL
You can also try it out, Github: https://github.com/shayonj/pg-osc
-
Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails
This is very cool! I no longer work on Rails on daily basis, but would have loved to have this.
I built something similar called `pg-osc` / `pg-online-schema-change` for PostgreSQL workloads. It does zero downtime migrations using triggers and shadow table.
Github: https://github.com/shayonj/pg-osc.
Blog: https://www.shayon.dev/post/2022/47/pg-osc-zero-downtime-sch...
Also love that this is written in Ruby :). Going to check it out on some side projects.
What are some alternatives?
safe-pg-migrations - Make your PostgreSQL migrations safe
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]
django-zerodowntime - django migration utilities for zero downtime continuous delivery
nandi - Fear free PostgreSQL migrations for Rails
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
migration_signature - Generate signatures for Rails migration files when they are run and check them in CI.
tusker - PostgreSQL migration management tool
django-check-migration-wtf - check migrations of django to work on enviroment zero downtime
pgroll - PostgreSQL zero-downtime migrations made easy
zero-downtime-migrations - Apply Django migrations on PostgreSql without long locks on tables
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.