safe-pg-migrations
Make your PostgreSQL migrations safe (by doctolib)
online_migrations
Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc). (by fatkodima)
Our great sponsors
| safe-pg-migrations | online_migrations | |
|---|---|---|
| 6 | 18 | |
| 478 | 579 | |
| 1.9% | - | |
| 8.5 | 9.0 | |
| 5 days ago | 7 days ago | |
| Ruby | Ruby | |
| 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.
safe-pg-migrations
Posts with mentions or reviews of safe-pg-migrations.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-02-20.
- Show HN: safe-pg-migrations, ActiveRecord migrations for Postgres made safe
- Gérer ses migrations sans downtime
- Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails
-
Database... or Goose?
ps. the gem being showcased here is https://github.com/doctolib/safe-pg-migrations
At Doctolib, we developed safe-pg-migrations, a tool which automatically makes migrations safe. In 2018, we open-sourced this library. From an internal solution developed by our team only, it is now used on other projects, and even received contribution from external authors.
-
Release a new gem version
At Doctolib, we proudly maintain and develop the gem safe-pg-migrations, which makes migrations safer. Once in a while, after each relevant updates, we release a new version.
online_migrations
Posts with mentions or reviews of online_migrations.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-17.
-
Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails
Or simply use https://github.com/fatkodima/online_migrations and don’t get bitten by migrations in production again.
-
Gemfile of dreams: the libraries we use to build Rails apps
I would like to suggest for consideration a more feature-rich alternative to "strong_migrations" - https://github.com/fatkodima/online_migrations (there is a comparison with it in the README).
-
Is there a linter for non-backwards-compatible DB migrations?
There is kinda such a linter, but for ruby/rails projects - https://github.com/fatkodima/online_migrations.
-
Zero-downtime schema migrations for Ruby on Rails
For other people looking into zero-downtime migrations: you may also consider easier to use ruby-based tool for this https://github.com/fatkodima/online_migrations
- Zero-downtime PostgreSQL migrations for Ruby on Rails
- online_migrations: a new release with more safe/unsafe operations and ability to reset counter caches in background
-
The Rules of Clean and (Mostly) Painless Migrations
For ruby users, there is an existing gem that helps with this: https://github.com/fatkodima/online_migrations
- Catch unsafe PostgreSQL migrations in development and run them easier in production
-
Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails
Thanks for mentioning. I made a comparison with it - https://github.com/fatkodima/online_migrations#cool-but-ther...
What are some alternatives?
When comparing safe-pg-migrations and online_migrations you can also consider the following projects:
strong_migrations - Catch unsafe migrations in development
active_record_doctor - Identify database issues before they hit production.
migration_signature - Generate signatures for Rails migration files when they are run and check them in CI.
Scenic - Versioned database views for Rails
pg-osc - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL
Polo - Polo travels through your database and creates sample snapshots so you can work with real world data in development.
ghost_adapter - Run ActiveRecord migrations through gh-ost
SchemaPlus - SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
Large Hadron Migrator - Online MySQL schema migrations
Seed Fu - Advanced seed data handling for Rails, combining the best practices of several methods together.
flipper - 🐬 Beautiful, performant feature flags for Ruby.
SlackHook - A Simple Interface to Slack Incoming Webhooks Integrations
safe-pg-migrations vs strong_migrations
online_migrations vs active_record_doctor
safe-pg-migrations vs migration_signature
online_migrations vs Scenic
safe-pg-migrations vs pg-osc
online_migrations vs Polo
safe-pg-migrations vs ghost_adapter
online_migrations vs SchemaPlus
safe-pg-migrations vs Large Hadron Migrator
online_migrations vs Seed Fu
safe-pg-migrations vs flipper
online_migrations vs SlackHook