v0.7.0

⚡ Highlights

💻 Add support for Postgres 17 (#387)
🚤 Improve backfill performance by up to 80% (#389)
📦 Allow configuration of the batch size during backfills with the --backfill-batch-size flag (#406)
🐢 Allow configuration of a delay between each batch during backfills with the --backfill-batch-delay flag (#410)
🧩 Add support for creating partial indexes in create_index operations (#404)
💭 Capture CREATE / DROP schema statements as inferred migrations (#359)
⏫ Use of pgroll as a Go module now requires Go 1.23 (#397)
🔍 Distinguish inferred migrations by timestamp for statements within the same transaction (#362)
❓ Add a WithNoVersionSchemaForRawSQL Go module option to control creating version schemas for raw SQL migrations (#365)
🔎 Add a WithSearchPath Go module option to allow widening the Postgres search path during migration execution (#380)

Thanks to first time contributors 🙏 ❤️ :

• @dolezvo1
• @t-ham752
• @inelpandzic
• @songlim327
• @ryanslade
• @kvch

Changelog

• 3d6ac6d Add WithNoVersionSchemaForRawSQL option (#365)
• bccdf48 Add examples and test Makefile rules (#400)
• 092313a Add roll.WithSearchPath option (#380)
• 27d09ec Add missing doc comments to exported symbols (#392)
• b72ce2a Add pgroll binary to .gitignore (#391)
• 0cab124 Add support for creating partial indexes on tables (#404)
• f994a42 Add support to list views (#358)
• ced761b Allow configuration of backfill batch size (#406)
• 7d88c25 Allow configuration of batch delay (#410)
• 3f792b7 Bump testcontainers package dependencies (#381)
• 080ca66 Change docker-compose port to 5432 (#402)
• bec15d8 Chore: Add migration start message with schema name (#384)
• a7078ad Clarify usage of down field when dropping a column. (#405)
• 7cef8b1 Distinguish inferred migrations by timestamp for statements within the same transaction (#362)
• fca5abd Export OpAlterColumn.IsRenameOnly method (#357)
• 2c895e2 Fix CLI progress updates (#390)
• 718ecc7 Fix crash when connecting to PostgreSQL rc version (#393)
• c4e4ee3 Fix performance regression in previous_version function (#366)
• aa0c6a4 Ignore duplicate inferred migrations having the same timestamp (#369)
• d7f8ec7 Improve backfill performance (#389)
• 84ef318 Infer CREATE/DROP SCHEMA migrations (#359)
• c2635b3 Minor attempt to clear up the behaviour in the documentation (#372)
• edaa25b Remove dependency on go-cmp (#394)
• 681a3eb Remove some lint deprecation warnings (#407)
• 8234b9e Revert "Add support to list views (#358)" (#360)
• 6466b99 Run examples against Postgres 17 (#401)
• eba0332 Run tests against Postgres 17.0 (#387)
• aeb11fd Speed up make examples (#403)
• 00d492a Update docker-compose.yml (#398)
• d2b62f0 Upgrade some dependencies (#395)
• 7561de0 Upgrade to Go 1.23 (#397)