Skip to content

Changelog ​

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[Unreleased] ​

[1.7.0] - 2026-11-04 ​

Added ​

  • Concurrent traversal of named database sources using the existing migration service, with configurable parallelism, independent results, cleanup and cancellation.
  • Shared SSH/proxy configuration defaults for named data sources, with optional per-source overrides and independently owned runtime connections.
  • Initialization flags for zero-based shards with configurable counts, SSH authentication, SOCKS5/HTTP proxies and explicit YAML/JSON output, without resolving or storing secret values.

Changed ​

  • Generate commented YAML configurations by default. Discover .yml, .yaml, then legacy .json configurations while preserving single-source JSON support.

Fixed ​

  • Report the installed Go module version in version and capabilities when the CLI is installed with go install ...@version; retain explicit release build versions and the dev fallback for local development builds.
  • Add the documentation website favicon with the correct GitHub Pages base path across all language pages.

[1.6.0] - 2026-11-04 ​

Added ​

  • Native SSH tunnels for PostgreSQL/MySQL/MariaDB/MSSQL/Oracle/ClickHouse/TiDB/Redshift with optional SOCKS5 or HTTP CONNECT proxies, strict host verification, environment or hidden terminal secrets, noninteractive CLI mode, and an owned Go connection API.
  • Ask-style first-use SSH host trust with explicit fingerprint confirmation, saved known_hosts records and unchanged rejection of changed or revoked host keys.
  • A topic-based English and Chinese documentation website with runnable quick starts, CLI and Go API references, and published release notes.

Changed ​

  • Remove the optional full build mode and SQL-only runtime stubs; SQL, JS, TS and MJS migrations share one CLI.
  • Publish one binary per platform without _full assets, and run one CI build configuration with both SQL and script coverage.
  • Remove the build discriminator from capabilities output; formats and script dialect metadata describe the supported capabilities.

Fixed ​

  • Keep the SSH handshake timeout paused until an approved host key is saved and verified, so local file-lock waits and filesystem syncs do not abort host trust.

[1.5.0] - 2026-11-03 ​

Added ​

  • Runnable SQLite examples for shared script modules, package.json/npm imports and embedded Go migrations, with bilingual instructions and a CI smoke check.
  • Static JS/TS/MJS imports and re-exports, plus installed npm packages bundled for Goja. Embedded and in-memory sources support relative modules and explicit disk dependency directories; no Node runtime or package installation is added.
  • Per-script export const config = { transaction: false } for native SQL/manual transactions on a dedicated connection, with explicit partial-state diagnostics.
  • Experimental JS/TS/MJS migration execution for TiDB, Redshift, Oracle, ClickHouse and MSSQL.
  • A shared case-insensitive alias catalog for SQL and scripts, including PostgreSQL pg/pgsql/postgresql/pgx and MSSQL sqlserver/azuresql; scripts expose canonical names.
  • Per-dialect verification status, aliases, transaction modes and limitations in capabilities, plus one warning per selected experimental script plan.
  • ClickHouse scalar value conversion and explicit partial-state errors for nontransactional execution/history failures; driver-reported affected-row counts remain strings.
  • ClickHouse/TiDB/MSSQL container CI and optional SQL/full Oracle/Redshift/MSSQL integration.

Fixed ​

  • Restore Linux/Windows x86 SQL and full builds by pinning the upstream Oracle driver fix for 32-bit INTERVAL integer overflow.
  • Ignore ordinary synchronous script return values and allow caught SQL failures to recover with subsequent calls without classifying vendor error codes. Promise, actual execution cancellation, overall timeout, validation and resource-limit failures remain fatal; commit/history errors still fail the migration.
  • Reuse successful nontransactional script connections through the pool; discard only failed/panicked steps, preserving cleanup of unfinished manual transactions.
  • Forward script SQL unchanged to database drivers; remove keyword/single-statement restrictions and the handwritten MSSQL validator while retaining runtime limits.
  • Upgrade the Oracle driver to go-ora v3 for modern authentication; disable its fast login cache by default while preserving explicit options. Correct Oracle history DDL, native status binding and missing result metadata handling.
  • Serialize external SQL/full CI against each dedicated database to avoid fixture races.

