{"repo":"xataio/pgroll","free":true,"listed":false,"github":"https://github.com/xataio/pgroll","clone":"git clone https://github.com/xataio/pgroll.git","description":"PostgreSQL zero-downtime migrations made easy","language":"Go","stars":6553,"topics":["golang","migrations","postgresql","zero-downtime","hacktoberfest","postgres","schema"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"            pgroll - Zero-downtime, reversible, schema migrations for Postgres pgroll 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. This includes ensuring changes are applied without locking the database, and that both old and new schema versions work simultaneously (even when breaking changes are being made!). This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks. See the introductory blog post for more about the problems solved by pgroll . Features - Zero-downtime migrations (no database locking, no breaking changes). - Keep old and new schema versions working simultaneously. - Automatic columns backfilling when needed. - Instant rollback in case of issues during migration. - Works against existing schemas, no need to start from scratch. - Works with Postgres 14.0 or later. - Works with any Postgres service (including RDS and Aurora). - Written in Go, cross-platform single binary with no external dependencies. Table of Contents - Installation - Usage - How pgroll works - Documentation - Benchmarks - Contributing - License - Support Installation Binaries Binaries are available for Linux, macOS & Windows, check our Re","default_branch":null,"files":null,"tree":[],"storefront":"/r/xataio","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/xataio/pgroll/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}