pg-schema-diff
A Go library for diffing Postgres schemas and generating SQL migrations with minimal downtime and locks.
What is pg-schema-diff?
pg-schema-diff is a Go library that computes differences between PostgreSQL database schemas and generates SQL migration scripts. It solves the problem of safely applying schema changes by producing migration plans that use PostgreSQL's native online operations to minimize downtime and avoid locking. This allows developers to manage database schema evolution declaratively and with reduced risk.
Database administrators, backend engineers, and DevOps teams who manage PostgreSQL databases and need to apply schema changes with minimal disruption. It's particularly useful for teams practicing declarative infrastructure and continuous deployment.
Developers choose pg-schema-diff because it generates migration plans that prioritize safety and minimal downtime by leveraging PostgreSQL's built-in online operations. Its hazard warning system and plan validation provide confidence, reducing the risk of production incidents during schema migrations.
Overview
Go library for diffing Postgres schemas and generating SQL migrations
Use Cases
Best For
- Applying declarative schema changes to PostgreSQL databases
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