Compatibility ​

  • Script checksums continue to cover entry source only. Editing imported helpers or packages does not trigger history mismatches or replay applied migrations; authors retain historical dependency behavior and pin installed package versions.
  • Default builds remain SQL-only. Existing script_dialects JSON output is preserved; script_dialect_capabilities adds detailed status. New dialects remain experimental.
  • Oracle DDL implicitly commits. ClickHouse scripts cannot automatically roll back; inspect data and history before retrying failures. Generated declarations include all executable dialects with string affected-row counts.

[1.4.0] - 2026-11-02 ​

Added ​

  • Accept .mjs as a JavaScript migration alias in full builds; SQL-only builds detect and reject it before migration writes. Support new version --format mjs.
  • Optional full builds support standalone synchronous JS/TS migrations alongside SQL, with framework-owned transactions, exact value conversion, source checksums, execution deadlines and query result limits.
  • capabilities reports compiled formats without configuration or a connection.
  • new version --format sql|js|ts|mjs creates migration templates; script timeout and result limits can be configured through JSON or the Go facade.
  • Generated JS/MJS templates include JSDoc database types; TS templates provide equivalent method, parameter and result declarations for editor assistance.
  • SQL/full CI matrices and real-driver script integration for PostgreSQL, MySQL, MariaDB and SQLite; full release binaries and editor API declarations.

Fixed ​

  • Migration callbacks that panic now roll back instead of entering deferred commit.
  • Execution validates complete selected plans before changing data, including irreversible rollback ranges and unsupported script capabilities.

Compatibility ​

  • Default binaries and existing release filenames remain SQL-only. Existing SQL hashes, migration history and version command output remain unchanged.
  • Known JS/TS/MJS migration files are discovered by both builds; SQL-only execution refuses them instead of silently skipping required versions.

[1.3.1] - 2026-04-22 ​

Fixed ​

  • Configuration JSON parse errors now include the config file path, line, and column. Extra non-JSON content after the config object is reported with a clear remediation hint instead of only the raw Go parser message.

Added ​

  • Regression coverage for migrate status -w <dir> when <dir>/migration_config.json contains trailing non-JSON content.
  • Configuration parsing coverage for DSNs that use environment defaults and passwords containing special characters such as $, ,, and >.

[1.3.0] - 2026-04-20 ​

Added ​

  • Public root-package facade (github.com/exc-works/migrate) so other Go services can embed migration execution in-process alongside the existing cmd/migrate CLI. Exports Service, Config, Status constants, dialect constructors (migrate.NewPostgresDialect(), NewMySQLDialect(), etc.), migration sources, and logger types. internal/* remains private.
  • FSSource loads migrations from any fs.FS — works with //go:embed, os.DirFS, or fstest.MapFS (test-friendly).
  • User guides translated into 10 additional languages: ar, de, es, fr, hi, ja, ko, pt-BR, ru, zh-Hant. Each guide gains a new section 12 documenting library usage.

[1.2.1] - 2026-04-17 ​

Changed ​

  • CLI error messages and help output refined for both human users and agent-driven workflows.

[1.2.0] - 2026-04-14 ​

Added ​

  • Top-level migrate --version command.

[1.1.1] - 2026-04-14 ​

Fixed ​

  • Track cmd/migrate sources in git; narrowed .gitignore so the binary build artifact no longer excludes source files.

[1.1.0] - 2026-04-14 ​

Changed ​

  • Renamed binary and module from sql-migrate to migrate.
  • Release workflow now targets Linux arm64 / x64 / x86.
  • GitHub Actions bumped to Node 24–compatible versions.

Fixed ​

  • Oracle integration secret gating in CI.

[1.0.0] - 2026-04-14 ​

Initial tagged release.

Added ​

  • Dialect support: PostgreSQL, MySQL, MariaDB, MSSQL, Oracle, SQLite, ClickHouse, TiDB, Redshift.
  • Bilingual (zh-CN, en) user guides.
  • Tag-based multi-platform release workflow.