PostgreSQL zero downtime migrations made easy with pgroll github.com/xataio/pgroll
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
October 19, 2025 at 2:30 AM
PostgreSQL zero downtime migrations made easy with pgroll github.com/xataio/pgroll
pgroll gets its own website 🎉
pgroll.com
The organic traction of pgroll has been great, so we're going to invest more into it.
Open-source zero-downtime, reversible, schema changes for PostgreSQL.
pgroll.com
The organic traction of pgroll has been great, so we're going to invest more into it.
Open-source zero-downtime, reversible, schema changes for PostgreSQL.
pgroll
Take the fear out of schema changes
pgroll.com
December 10, 2024 at 3:55 PM
pgroll gets its own website 🎉
pgroll.com
The organic traction of pgroll has been great, so we're going to invest more into it.
Open-source zero-downtime, reversible, schema changes for PostgreSQL.
pgroll.com
The organic traction of pgroll has been great, so we're going to invest more into it.
Open-source zero-downtime, reversible, schema changes for PostgreSQL.
pgroll looks amazing — it orchestrates the underlying (sorta tedious) mechanics of the expand-contract pattern for zero-downtime, hot-swap migrations in Postgres.
github.com/xataio/pgroll
github.com/xataio/pgroll
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
March 22, 2025 at 3:06 PM
pgroll looks amazing — it orchestrates the underlying (sorta tedious) mechanics of the expand-contract pattern for zero-downtime, hot-swap migrations in Postgres.
github.com/xataio/pgroll
github.com/xataio/pgroll
Who doesn’t love #postgres at this point? I’ve been following this project for awhile, worth spreading the word imo github.com/xataio/pgroll
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
November 27, 2024 at 4:16 AM
Who doesn’t love #postgres at this point? I’ve been following this project for awhile, worth spreading the word imo github.com/xataio/pgroll
Running a migration but don’t want a version schema?
Use --use-version-schema=false in pgroll 0.14
Trade side-by-side rollout for simplicity.
Read more here: xata.io/blog/pgroll-...
#Postgres #pgroll #DevTools #schemamigration #opensource
Use --use-version-schema=false in pgroll 0.14
Trade side-by-side rollout for simplicity.
Read more here: xata.io/blog/pgroll-...
#Postgres #pgroll #DevTools #schemamigration #opensource
pgroll 0.14 - new commands and control over version schemas by Andrew Farries
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
xata.io
July 11, 2025 at 12:43 PM
Running a migration but don’t want a version schema?
Use --use-version-schema=false in pgroll 0.14
Trade side-by-side rollout for simplicity.
Read more here: xata.io/blog/pgroll-...
#Postgres #pgroll #DevTools #schemamigration #opensource
Use --use-version-schema=false in pgroll 0.14
Trade side-by-side rollout for simplicity.
Read more here: xata.io/blog/pgroll-...
#Postgres #pgroll #DevTools #schemamigration #opensource
An open-source Go-based command-line tool that offers safe and reversible schema migrations for #PostgreSQL by serving multiple schema versions simultaneously
#golang
github.com/xataio/pgroll
#golang
github.com/xataio/pgroll
February 13, 2025 at 8:58 AM
An open-source Go-based command-line tool that offers safe and reversible schema migrations for #PostgreSQL by serving multiple schema versions simultaneously
#golang
github.com/xataio/pgroll
#golang
github.com/xataio/pgroll
🔥 New pgroll release! v0.11 brings:
🔌 YAML support for migrations
🕓 Timestamps now with timezone info
📛 `name` field is now optional
🎻 Tables without primary key or unique column can be backfilled
🧹 Better errors
Zero-downtime Postgres migrations, now smoother.
📖 Blog: pgroll.com/blog/pgroll-...
🔌 YAML support for migrations
🕓 Timestamps now with timezone info
📛 `name` field is now optional
🎻 Tables without primary key or unique column can be backfilled
🧹 Better errors
Zero-downtime Postgres migrations, now smoother.
📖 Blog: pgroll.com/blog/pgroll-...
pgroll 0.11.0 update: YAML migration, drop name requirement | pgroll
We've just released v0.10 of pgroll, our open-source schema migration tool for Postgres. It includes support for YAML migration files.
pgroll.com
April 8, 2025 at 4:19 PM
🔥 New pgroll release! v0.11 brings:
🔌 YAML support for migrations
🕓 Timestamps now with timezone info
📛 `name` field is now optional
🎻 Tables without primary key or unique column can be backfilled
🧹 Better errors
Zero-downtime Postgres migrations, now smoother.
📖 Blog: pgroll.com/blog/pgroll-...
🔌 YAML support for migrations
🕓 Timestamps now with timezone info
📛 `name` field is now optional
🎻 Tables without primary key or unique column can be backfilled
🧹 Better errors
Zero-downtime Postgres migrations, now smoother.
📖 Blog: pgroll.com/blog/pgroll-...
🧪 "pgroll validate" is here!
Check migration files for syntax that the objects referenced by a migration exist in the target database.
Spot issues like missing tables before they break CI/CD.
👉 xata.io/blog/pgroll-...
#PostgreSQL #pgroll #DevTools
Check migration files for syntax that the objects referenced by a migration exist in the target database.
Spot issues like missing tables before they break CI/CD.
👉 xata.io/blog/pgroll-...
#PostgreSQL #pgroll #DevTools
pgroll 0.14 - new commands and control over version schemas by Andrew Farries
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
xata.io
July 7, 2025 at 5:52 PM
🧪 "pgroll validate" is here!
Check migration files for syntax that the objects referenced by a migration exist in the target database.
Spot issues like missing tables before they break CI/CD.
👉 xata.io/blog/pgroll-...
#PostgreSQL #pgroll #DevTools
Check migration files for syntax that the objects referenced by a migration exist in the target database.
Spot issues like missing tables before they break CI/CD.
👉 xata.io/blog/pgroll-...
#PostgreSQL #pgroll #DevTools
Project link: github.com/xataio/pgroll
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
April 8, 2025 at 4:20 PM
Project link: github.com/xataio/pgroll
🚀 pgroll v0.14 is out!
New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions.
Read the release blog 👉 xata.io/blog/pgroll-...
#Postgres #pgroll #SchemaMigrations #DevOps
New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions.
Read the release blog 👉 xata.io/blog/pgroll-...
#Postgres #pgroll #SchemaMigrations #DevOps
pgroll 0.14 - new commands and control over version schemas by Andrew Farries
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
xata.io
July 4, 2025 at 11:59 AM
🚀 pgroll v0.14 is out!
New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions.
Read the release blog 👉 xata.io/blog/pgroll-...
#Postgres #pgroll #SchemaMigrations #DevOps
New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions.
Read the release blog 👉 xata.io/blog/pgroll-...
#Postgres #pgroll #SchemaMigrations #DevOps
🦋 pgroll v0.13.0 is live!
🎯 New: baseline support
Start using pgroll with existing schemas or compress 100s of migrations into one clean file.
⚠️ Note: "name" field in migration files is now deprecated.
Full details on our blog:
🎯 New: baseline support
Start using pgroll with existing schemas or compress 100s of migrations into one clean file.
⚠️ Note: "name" field in migration files is now deprecated.
Full details on our blog:
pgroll 0.13.0 - Easy pgroll onboarding using baseline feature by Andrew Farries
The new baseline feature in pgroll 0.13.0 makes it easy to start using pgroll on databases with existing schema and keep your schema histories clean.
xata.io
May 27, 2025 at 1:01 PM
🦋 pgroll v0.13.0 is live!
🎯 New: baseline support
Start using pgroll with existing schemas or compress 100s of migrations into one clean file.
⚠️ Note: "name" field in migration files is now deprecated.
Full details on our blog:
🎯 New: baseline support
Start using pgroll with existing schemas or compress 100s of migrations into one clean file.
⚠️ Note: "name" field in migration files is now deprecated.
Full details on our blog:
✨ Upgrading pgroll just became easier!
No need to manually fix old migration files for breaking changes.
"pgroll update" now auto-fixes outdated syntax (like create_index)!
Blog: xata.io/blog/pgroll-...
#pgroll #Postgres #DX #OpenSource
No need to manually fix old migration files for breaking changes.
"pgroll update" now auto-fixes outdated syntax (like create_index)!
Blog: xata.io/blog/pgroll-...
#pgroll #Postgres #DX #OpenSource
pgroll 0.14 - new commands and control over version schemas by Andrew Farries
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
xata.io
July 8, 2025 at 3:43 PM
✨ Upgrading pgroll just became easier!
No need to manually fix old migration files for breaking changes.
"pgroll update" now auto-fixes outdated syntax (like create_index)!
Blog: xata.io/blog/pgroll-...
#pgroll #Postgres #DX #OpenSource
No need to manually fix old migration files for breaking changes.
"pgroll update" now auto-fixes outdated syntax (like create_index)!
Blog: xata.io/blog/pgroll-...
#pgroll #Postgres #DX #OpenSource
Glad to be part of the pgroll project ⭐️
In the blog, I share what I’ve learned over the past year and how the product has evolved by incorporating real feedback from the field.
#pgroll
In the blog, I share what I’ve learned over the past year and how the product has evolved by incorporating real feedback from the field.
#pgroll
pgroll just passed 5,000 stars 🎉
What matters more:
🧠 35% of issues are from the community
🔍 Feedback led to real roadmap updates
🔄 Reversible, zero-downtime schema changes for Postgres
Thanks for helping shape the project!
🔗 xata.io/blog/pgroll-...
What matters more:
🧠 35% of issues are from the community
🔍 Feedback led to real roadmap updates
🔄 Reversible, zero-downtime schema changes for Postgres
Thanks for helping shape the project!
🔗 xata.io/blog/pgroll-...
Pgroll is on a roll! We reached 5k stars on Github by Gulcin Yildirim Jelinek
Pgroll is an open-source, zero-downtime, reversible schema migration tool built exclusively for Postgres. We’ve reached 5k stars on GitHub!
xata.io
July 18, 2025 at 3:19 PM
Glad to be part of the pgroll project ⭐️
In the blog, I share what I’ve learned over the past year and how the product has evolved by incorporating real feedback from the field.
#pgroll
In the blog, I share what I’ve learned over the past year and how the product has evolved by incorporating real feedback from the field.
#pgroll
pgroll just passed 5,000 stars 🎉
What matters more:
🧠 35% of issues are from the community
🔍 Feedback led to real roadmap updates
🔄 Reversible, zero-downtime schema changes for Postgres
Thanks for helping shape the project!
🔗 xata.io/blog/pgroll-...
What matters more:
🧠 35% of issues are from the community
🔍 Feedback led to real roadmap updates
🔄 Reversible, zero-downtime schema changes for Postgres
Thanks for helping shape the project!
🔗 xata.io/blog/pgroll-...
Pgroll is on a roll! We reached 5k stars on Github by Gulcin Yildirim Jelinek
Pgroll is an open-source, zero-downtime, reversible schema migration tool built exclusively for Postgres. We’ve reached 5k stars on GitHub!
xata.io
July 18, 2025 at 3:01 PM
pgroll just passed 5,000 stars 🎉
What matters more:
🧠 35% of issues are from the community
🔍 Feedback led to real roadmap updates
🔄 Reversible, zero-downtime schema changes for Postgres
Thanks for helping shape the project!
🔗 xata.io/blog/pgroll-...
What matters more:
🧠 35% of issues are from the community
🔍 Feedback led to real roadmap updates
🔄 Reversible, zero-downtime schema changes for Postgres
Thanks for helping shape the project!
🔗 xata.io/blog/pgroll-...
🔗 "pgroll latest url" gives you a ready-to-use Postgres connection string for the newest schema version.
Perfect for CD pipelines 🛠️
More: xata.io/blog/pgroll-...
#pgroll #Postgres #DevOps
Perfect for CD pipelines 🛠️
More: xata.io/blog/pgroll-...
#pgroll #Postgres #DevOps
pgroll 0.14 - new commands and control over version schemas by Andrew Farries
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
xata.io
July 9, 2025 at 12:43 PM
🔗 "pgroll latest url" gives you a ready-to-use Postgres connection string for the newest schema version.
Perfect for CD pipelines 🛠️
More: xata.io/blog/pgroll-...
#pgroll #Postgres #DevOps
Perfect for CD pipelines 🛠️
More: xata.io/blog/pgroll-...
#pgroll #Postgres #DevOps
Very cool! Would there a way to get no-downtime migrations using Drizzle, perhaps by integrating with github.com/xataio/pgroll?
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
February 20, 2025 at 11:33 AM
Very cool! Would there a way to get no-downtime migrations using Drizzle, perhaps by integrating with github.com/xataio/pgroll?
🛠️ pgroll v0.12.0 just dropped!
New in this release:
• Interactive create command
• --verbose mode for migration clarity
• Add primary keys with create_constraint
• migrate is now idempotent for safer CI
• YAML is default for pull
🦋 Read the blog:
New in this release:
• Interactive create command
• --verbose mode for migration clarity
• Add primary keys with create_constraint
• migrate is now idempotent for safer CI
• YAML is default for pull
🦋 Read the blog:
pgroll 0.12.0 update
pgroll v0.12 includes usability improvements like verbose mode and idempotent migrate command.
xata.io
May 9, 2025 at 3:14 PM
🛠️ pgroll v0.12.0 just dropped!
New in this release:
• Interactive create command
• --verbose mode for migration clarity
• Add primary keys with create_constraint
• migrate is now idempotent for safer CI
• YAML is default for pull
🦋 Read the blog:
New in this release:
• Interactive create command
• --verbose mode for migration clarity
• Add primary keys with create_constraint
• migrate is now idempotent for safer CI
• YAML is default for pull
🦋 Read the blog:
In the meantime we have been working on a convertor from SQL to pgroll JSON. It's the `convert` command from the latest release: github.com/xataio/pgrol...
Release v0.10.0 · xataio/pgroll
⚡ Highlights
🚎 Improve integration with ORMs: new subcommand convert to translate ORM SQL migrations scripts into pgroll migrations
🏄 Avoid ACCESS_EXCLUSIVE table lock when adding UNIQUE columns
🔓...
github.com
March 23, 2025 at 10:27 AM
In the meantime we have been working on a convertor from SQL to pgroll JSON. It's the `convert` command from the latest release: github.com/xataio/pgrol...
You first “expand” the table by adding a new column. You use them both for a period of time, backfill data, then you “contract” by dropping the old column.
pgroll automates this for you. For the "change type" migration type, it does pretty much exactly the above steps.
github.com/xataio/pgroll
pgroll automates this for you. For the "change type" migration type, it does pretty much exactly the above steps.
github.com/xataio/pgroll
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
November 24, 2024 at 11:10 AM
You first “expand” the table by adding a new column. You use them both for a period of time, backfill data, then you “contract” by dropping the old column.
pgroll automates this for you. For the "change type" migration type, it does pretty much exactly the above steps.
github.com/xataio/pgroll
pgroll automates this for you. For the "change type" migration type, it does pretty much exactly the above steps.
github.com/xataio/pgroll
🛠️ Just dropped pgroll v0.11.1 – a bugfix release based on real user reports.
🧩 Multi-operation migrations now:
• Preserve column comments + default values
• Generate valid SQL when duplicating columns
Big thanks to the community for surfacing this!
🦋 github.com/xataio/pgrol...
#pgroll #Postgres
🧩 Multi-operation migrations now:
• Preserve column comments + default values
• Generate valid SQL when duplicating columns
Big thanks to the community for surfacing this!
🦋 github.com/xataio/pgrol...
#pgroll #Postgres
Release v0.11.1 · xataio/pgroll
⚡ Highlights
🔍 Column comments and default values are preserved when a table is created in a multi-operation migration
🛹 Valid SQL statement is generated when duplicating columns during multi-oper...
github.com
April 15, 2025 at 12:03 PM
🛠️ Just dropped pgroll v0.11.1 – a bugfix release based on real user reports.
🧩 Multi-operation migrations now:
• Preserve column comments + default values
• Generate valid SQL when duplicating columns
Big thanks to the community for surfacing this!
🦋 github.com/xataio/pgrol...
#pgroll #Postgres
🧩 Multi-operation migrations now:
• Preserve column comments + default values
• Generate valid SQL when duplicating columns
Big thanks to the community for surfacing this!
🦋 github.com/xataio/pgrol...
#pgroll #Postgres
October 18, 2025 at 4:17 PM
🎉 pgroll 0.14 can now modify primary key columns with alter_column operation.
A long-standing issue, fixed!
Read more here: xata.io/blog/pgroll-...
Try it today → github.com/xataio/pgroll
#PostgreSQL #pgroll #DatabaseDev
A long-standing issue, fixed!
Read more here: xata.io/blog/pgroll-...
Try it today → github.com/xataio/pgroll
#PostgreSQL #pgroll #DatabaseDev
pgroll 0.14 - new commands and control over version schemas by Andrew Farries
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
xata.io
July 14, 2025 at 12:54 PM
🎉 pgroll 0.14 can now modify primary key columns with alter_column operation.
A long-standing issue, fixed!
Read more here: xata.io/blog/pgroll-...
Try it today → github.com/xataio/pgroll
#PostgreSQL #pgroll #DatabaseDev
A long-standing issue, fixed!
Read more here: xata.io/blog/pgroll-...
Try it today → github.com/xataio/pgroll
#PostgreSQL #pgroll #DatabaseDev