Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails

• online_migrations

  18 582 9.1 Ruby

  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).

Thanks for mentioning. I made a comparison with it - https://github.com/fatkodima/online_migrations#cool-but-ther...

• migration_signature

  1 4 4.4 Ruby

  Generate signatures for Rails migration files when they are run and check them in CI.

  

This is cool. We use strong_migrations but I’ll check this out. I love the idea of an enforced pattern for background data migrations.

While I’m here a shameless plug for a gem we built that we’ve found incredibly helpful for safer migrations - https://github.com/TandaHQ/migration_signature

It adds a CI check to guarantee the migrations you tested in development are actually the migrations that run in production.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• django-zerodowntime

  1 0 10.0 Python

  django migration utilities for zero downtime continuous delivery

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.

• django-check-migration-wtf

  1 11 0.0 Python

  check migrations of django to work on enviroment zero downtime

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.

• zero-downtime-migrations

  1 183 4.3 Python

  Apply Django migrations on PostgreSql without long locks on tables

  

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.

• django-pg-zero-downtime-migrations

  1 503 7.0 Python

  Django postgresql backend that apply migrations with respect to database locks

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.

• safe-pg-migrations

  6 482 8.5 Ruby

  Make your PostgreSQL migrations safe

  

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• nandi

  1 124 5.1 Ruby

  Fear free PostgreSQL migrations for Rails

  

We have something similar https://github.com/gocardless/nandi

It does signature checking and some and some other helpful things.

• pg-osc

  7 484 7.6 Ruby

  Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

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.

Suggest a related project