Glad to see #pgroll popping up in my timeline 🎉

If anyone has questions or feedback I am here 📝

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

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.

🎉 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

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.

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

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.

You can now name your own version schema 🎯

No more relying on migration file names.

Flexible naming with "version_schema:" in YAML.

Details 👉 xata.io/blog/pgroll-...

#pgroll #Postgres #SchemaMigrations

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.

🔗 "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

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.

✨ 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

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.

🧪 "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

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.

🚀 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

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...

🛠️ 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

I loved being a part of this meetup! Thanks for organizing it @sqlliz.bsky.social 👏🏼 And great talks from Ryan and David 👏🏼

The meetup was recorded, so if you missed it you can check it out later. #schemamigration #pgroll #flyway #sqitch #postgres