pgroll 0.14 - New commands and more control over version schemas
pgroll 0.14 is released with several new subcommands and better control over how version schema are created.
By Andrew Farries
pgroll v0.13.0: Start using pgroll on existing databases with the new baseline feature
The new baseline feature in pgroll v0.13 makes it easy to start using pgroll on databases with existing schema and keep your schema histories clean.
By Andrew Farries
pgroll v0.12.0: create command, verbose mode & idempotent migrate command
pgroll v0.12 includes usability improvements like the new create command, verbose mode and idempotent migrate command
By Noémi Ványi
pgroll v0.11.0: YAML migration support, pgroll.migration table improvements & more
pgroll v0.11 includes support for YAML migration files, a fix for the bookkeeping of pgroll, and smaller usability improvements.
By Noémi Ványi
pgroll 0.10.0 update
pgroll v0.10 includes one breaking change, a new subcommand to convert SQL statements into pgroll operations and improvements to adding default values to existing tables.
By Andrew Farries and Noémi Ványi
pgroll 0.9.0 update
pgroll v0.9 includes one breaking change, several improvements to table level constraint definitions and better CLI feedback
By Andrew Farries
Postgres Cafe: Exploring pgroll for zero-downtime schema changes
Discover how pgroll helps teams manage schema changes with ease in our new Postgres Cafe blog and video series.
By Gulcin Yildirim Jelinek
pgroll v0.8.0: Support for multi-column primary keys, multi-column constraints & new CLI commands
Learn about the latest changes in pgroll in the v0.8.0 release as we add new CLI commands, expand what's possible with multi-column keys and constraints and add performance benchmarks.
By Andrew Farries
Schema changes and the power of expand-contract with pgroll
A pgconf EU talk recap covering how the expand-contract pattern and pgroll enable zero-downtime schema changes and rollbacks.
By Andrew Farries
pgroll 0.7.0 update
Learn about the latest changes in pgroll in the 0.7.0 release as we continue developing it into a leading open-source schema migration tool for Postgres.
By Andrew Farries
pgroll v0.6.0: Retry logic, alter multiple columns in one operation, raw SQL migrations & more
Learn about the latest changes in pgroll in the 0.6.0 release as we continue to build and turn it into a first-class open-source schema migration tool for Postgres.
By Andrew Farries
Introducing multi-version schema migrations
Today's release of multi-version schema migrations addresses one of the most common pain points of application deployment - keeping your application code and database schema in sync. You can now present two versions of your schema, both old and new, to client applications.
By Andrew Farries
Get started with Xata
Sign up to access the Xata platform.