What does HackerNews think of pg-osc?

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

Language: Ruby

#74 in Command line interface

#48 in Database

#201 in Hacktoberfest

#30 in PostgreSQL

#50 in PostgreSQL

Pgroll: zero-downtime, undoable, schema migrations for Postgres | Oct 2023

Great to see more innovation in this space! How does this compare to?

https://github.com/shayonj/pg-osc

Zero downtime migrations | May 2022

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.

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

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.