online_migrations VS zero-downtime-migrations

Compare online_migrations vs zero-downtime-migrations and see what are their differences.

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)

zero-downtime-migrations

Apply Django migrations on PostgreSql without long locks on tables (by yandex)
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
online_migrations zero-downtime-migrations
18 1
579 183
- 0.5%
9.0 4.3
3 days ago 2 months ago
Ruby Python
MIT License GNU General Public License v3.0 or later
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.

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.

zero-downtime-migrations

Posts with mentions or reviews of zero-downtime-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: Zero-downtime PostgreSQL migrations for Ruby on Rails
    10 projects | news.ycombinator.com | 20 Feb 2022
    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.

What are some alternatives?

When comparing online_migrations and zero-downtime-migrations you can also consider the following projects:

active_record_doctor - Identify database issues before they hit production.

django-zerodowntime - django migration utilities for zero downtime continuous delivery

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.

django-pg-zero-downtime-migrations - Django postgresql backend that apply migrations with respect to database locks

SchemaPlus - SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

safe-pg-migrations - Make your PostgreSQL migrations safe

Seed Fu - Advanced seed data handling for Rails, combining the best practices of several methods together.

SlackHook - A Simple Interface to Slack Incoming Webhooks Integrations

Seed dump - Rails 4/5 task to dump your data to db/seeds.rb

Foreigner - Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb