Hacker GitHub

← All repos

xataio/pgroll

View on GitHub ↗ ★ 6,613 Go

PostgreSQL zero-downtime migrations made easy

26 mentions on Hacker News by 16 people: 4 stories, 22 comments · first 2023-10-01 · latest 2026-04-16

Mentions per year 26 mentions · busiest year 2023 (10)
20082026
AllStoriesComments NewestTopOldest
  1. …shenanigans (the only barrier for me is json-based migration instead of sql-based migrations) [1] https://github.com/xataio/pgroll
    comment by microflash · 2026-04-16 · in Cal.com is going closed source
  2. …https://news.ycombinator.com/item?id=46845239 pgschema: https://github.com/pgschema/pgschema pg_roll: https://github.com/xataio/pgroll atlas: https://github.com/ariga/atlas grate (minimal SQL-based migrations):…
    comment by canadiantim · 2026-02-05 · in Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite
  3. It's Postgres specific but there is https://github.com/xataio/pgroll which takes the automation a step further.
    comment by mebcitto · 2025-10-16 · in Liquibase continues to advertise itself as "open source" despite license switch
  4. For a tooling solution for this problem, and many others, pgroll ( https://github.com/xataio/pgroll ) automates the steps from the blog post in a single higher-level operation. It can do things like adding a hidden column, backfill it with…
    comment by tudorg · 2025-07-25 · in Nullable but not null
  5. …have you seen the open-source tool we developed to tackle this problem? It is called pgroll: https://github.com/xataio/pgroll Any feedback is appreciated!
    comment by gulcin · 2025-02-27 · in EdgeDB is now Gel and Postgres is the future
  6. …rollbacks, and more high-level options like backfilling in batches. You can check the repo here: https://github.com/xataio/pgroll
    comment by gulcin · 2025-02-27 · in EdgeDB is now Gel and Postgres is the future
  7. …schema diffing, hadn’t come across it before, so thanks for mentioning it! Have you seen pgroll? https://github.com/xataio/pgroll It is a Postgres schema migration tool for achieving zero downtime, minimal locking schema changes. Thought…
    comment by gulcin_xata · 2024-12-16 · in Ask HN: Seeking feedback on my Postgres TypeScript thing
  8. https://github.com/xataio/pgroll/issues/281 may be worth a :+1: even though it seems from tudorg's comment that they're really wedded to .json :-(
    comment by mdaniel · 2024-12-11 · in Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
  9. …for the "up" / "down" data migrations. The issue where sql2pgroll is tracked is this one: https://github.com/xataio/pgroll/issues/504
    comment by tudorg · 2024-12-11 · in Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
  10. …recently! The only two I'm aware of are: * pgroll: Written in Golang, first commits 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…
    comment by evanelias · 2024-05-07 · in How not to change PostgreSQL column type
  11. …xataio - they submitted pgroll a few months back https://news.ycombinator.com/item?id=37752366 ( https://github.com/xataio/pgroll - Apache 2)
    comment by mdaniel · 2024-04-08 · in Building a Managed Postgres Service in Rust
  12. …4 months ago | hide | past | favorite | 149 comments https://news.ycombinator.com/item?id=37752366 https://github.com/xataio/pgroll
    comment by e12e · 2024-02-18 · in Revolutionizing PostgreSQL Schema Changes with pg-osc
  13. …would violate the invariant that the old schema must remain usable alongside the new one. [0] - https://github.com/xataio/pgroll/tree/main/docs#operations-r...
    comment by surjection · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  14. …executes the backfill mechanism to update any new column. More details can be found here: https://github.com/xataio/pgroll/blob/main/pkg/migrations/ba...
    comment by exekias · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  15. …to ensure that the 'up' SQL really does rewrite values so that they meet the constraint. [0] - https://github.com/xataio/pgroll/blob/main/examples/22_add_c...
    comment by surjection · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  16. To do this with pgroll I would use an alter_column migration, changing the type: https://github.com/xataio/pgroll/tree/main/docs#change-type , this would: 1) Create a new column with the desired type (numeric[][] in your case) 2) Backfill…
    comment by exekias · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  17. …with further expansion. [0] - https://www.postgresql.org/docs/current/ddl-schemas.html#DDL... [1] - https://github.com/xataio/pgroll/blob/main/docs/README.md#cl...
    comment by surjection · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  18. …Hopefully I got that right. [0] https://www.postgresql.org/docs/current/ddl-schemas.html [1] https://github.com/xataio/pgroll/blob/main/pkg/roll/execute.... [3] https://stackoverflow.com/a/67525360
    comment by dboreham · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  19. I did find this: https://github.com/xataio/pgroll
    comment by hosh · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  20. …is still working during the whole process. There is a graph in the readme depicting this concept: https://github.com/xataio/pgroll/blob/main/docs/img/migratio...
    comment by exekias · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  21. hey HN, repo is here: https://github.com/xataio/pgroll Would love to hear your thoughts!
    comment by tudorg · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres
  22. …this as an open source project this week, but actually it is already public, so if you are curious: https://github.com/xataio/pgroll
    comment by tudorg · 2023-10-01 · in Database Migrations