dbmate

Added

• Add x86 build by @amacneil in https://github.com/amacneil/dbmate/pull/409
• Add resolveBinary() function to npm package by @amacneil in https://github.com/amacneil/dbmate/pull/415 https://github.com/amacneil/dbmate/pull/418
• Add eslint by @amacneil in https://github.com/amacneil/dbmate/pull/416

Removed

• Remove arm32 docker image by @amacneil in https://github.com/amacneil/dbmate/pull/410

Misc

• Add Sqitch to comparison chart by @ttfkam in https://github.com/amacneil/dbmate/pull/414
• Move driver imports to main.go by @amacneil in https://github.com/amacneil/dbmate/pull/417

• Fix create db and upgrade clickhouse-server to v22.8 by @farbodsalimi in https://github.com/amacneil/dbmate/pull/380

• Fixes typo in error message: up bock -> up block by @wkalt in https://github.com/amacneil/dbmate/pull/341
• Update dependencies by @amacneil in https://github.com/amacneil/dbmate/pull/343 https://github.com/amacneil/dbmate/pull/381

• PostgreSQL: Fix host query parameter being ignored by @niclaslovdahl in https://github.com/amacneil/dbmate/pull/318
• MySQL: Trim AUTO_INCREMENT values from schema dumps by @shames0 in https://github.com/amacneil/dbmate/pull/319
• Docker: Fix missing caching_sha2_password MySQL plugin @shames0 in https://github.com/amacneil/dbmate/pull/308
• Add arm32 cross compilation by @edaubert in https://github.com/amacneil/dbmate/pull/293
• Export errors by @gnuletik in https://github.com/amacneil/dbmate/pull/302
• Go 1.19

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

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

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

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

• Require presence of a -- migrate:up directive in migration files (https://github.com/amacneil/dbmate/pull/72)
• Explicitly fail if any sql statements precede the -- migrate:up directive (https://github.com/amacneil/dbmate/pull/77)
• Fix error when using special characters in mysql passwords (https://github.com/amacneil/dbmate/pull/76)

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

• Explicitly specify public schema for schema_migrations table (fixes error importing schema.sql in PostgreSQL 9.6.8+) (https://github.com/amacneil/dbmate/pull/49, https://github.com/amacneil/dbmate/pull/52)

• Add dbmate wait command (#35, docs)
• Move cmd package to project root directory (#29)
• Upgrade to Go 1.10 (#38)

• Add dbmate dump command and automatic schema.sql file generation support (https://github.com/amacneil/dbmate/pull/23)
• Create official docker release image (https://github.com/amacneil/dbmate/pull/21)
• Add default port 3306 for MySQL connections (https://github.com/amacneil/dbmate/pull/13)
• Upgrade to Go 1.9 (https://github.com/amacneil/dbmate/pull/19)
• Separate cmd/dbmate and pkg/dbmate packages for easier importing (https://github.com/amacneil/dbmate/pull/11)
• Add proper cgo build constraints to remove SQLite support in musl binary (https://github.com/amacneil/dbmate/pull/25)
• Migrate to dep for dependency management (https://github.com/amacneil/dbmate/pull/26)

• Go 1.8.0
• Add musl target for Alpine linux support

• Fixed migrations being applied in the wrong order
• Updated references from codegangsta/cli to urfave/cli