v1.12.0

• Ability to specify custom --migrations-table (#178)
• MySQL: Support + character in passwords (#200)
• ClickHouse: Support non-UTC timezones (#208)
• More helpful "invalid url" error message (#202)
• Go v1.16 (#196)
• Support custom logger when used as a library (#195)
• Refactor drivers into separate packages (#179)

v1.11.0

• Added --migrations-table flag to specify custom schema_migrations table (#178)
• PostgreSQL: Support custom schema (search path) using search_path URL parameter (#167, #169, #166)
• MySQL: Create the schema_migrations table using latin1 charset to avoid index length limits with utf8mb4 (#172)
• Go v1.15 and additional linters (#161, #165, #170)
• Refactored drivers into separate packages (#179)

Backwards compatibility note: If you are using PostgreSQL with the (previously undocumented) search_path parameter in your URL, you will need to take action depending on the desired location of your schema_migrations table:

Prior to dbmate v1.11, the schema_migrations table was always stored in the public schema. Going forward, dbmate will always store schema_migrations in the first schema of your search_path.

If you wish to adopt the new behavior, you need to manually move your schema migrations table to the first schema in your search_path:

ALTER TABLE public.schema_migrations SET SCHEMA myschema

Alternatively, you can force dbmate to continue storing the migrations table in the public schema by using the --migrations-table "public.schema_migrations" CLI flag.

If you are only using the default (public) schema and did not specify a search_path in your URL, no action is necessary.

v1.10.0

• Add ClickHouse support (#140)
• Add --url flag (#150)
• Allow setting most flags via environment variables (#152)
• Add sql clients (and therefore support dbmate dump) in docker image (#157)
• Upgrade dependencies (#148, #149)
• Build statically linked binaries (#156)
• Add linux/arm64 build (#155)

v1.9.1

• Redact passwords in error messages (#145)

v1.9.0

• Support for unix sockets with PostgreSQL and MySQL (#131, #136)
• Add --verbose output flag to print last insert ID and rows affected (#138)
• Add --wait-timeout flag (#127)

v1.8.0

• Add dbmate status command to list applied and pending migrations (#120, #124)
• Add --wait flag to all commands to wait for the database to be ready before proceeding (#112)
• Fixed integration test failures with latest docker postgres images due to unset default password (#121)
• Improved code linting (#113)

v1.7.0

• Publish binaries for Windows and macOS (#89)
• Fix dbmate wait command on PostgreSQL servers with no postgres schema (#90)
• Improve error messages while loading .env files (#80)
• Build with Go 1.13 (#89)

v1.6.0

• Require presence of a -- migrate:up directive in migration files (#72)
• Explicitly fail if any sql statements precede the -- migrate:up directive (#77)
• Fix error when using special characters in mysql passwords (#76)

v1.5.0

• Add new transaction:false option (#68)
• MySQL 8.0 support (#67)
• Go v1.12 (#69)
• Dbmate is now published in homebrew/core (Homebrew/homebrew-core#40080)

v1.4.1

• Explicitly specify public schema for schema_migrations table (fixes error importing schema.sql in PostgreSQL 9.6.8+) (#49, #52)