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

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Scout Monitoring - Performance metrics and, now, Logs Management Monitoring with Scout Monitoring
Get early access to Scout Monitoring's NEW Ruby logging feature [beta] by signing up now. Start for free and enable logs to get better insights into your Rails apps.
www.scoutapm.com
featured
InfluxDB - 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.
www.influxdata.com
featured
  • 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).

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

  • Scout Monitoring

    Performance metrics and, now, Logs Management Monitoring with Scout Monitoring. Get early access to Scout Monitoring's NEW Ruby logging feature [beta] by signing up now. Start for free and enable logs to get better insights into your Rails apps.

    Scout Monitoring logo
  • migration_signature

    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.

  • django-zerodowntime

    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

    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

    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

    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

    Make your PostgreSQL migrations safe

  • InfluxDB

    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.

    InfluxDB logo
  • nandi

    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

    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.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • This Week In Python

    5 projects | dev.to | 28 Oct 2022
  • Pg_lakehouse: Query Any Data Lake from Postgres

    7 projects | news.ycombinator.com | 13 May 2024
  • Serious: The differences between django-bootstrap5 and django-bootstrap-v5

    4 projects | /r/django | 7 Jul 2023
  • Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

    4 projects | news.ycombinator.com | 6 Jul 2023
  • Are stupid database questions allowed? If a database is backed up only every hour, do we just lose the unbacked up data within the one hour time frame?

    2 projects | /r/devops | 27 May 2023

Did you konow that Ruby is
the 12th most popular programming language
based on number of metions?