xataio/pgroll v0.12.0

on GitHub

⚡ Highlights

• 🪐 New command: create to create migrations interactively
• 🐃 New flag --verbose is added to migrator commands (start, complete, rollback and migrate)
• 🎍 pull fetches only migrations that do not exist in the target migrations folder

🔴 Breaking changes

• migrate command no longer fails if there is an ongoing migration in your database
• pull command outputs migration files in YAML instead of JSON. If you want to stick with JSON files, set the flag --json

Thank you for reporting issues and suggesting improvements!

• @hibnico

Changelog

• 49bf500 Add an extra test case for missing local migrations (#818)
• a8ab934 Add documentation for create subcommand (#820)
• b77c05c Add logger interface for migrations and implement it (#807)
• 34c19af Add new command: create to add new migrations (#815)
• 9249605 Add new guide to documentation: Use pgroll with ORMs (#816)
• 94a5e7f Add new page to documentation titled "Why use pgroll?" (#806)
• 0acb636 Add verbose logging (#804)
• ecdc59d Bump github.com/testcontainers/testcontainers-go from 0.36.0 to 0.37.0 (#802)
• b74a551 Bump github.com/testcontainers/testcontainers-go/modules/postgres from 0.36.0 to 0.37.0 (#803)
• 07c6ff7 Bump golang.org/x/tools from 0.31.0 to 0.32.0 (#792)
• 0d3f57d Bump golang.org/x/tools from 0.32.0 to 0.33.0 (#813)
• e028d24 Default pgroll pull to write in YAML format and add a --json flag (#810)
• 8db5ad7 Extract Concepts to left menu (#797)
• 481e5a7 Extract Installation to the left menu (#796)
• fcf713e Fix formatting of log message args in verbose mode (#817)
• f1c7805 Idempotent migrate command (#805)
• d697c70 Implement dropping indexes as DBAction (#793)
• 07ba13c Implement dropping tables as DBAction (#794)
• 542db44 Make pgroll pull and pgroll migrate command able to handle incompatible migration file formats (#812)
• dc239eb Make pgroll pull pull only migrations that don't exist in target directory (#811)
• 7f979fe New constraint type in create_constraint: primary_key (#698)
• 7669ae2 Remove name field from all examples (#801)
• 02b1da7 Remove duplicated initialization checks across subcommands (#819)
• 0044c10 Remove section about client application from front page of the docs (#808)
• 445696d Rewrite the front page of the docs (#809)
• 55cf3a8 Update pg_query_go dependency to fix compilation on MacOS 15.4 (#799)