v0.11.0

⚡ Highlights

🔌 Support for YAML migrations files
🍠 name attribute in migrations are no longer required
🎻 Tables without primary key or unique column can be backfilled

Thanks to first time contributors ❤️ 🙏 :

• @richardgill

What's Changed

• Update to Go 1.24 by @andrew-farries in #701
• Docs preview by @richardgill in #703
• Improve error message during JSON unmarshalling by @andrew-farries in #705
• Docs preview Fork fix by @richardgill in #707
• Bump golang.org/x/tools from 0.30.0 to 0.31.0 by @dependabot in #713
• Bump github.com/spf13/viper from 1.19.0 to 1.20.0 by @dependabot in #731
• Fix SQL formatting by @andrew-farries in #733
• Rename generate and format jobs by @andrew-farries in #734
• Fix example link in the documentation by @andrew-farries in #735
• Fix rename column docs by @andrew-farries in #736
• Bump github.com/containerd/containerd from 1.7.20 to 1.7.27 by @dependabot in #732
• Add link to documentation in pgroll --help command by @kvch in #738
• Update pgroll.com docs versions on release by @andrew-farries in #737
• Introduce DBAction interface and refactoring of column dropping by @kvch in #709
• Add convert.mdx to docs/config.json by @andrew-farries in #743
• Improve error messages when pgroll init has not been run by @andrew-farries in #745
• Implement rename column actions as DBAction by @kvch in #746
• Implement creating triggers as DBAction by @kvch in #749
• Make name field in migration JSON optional by @andrew-farries in #744
• Docs Previews: No auto merge creating deployment by @richardgill in #753
• Add rename constraint action as DBAction by @kvch in #752
• Use license-header-checker locally to add missing license headers by @kvch in #748
• sql2pgroll: Ignore IF NOT EXISTS in CREATE TABLE statement conversion by @andrew-farries in #754
• Implement dropping functions as DBAction by @kvch in #750
• Add support for comments as DBAction by @kvch in #757
• Docs Previews: /docs/ -> /docs-preview/ by @richardgill in #756
• Convert pgroll.migrations created_at and updated_at fields to use timestamptz type by @andrew-farries in #758
• Initialize YAML migration file support by @kvch in #755
• sql2pgroll: Ignore IF NOT EXISTS in CREATE INDEX statement conversion by @andrew-farries in #759
• Dont require database access to pgroll latest --local by @andrew-farries in #760
• Set Postgres application_name for pgroll's migrator and state connections by @andrew-farries in #762
• Delete redundant .github/Dockerfile by @andrew-farries in #763
• Implement creating a unique index concurrently as a DBAction by @kvch in #747
• Implement create table as a DBAction by @kvch in #764
• Bump github.com/spf13/viper from 1.20.0 to 1.20.1 by @dependabot in #769
• Bump github.com/testcontainers/testcontainers-go/modules/postgres from 0.35.0 to 0.36.0 by @dependabot in #767
• Use sigs.k8s.io/yaml to parse YAML migration files by @kvch in #771
• Replace JSON examples with YAML && use them in docs by @kvch in #772
• Transform JSON structure descriptions and examples to YAML by @kvch in #773
• Add new group Guides and add a guide for writing up and down expresions by @kvch in #775
• Remove the unnecessary file parameter from the help text by @kvch in #780
• Add callout to sql migration documentation about down migrations by @kvch in #782
• Improve error message when start and rollack fails by @kvch in #781
• Add fallback method for backfilling records by @kvch in #779
• Create a separate guide for integrating pgroll into your project by @kvch in #783

New Contributors

• @richardgill made their first contribution in #703

Full Changelog: v0.10.0...v0.11.0