Hacker GitHub

← All repos

shayonj/pg-osc

View on GitHub ↗ ★ 621 Ruby

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

12 mentions on Hacker News by 9 people: 3 stories, 9 comments · first 2022-01-07 · latest 2026-07-22

Mentions per year 12 mentions · busiest year 2022 (5)
20082026
AllStoriesComments NewestTopOldest
  1. …to liquibase because it's the devil I know, but there's other tooling like Flyway which exists. [0] https://github.com/shayonj/pg-osc
    comment by mjr00 · 2026-07-22 · in The startup's Postgres survival guide
  2. Hey Paul! Try out pg-osc if you haven't already. I use it quite a bit for this type of thing. https://github.com/shayonj/pg-osc
    comment by brycethornton · 2024-12-18 · in Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
  3. Can you add https://github.com/shayonj/pg-osc ? It's my favorite PG migration tool.
    comment by brycethornton · 2024-12-11 · in Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
  4. …June 2023. https://github.com/xataio/pgroll * pg-osc: Written in Ruby, first commits Dec 2021. https://github.com/shayonj/pg-osc Meanwhile over in the MySQL and MariaDB ecosystem, external OSC tools have been around for quite some time,…
    comment by evanelias · 2024-05-07 · in How not to change PostgreSQL column type
  5. …work for very large teams and very large relational databases is online schema change tools like https://github.com/shayonj/pg-osc and https://github.com/github/gh-ost (the latter developed for GitHub’s monolith). It’s just too difficult…
    comment by semiquaver · 2024-02-18 · in My notes on Gitlab's Postgres schema design (2022)
  6. Great to see more innovation in this space! How does this compare to? https://github.com/shayonj/pg-osc
    comment by gvkhna · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  7. …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.
    comment by taspeotis · 2022-05-05 · in Zero downtime migrations
  8. …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…
    comment by shayonj · 2022-02-21 · in Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails
  9. …noodling on the concept of zero downtime schema changes in postgres as well, and recently started https://github.com/shayonj/pg-online-schema-change . Its inspired by pg_repack and pt-online-schema-change (mysql). I will give this a spin!…
    comment by shayonj · 2022-01-07 · in Zero-downtime schema migrations in Postgres using Reshape