v4.15.1

Changes

Database Drivers

• Update gosnowflake from v1.4.3 to v1.6.3 to fix security warnings (#632 & #637). Thanks @nicholas-mainardi and @obitech for reporting the issue!
• Add unofficial support for AWS Keyspaces to the Cassandra DB driver by DELETEing the schema version table instead of using TRUNCATE thanks to @florentsolt and @Baumanar (#634)

Docker Image

• Fixed CLI binary file location (#625) thanks to @Fontinalis (#628)

Builds

• Update dktest to v0.3.7 to fix security warnings (#632). Thanks @nicholas-mainardi for reporting the issue!

v4.15.0

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

v4.15.0-beta.1

Breaking Changes

• 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 for releases thanks to @johejo and @Fontinalis (#604)
• 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

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

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
• spanner
  • fix (spanner): upgrade spanner client to v1.18.0 to support NUMERIC types (#565) by @kylechadha
• snowflake
  • Update snowflake DB driver to update to non-vulnarable jwt downstream package (#569) by @dhui
• mssql
  • Add msi auth support (#591) by @samfoxcode
• mysql
  • 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

v4.14.1

Changes

Source Drivers

• Remove iofs driver (#472) since it was breaking go mod tidy. Thanks to @zikaeroh for reporting the issue (#480) and @johejo for the revert PR (#481)

v4.14.0

Changes

Source Drivers

• Add BitBucket as a source thanks to @Doctor-X (#450)
• Improve error message readability when the source driver is missing thanks to @olicuzo (#454)
• Add iofs source driver (Go 1.16+ only) fixing #471 thanks to @johejo (#472)
  • This enables support for go:embed (golang/go#41191)

Database Drivers

• Spanner
  • Add local locks for Spanner (fa3e119)
  • Run tests against in-memory emulator fixing #410
• MySQL
  • Fix issue (#411) connecting to MySQL with custom TLS parameters. Thanks @Chronojam for the detailed bug report!
  • Fix issue with ANSI or ANSI_QUOTES sql_mode (#475) thanks to @MacTynow (#476)
• Properly handle all errors when running drop thanks to @hypnoglow (#456)
• Update dhui/dktest to update docker client which uses the module compatible version of logrus

CLI

• Add help option (-h) to every migrate command thanks to @yageek (#460)

Docs

• Warn about installing migrate via go get from within a module fixing #257
• Document postgres search_path issues thanks to @veger (#414)
• Typo fixed thanks to @xortive (#458)
• Document -f option for the drop command thanks to @neomantra (#459)

v4.13.0

Changes

Database Driver

• Update underlying spanner DB driver to fix spannersql parsing issues thanks to @wyardley (#427)
• Add support for SQLCipher thanks to @klingtnet (#436)
• Add option to not lock when running migrations (useful for multi-master/cluster setups) in the MySQL DB driver fixing #215 thanks to @antonklava (#439)
• Add support for locks in MongoDB fixing #435 thanks to @andyNewman42 (#448)

Builds

• Support Go 1.15 and drop support for Go 1.13
• Update to golangci-lint v1.30.0

Docs

• Clarify how params are set in spanner db driver docs thanks to @wyardley (#428)
• Rename Github to GitHub thanks to @dhermes (#429)
• Fix spelling mistake in FAQ thanks to @markokoleznik-cs (#447)

v4.12.2

Changes

Database Driver

• Use latest neo4j db driver to fix broken 32-bit builds
  • Thanks @2hdddg for the quick fix upstream!

Builds

• Use make for Docker builds

v4.12.1

Changes

Builds

• Add make target to avoid unnecessarily building for all OSes and architectures thanks to @dawidd6 (#419)

v4.12.0

Breaking Changes

• Spanner db driver no longer parses out multiple statements by default. See: #409 (comment). Thanks to @wyardley for pointing out that the breaking change wasn't documented in the release notes!

Changes

Core Library

• Add multistmt package to handle splitting multiple statements in a migration

Database Driver

• Fix Cassandra SSL URL param handling thanks to @kadenlnelson (#386)
• Add mongodb+srv as a scheme to support seedlists thanks to @shiwano (#391)
• Add snowflake db driver thanks to @abhinavcohesity (#402)
  • snowflake is not officially supported due to lack of tests
• Update spanner driver thanks to @dmivankov (#403)
• Support stripping comments and cleaning/parsing in spanner db driver thanks to @alethenorio (#409)
• Update clickhouse, cassandra, and neo4j db drivers to use new multistmt package
• Update neo4j driver to no longer require CGO thanks to @arjantop-cai (#415)
• Update go-mssqldb and spanner drivers to remove dependency on vulnerable thrift package thanks to @odeke-em (#417)

Docs

• Add example pkger source driver usage thanks to @hnnsgstfssn (#397)
• Typo fixed thanks to @RichardLindhout (#407)

Builds

• Stop releasing .debs for Ubuntu 18.10 and start releasing for Ubuntu 20.04

v4.11.0

Breaking Changes

• Fix neo4j.WithInstance() method signature to actually include an instance of the neo4j driver thanks to @dynastymasra (#373)

Changes

Core Library

• Update hashicorp/go-multierror to v1.1.0 to fix #369 thanks to @jmramos02 (#375)

Database Driver

• Properly handle first down migration failures (#330)
  • Affected drivers: cassandra, cockroachdb, firebird, mysql, neo4j, postgres, ql, redshift, sqlite, and sqlserver
    • Schema migration apply times are now tracked in Neo4j

Source Driver

• Add support for pkger thanks to @hnnsgstfssn (#377)

CLI

• Prompt before running the drop command thanks to @niksoper (#360)

Docs

• Provide guidance on how to handle dirty database version errors fixing #337 thanks to @mknycha (#361)
• Fix command for building and installing the CLI. Thanks to @JKKGBE for reporting.