使用 Homebrew, Nix 安装 pg-schema-diff

项目链接

• 主页
• 软件包管理器页面

命令和别名

• pg-schema-diff

项目历史

Stripe developed pg-schema-diff to compare PostgreSQL schemas and generate the SQL needed to transform one into another. The project grew around online-migration techniques, temporary-database validation, hazard reporting, partition support, and both CLI and reusable Go-library interfaces.

采用历史

Stripe publishes the project as both a Go library and a command-line program. Official installation instructions support `go install`, Go modules, and Homebrew, enabling use in application tooling and database deployment workflows.

使用方式

Users describe a desired database schema with one or more DDL files, compare it with a live database, inspect the generated plan and hazards, and then apply approved changes. The CLI accepts DSNs and recommends PGPASSWORD for supplying a password without embedding it in the connection string.

为什么软件包爱好者会关心

pg-schema-diff brings declarative, plan-oriented migration behavior to PostgreSQL while exposing operational hazards before execution. Database tooling enthusiasts care about its use of native concurrent and staged PostgreSQL operations to reduce locks and downtime rather than relying only on handwritten sequential migrations.

时间线

• Initial project direction: Published by Stripe as a PostgreSQL schema-diffing Go library and CLI.
• Later development: Added safety-oriented planning features including hazard warnings, temporary-database validation, online index replacement, and strong partition support.
• Package-manager adoption: Distributed through Homebrew in addition to the Go toolchain.

Related projects

• The tool consumes PostgreSQL DDL and connection strings, uses native PostgreSQL migration operations, and publishes its library API through the official Go package documentation.

来源

• Official Go documentation: https://pkg.go.dev/github.com/stripe/pg-schema-diff
• Official README: https://github.com/stripe/pg-schema-diff#readme