v4.15.0

[Fontinalis]

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 (Support for GitHub Actions and goreleaser #604) by @johejo and @Fontinalis
• Fix test on windows (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 (Re-add the io/fs source driver #560) by @dhui
• ci: migrate from CircleCI to GitHub Actions (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 (Fix issue when gitlab return only first 20 migrations (reopen) #497) by @mef13
• GitHub
  • Add default GitHub API client (Add default GitHub API client #501) by @ganboonhong
  • Update go-github from v17 to v35 by @dhui
• iofs
  • Fix iofs tests (Re-add the io/fs source driver #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 (used uber atomic bool instead standard in lock/unlock db #580) by @prinkov
• sqlite3
  • Fix error when path to database contains whitespace (sqlite3: Add test case with database path contains whitespace #500) by @ganboonhong
  • Add support for modernc.org/sqlite (Add support for modernc.org/sqlite #555) by @gammazero
  • Bump sqlite past memory corruption bug (Bump sqlite past memory corruption bug #558) by @zikaeroh
• postgres & pgx
  • Support multi-statement execution for PostgreSQL (Support multi-statement execution for PostgreSQL #495) by @AnatolyRugalev
  • Add pgx driver package (Add pgx driver package #517) by @dzbee
  • Add a check to determine if table already exists to elide CREATE query (Postgres: Add a check to determine if table already exists to elide CREATE query #526) by @testtest959
  • Add x-migrations-table-quoted url query option (Support x-migrations-table-schema for postgresql #95) (Postgres - add x-migrations-table-quoted url query option (#95) #533) by @stephane-klein
  • Fix SchemaName parameter is ignored (Why do the adapters (postgres, pgx) ignore the config? #547) by @stephane-klein
• clubhouse
  • Upgrade clickhouse driver lib (upgrade clickhouse driver lib #529) by @linux019
  • added tests for clickhouse database (added tests for clickhouse database #532) by @prinkov
  • make table engine for schema versions table configurable (clickhouse: make table engine for schema versions table configurable #551) by @brunotm
  • Adding support for clickhouse cluster (Adding support clickhouse cluster #568) by @preved911
  • honor DefaultMigrationsTableEngine when created WithInstance() (clickhouse: honor DefaultMigrationsTableEngine when created WithInstance() #617) by @kaworu
• spanner
  • fix (spanner): upgrade spanner client to v1.18.0 to support NUMERIC types (fix(spanner): upgrade spanner client to latest to support NUMERIC types #565) by @kylechadha
  • Update Google Spanner dependency (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 (Upgrade github.com/snowflakedb/gosnowflake to the newer version #569) by @dhui
• mssql
  • Add msi auth support (Add SqlServer MSI Support #591) by @samfoxcode
  • Added a method to create a mysql database from a connection object (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) (use github.com/cockroachdb/cockroach-go/v2/crdb #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 (Allow the ability to pass timezone when generating migration files #509) by @nronas
• fix: move -all flag usage from drop to down (Move -all flag usage from drop to down #522) by @Juneezee

Docs

• Point docs link to v4 (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

---

This discussion was created from the release v4.15.0.