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.
DataGrip
A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
DBeaver
It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
