Dbmate Versions Save

What's Changed

• Update dependencies by @amacneil in https://github.com/amacneil/dbmate/pull/456

What's Changed

• ClickHouse: Support migrations on cluster by @FatherCandle in https://github.com/amacneil/dbmate/pull/432
• Postgres: Add support for schemas containing special characters by @alfredringstad in https://github.com/amacneil/dbmate/pull/446
• Read GitHub Actions go version from go.mod by @amacneil in https://github.com/amacneil/dbmate/pull/448

New Contributors

• @FatherCandle made their first contribution in https://github.com/amacneil/dbmate/pull/432
• @alfredringstad made their first contribution in https://github.com/amacneil/dbmate/pull/446

What's Changed

• Support multiple --migrations-dir directories by @dossy in https://github.com/amacneil/dbmate/pull/428

New Contributors

• @dossy made their first contribution in https://github.com/amacneil/dbmate/pull/428
• @morya made their first contribution in https://github.com/amacneil/dbmate/pull/442

Full Changelog: https://github.com/amacneil/dbmate/compare/v2.2.0...v2.3.0

What's Changed

Changed

• Publish as CommonJS module by @amacneil in https://github.com/amacneil/dbmate/pull/425

Misc

• Bump actions/setup-go from 3 to 4 by @dependabot in https://github.com/amacneil/dbmate/pull/422

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

Fixed

• Fix issue with rollback trying to revert unapplied migrations by @sunaurus in https://github.com/amacneil/dbmate/pull/405
• Fix support for absolute migration directory by @amacneil in https://github.com/amacneil/dbmate/pull/406

Changed

• More thorough rollback tests by @amacneil in https://github.com/amacneil/dbmate/pull/407

Thanks to @sunaurus and @blinktag for reporting issues in the v2.0.0 release.

What's new in v2

• Migration files must always define both a -- migrate:up block and a --migrate:down block (even if the down block is empty), preventing errors such as https://github.com/amacneil/dbmate/issues/108.
• The schema_migrations table version column is now created as varchar(128) instead of varchar(256). Existing tables will not be modified.
• Dbmate use as a Go library (including embedded filesystem migrations) is now documented, with some minor changes to the public API.
• Dbmate now has an npm package.

Added

• Add NPM package by @amacneil in https://github.com/amacneil/dbmate/pull/400 https://github.com/amacneil/dbmate/pull/401
• Support embedded filesystem migrations by @amacneil in https://github.com/amacneil/dbmate/pull/388
• Document library use and embedding by @amacneil in https://github.com/amacneil/dbmate/pull/389

Changed

• Shorter version column, use default charset for mysql by @amacneil in https://github.com/amacneil/dbmate/pull/391
• Stricter migration parsing by @amacneil in https://github.com/amacneil/dbmate/pull/397

Fixed

• SQLite: Do not dump system tables by @docapotamus in https://github.com/amacneil/dbmate/pull/383
• ClickHouse: Fix CheckMigrationTableExists by @docapotamus in https://github.com/amacneil/dbmate/pull/387 https://github.com/amacneil/dbmate/pull/394
• MySQL: Fix UNIX socket support in dump action by @Enrico204 in https://github.com/amacneil/dbmate/pull/267
• Fix go build vcs errors by @amacneil in https://github.com/amacneil/dbmate/pull/385

Other

• Refactor wait when creating driver by @amacneil in https://github.com/amacneil/dbmate/pull/386
• Bump docker/build-push-action from 3 to 4 by @dependabot in https://github.com/amacneil/dbmate/pull/382
• Adds flyway to the comparison table by @mwhitm in https://github.com/amacneil/dbmate/pull/306
• Go v1.20 by @amacneil in https://github.com/amacneil/dbmate/pull/396
• Upgrade clickhouse-go to v2 by @amacneil in https://github.com/amacneil/dbmate/pull/395
• Update import paths for v2 by @amacneil in https://github.com/amacneil/dbmate/pull/398
• ClickHouse: Remove inaccurate comment by @amacneil in https://github.com/amacneil/dbmate/pull/399

• 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