xataio/pgroll on Hacker News

…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

…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

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

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

…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

…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

▲ 2

GitHub Discussions for Pgroll Project

story by gulcin · 2025-02-24 · 1 comment

…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

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)

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

▲ 121

pgroll: PostgreSQL zero-downtime migrations made easy

story by tosh · 2024-09-22 · 5 comments

▲ 3

Pgroll: Zero-downtime, reversible, schema migrations for PostgreSQL

story by klaussilveira · 2024-05-28 · 0 comments

…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

…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

…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

▲ 4

PostgreSQL zero-downtime and reversible migrations

story by todsacerdoti · 2024-01-30 · 0 comments

…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

…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

…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

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

…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

…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

I did find this: https://github.com/xataio/pgroll

comment by hosh · 2023-10-03 · in Pgroll: zero-downtime, reversible schema migrations for Postgres

…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

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

…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