pg-schema-diff

What's Changed

• Use logfmt for plan modifiers by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/109
• Add support for altering sequences by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/113
• Bump pgx dependency and to go 1.20 by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/117
• Make data-packing toggle-able by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/119
• Add enum support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/120
• Exclude temporary schemas by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/122
• Update get schema hash by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/123
• Exclude schemas owned by extensions by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/127
• [CLI] Add flag to disable plan validation by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/130
• Add ability to skip apply confirm prompt by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/134
• RLS Policies by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/132

Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.6.0...v0.7.0

Summary

• Diff any schemas, not just public
• Diff two databases instead of a database and DDL
• New interface for generating plans (Generate). GeneratePlan is now deprecated.

What's Changed

• Switch interfaces to accept conn pools by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/90
• Concurrent schema fetching by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/91
• Fix potential deadlock bug by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/92
• Set max connections for plan cmd by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/93
• Use connection pool when validating migration plan by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/95
• Add support for fetching non-public schemas. by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/96
• New GeneratePlan interface by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/98
• Wire schemas through SQL generation by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/99
• Add exclude schemas by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/100
• Multi-schema support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/104
• Database schema source (allow comparing two databases) by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/107
• Update CLI with multi-schema support and database schema source by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/108

Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.5.0...v0.6.0

What's Changed

• Allow root db to be something other than postgres in temp db factory by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/79
• Online not null constraints: SET NOT NULL by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/83
• Simplify testing and update UUID format by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/86
• Remove extraneous NOT NULL statement generation. Update README by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/89

Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.4.0...v0.5.0

What's Changed

• Add lock timeout modifier by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/61
• Building PK's Concurrently for Partitions by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/65
• Add DOT encoding support for internal/graph by @kevinmingtarja in https://github.com/stripe/pg-schema-diff/pull/70
• Add support for replica identities by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/71
• Add unique constraint support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/74
• Online check constraint addition by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/76

New Contributors

• @kevinmingtarja made their first contribution in https://github.com/stripe/pg-schema-diff/pull/70

Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.3.0...v0.4.0

What's Changed

• Add basic Extension support. by @alexrhee-stripe in https://github.com/stripe/pg-schema-diff/pull/43
• Add foreign key support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/53
• cmd: make dsn a non-mandatory flag to allow use of Postgres environment variables by @scottt in https://github.com/stripe/pg-schema-diff/pull/54

New Contributors

• @alexaub-stripe made their first contribution in https://github.com/stripe/pg-schema-diff/pull/39
• @alexrhee-stripe made their first contribution in https://github.com/stripe/pg-schema-diff/pull/43
• @scottt made their first contribution in https://github.com/stripe/pg-schema-diff/pull/54

Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.2.0...v0.3.0

What's Changed

• Add sequence support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/35

New Contributors

• @guidolodetti made their first contribution in https://github.com/stripe/pg-schema-diff/pull/33

Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.1.0...v0.2.0

Initial release. The exposed library API is subject to change; however, the CLI should be mostly stable.

Full Changelog: https://github.com/stripe/pg-schema-diff/commits/v0.1.0