pgdrift v1.0.1

Highlights

• fixes PostgreSQL snapshot SQL for psycopg 3 and uses a repeatable-read transaction
• reports co-occurring column changes independently
• classifies varchar narrowing as breaking and widening as additive
• compares definitions for same-named indexes
• packages the Acme demo mutation so installed wheels work outside the source checkout
• strengthens CLI and watch regression coverage
• adds MIT licensing and enforces Ruff formatting in CI

Verification

• 72 tests passed
• Ruff lint and formatting passed
• packaged Acme demo exercised all four change categories
• wheel and sdist passed twine check
• clean Python 3.12 wheel install reports pgdrift, version 1.0.1

Install

Download the attached wheel, then run:

python -m pip install pgdrift-1.0.1-py3-none-any.whl

PyPI publication is not included in this release because no publishing credentials are configured.

v1.0.0

Initial release.

• pgdrift snapshot — capture schema to JSON
• pgdrift diff — categorized change report (BREAKING / ADDITIVE / INFORMATIONAL / SCHEMA-LEVEL)
• pgdrift watch — poll for drift, exit 1 on BREAKING changes
• pgdrift report — rich terminal table view of any snapshot
• pgdrift demo — end-to-end demo against acme-parts-cloud
• 37 tests, zero live DB required in CI