v0.8.0

What's Changed

• Update Acceptance Tests - Flatten specs by @bplunkett-stripe in #136
• Add postgres version 16 support by @bplunkett-stripe in #137
• fix: #67 converting all tabs to spaces in migration acceptance tests by @ammiranda in #139
• Online foreign key support by @bplunkett-stripe in #141
• Add test cases for functional indexes by @alexaub-stripe in #146
• Fix column renames for indexes by @bplunkett-stripe in #147
• Support multiple sql dirs by @bplunkett-stripe in #150
• Create issue templates by @bplunkett-stripe in #166
• Add support for column identities by @bplunkett-stripe in #164
• Support nested directories by @bplunkett-stripe in #171
• Improve dir schema source errors by @bplunkett-stripe in #172
• Create simple version command by @bplunkett-stripe in #174
• Add JSON output support to pg-schema-diff plan. by @tonycosentini in #175
• Refactor SQL generation - graph-first approach by @bplunkett-stripe in #176

New Contributors

• @ammiranda made their first contribution in #139
• @tonycosentini made their first contribution in #175

Full Changelog: v0.7.0...v0.8.0

v0.7.0 - Enum, RLS, and Alter Sequence Support

What's Changed

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

Full Changelog: v0.6.0...v0.7.0

Multi-schema support and diffing two databases

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 #90
• Concurrent schema fetching by @bplunkett-stripe in #91
• Fix potential deadlock bug by @bplunkett-stripe in #92
• Set max connections for plan cmd by @bplunkett-stripe in #93
• Use connection pool when validating migration plan by @bplunkett-stripe in #95
• Add support for fetching non-public schemas. by @bplunkett-stripe in #96
• New GeneratePlan interface by @bplunkett-stripe in #98
• Wire schemas through SQL generation by @bplunkett-stripe in #99
• Add exclude schemas by @bplunkett-stripe in #100
• Multi-schema support by @bplunkett-stripe in #104
• Database schema source (allow comparing two databases) by @bplunkett-stripe in #107
• Update CLI with multi-schema support and database schema source by @bplunkett-stripe in #108

Full Changelog: v0.5.0...v0.6.0

v0.5.0

What's Changed

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

Full Changelog: v0.4.0...v0.5.0

v0.4.0

What's Changed

• Add lock timeout modifier by @bplunkett-stripe in #61
• Building PK's Concurrently for Partitions by @bplunkett-stripe in #65
• Add DOT encoding support for internal/graph by @kevinmingtarja in #70
• Add support for replica identities by @bplunkett-stripe in #71
• Add unique constraint support by @bplunkett-stripe in #74
• Online check constraint addition by @bplunkett-stripe in #76

New Contributors

• @kevinmingtarja made their first contribution in #70

Full Changelog: v0.3.0...v0.4.0

v0.3.0

What's Changed

• Add basic Extension support. by @alexrhee-stripe in #43
• Add foreign key support by @bplunkett-stripe in #53
• cmd: make dsn a non-mandatory flag to allow use of Postgres environment variables by @scottt in #54

New Contributors

• @alexaub-stripe made their first contribution in #39
• @alexrhee-stripe made their first contribution in #43
• @scottt made their first contribution in #54

Full Changelog: v0.2.0...v0.3.0

v0.2.0

What's Changed

• Add sequence support by @bplunkett-stripe in #35

New Contributors

• @guidolodetti made their first contribution in #33

Full Changelog: v0.1.0...v0.2.0

v0.1.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