golang-migrate/migrate v4.15.0

on GitHub

Breaking Changes

• In the Docker image, the location of the migrate binary changed from /usr/local/bin/migrate to /usr/bin/migrate
• When updating to this version of migrate with postgres, you need to ensure that no migrations are currently running and no old versions of migrate will run at the same time as new versions. The inputs for generating the advisory lock changed so this version will lock with a different key than previous versions.

Changes

Builds

• Use GoReleaser and GitHub Actions (#604) by @johejo and @Fontinalis
• Fix test on windows (#482) by @johejo
• Upgrade dktest from v0.3.3 to v.0.3.4 by @dhui
• Support Go 1.16 and drop support for Go 1.15 by @dhui
• Update docker builds to use Go 1.16 and Alpine Linux 3.13 (#560) by @dhui
• ci: migrate from CircleCI to GitHub Actions (#605) by @Juneezee
• Drop support for Go 1.15 by @dhui

Source Drivers

• GitLab
  • Fix issue when gitlab return only first 20 migrations (#497) by @mef13
• GitHub
  • Add default GitHub API client (#501) by @ganboonhong
  • Update go-github from v17 to v35 by @dhui
• iofs
  • Fix iofs tests (#560) by @dhui
  • Cleanup go 1.15 and 1.16 version specific files by @Fontinalis

Database Drivers

• used uber atomic bool instead standard in lock/unlock db (#580) by @prinkov
• sqlite3
  • Fix error when path to database contains whitespace (#500) by @ganboonhong
  • Add support for modernc.org/sqlite (#555) by @gammazero
  • Bump sqlite past memory corruption bug (#558) by @zikaeroh
• postgres & pgx
  • Support multi-statement execution for PostgreSQL (#495) by @AnatolyRugalev
  • Add pgx driver package (#517) by @dzbee
  • Add a check to determine if table already exists to elide CREATE query (#526) by @testtest959
  • Add x-migrations-table-quoted url query option (#95) (#533) by @stephane-klein
  • Fix SchemaName parameter is ignored (#547) by @stephane-klein
• clubhouse
  • Upgrade clickhouse driver lib (#529) by @linux019
  • added tests for clickhouse database (#532) by @prinkov
  • make table engine for schema versions table configurable (#551) by @brunotm
  • Adding support for clickhouse cluster (#568) by @preved911
  • honor DefaultMigrationsTableEngine when created WithInstance() (#617) by @kaworu
• spanner
  • fix (spanner): upgrade spanner client to v1.18.0 to support NUMERIC types (#565) by @kylechadha
  • Update Google Spanner dependency (#608) by @alethenorio
    • support for ROW DELETION POLICY, ALTER DATABASE and parsing keywords and functions in case insensitive
• snowflake
  • Update snowflake DB driver to update to non-vulnarable jwt downstream package (#569) by @dhui
• mssql
  • Add msi auth support (#591) by @samfoxcode
  • Added a method to create a mysql database from a connection object (#583) by @Seb-C
• cockroachdb
  • use github.com/cockroachdb/cockroach-go/v2/crdb (for better go module support) (#595) by @DGollings
• mongodb
  • Update MongoDB db driver to fix security issue by @dhui

CLI

• Allow the abillity to pass timezone when generating migration files (#509) by @nronas
• fix: move -all flag usage from drop to down (#522) by @Juneezee

Docs

• Point docs link to v4 (#524) by @jeffwidman
• Update sqlite and sqlite3 docs with comparison by @dhui
• Fix grammar for Clickhouse cluster mode docs by @dhui