What is Pgroll?
It is an open-source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated.
Pgroll is a tool in the Databases category of a tech stack.
Key Features
Zero-downtime migrations (no database locking, no breaking changes)Keep old and new schema versions working simultaneouslyAutomatic columns backfilling when neededInstant rollback in case of issues during migration
Pgroll Pros & Cons
Pros of Pgroll
No pros listed yet.
Cons of Pgroll
No cons listed yet.
Pgroll Alternatives & Comparisons
What are some alternatives to Pgroll?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
Dataform
Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
