Dbmate Versions Save

• Move sqlite driver import behind build constraint by @cloneable in https://github.com/amacneil/dbmate/pull/287

Changed

• Make status command read only (#242)

Fixed

• Fix whitespace issues in SQLite absolute paths in DATABASE_URL (#266)
• Append .exe to Windows release builds (#270)

Testing & Docs

• Add scoop install instructions for windows (#263)
• sqlite: Add test for two slashes in URL (#269)

• Upgrade to Go 1.17, use native OS workers for building release binaries in GitHub Actions by @amacneil in https://github.com/amacneil/dbmate/pull/231 https://github.com/amacneil/dbmate/pull/224 https://github.com/amacneil/dbmate/pull/225 https://github.com/amacneil/dbmate/pull/259
• Publish multiarch docker images by @Aposhian in https://github.com/amacneil/dbmate/pull/241
• Postgres defaults to unix socket with no host by @wraithm in https://github.com/amacneil/dbmate/pull/230
• Move from io/ioutil to io and os package by @Juneezee in https://github.com/amacneil/dbmate/pull/236
• Update to MySQL 8.0 image for testing by @amacneil in https://github.com/amacneil/dbmate/pull/250

• Added Apple silicon (darwin/arm64) build (https://github.com/amacneil/dbmate/pull/211)
• Added GitHub Container Registry docker image available at ghcr.io/amacneil/dbmate (https://github.com/amacneil/dbmate/pull/220)

• 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)

• Added --migrations-table flag to specify custom schema_migrations table (https://github.com/amacneil/dbmate/pull/178)
• PostgreSQL: Support custom schema (search path) using search_path URL parameter (https://github.com/amacneil/dbmate/pull/167, https://github.com/amacneil/dbmate/pull/169, https://github.com/amacneil/dbmate/pull/166)
• MySQL: Create the schema_migrations table using latin1 charset to avoid index length limits with utf8mb4 (https://github.com/amacneil/dbmate/pull/172)
• Go v1.15 and additional linters (https://github.com/amacneil/dbmate/pull/161, https://github.com/amacneil/dbmate/pull/165, https://github.com/amacneil/dbmate/pull/170)
• Refactored drivers into separate packages (https://github.com/amacneil/dbmate/pull/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.

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

• Redact passwords in error messages (https://github.com/amacneil/dbmate/pull/145)

• Support for unix sockets with PostgreSQL and MySQL (https://github.com/amacneil/dbmate/pull/131, https://github.com/amacneil/dbmate/pull/136)
• Add --verbose output flag to print last insert ID and rows affected (https://github.com/amacneil/dbmate/pull/138)
• Add --wait-timeout flag (https://github.com/amacneil/dbmate/pull/127)

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