Skip to content

Releases: pressly/goose

v3.28.0

Choose a tag to compare

@github-actions github-actions released this 02 Sep 08:34
43d2d9c

Added

  • CLI: azuresql driver for Azure SQL with Microsoft Entra ID (Azure AD) authentication via
    fedauth connection string parameters, e.g.
    goose azuresql "sqlserver://host?database=mydb&fedauth=ActiveDirectoryDefault" status.
    Excluded when building with the no_mssql or no_azuresql tags (#1109)
  • MySQL/MariaDB table-based Locker via lock.NewMySQLTableLocker, the MySQL counterpart to the
    Postgres table locker from #993, accepting the same TableLockerOption set (#1075)

Changed

  • Minimum Go version is now 1.26
  • ClickHouse: new goose_db_version tables are created with ORDER BY (version_id) instead of
    ORDER BY (date). Existing tables are unchanged (#1085)
  • MySQL/TiDB: the tstamp column is now DATETIME instead of TIMESTAMP, which is capped at
    2038-01-19 (#1053). Only newly created tables are affected; existing tables can be updated with:
    ALTER TABLE goose_db_version MODIFY tstamp datetime NULL DEFAULT CURRENT_TIMESTAMP;
  • Various dependency upgrades

Fixed

  • goose create returns a clear "file exists" error, including the path, instead of %!w(<nil>)
    when the migration file already exists (#1104)

v3.27.3

Choose a tag to compare

@github-actions github-actions released this 22 Jul 12:50
520411a

Changed

  • Various dependency upgrades

v3.27.2

Choose a tag to compare

@github-actions github-actions released this 30 Jun 12:44
b0f7076

Changed

  • Upgrade golang.org/x/crypto and golang.org/x/net to address security advisories (CVE fixes)
  • Various dependency upgrades

v3.27.1

Choose a tag to compare

@github-actions github-actions released this 24 Apr 21:19
e3235f7

What's Changed

  • Dependency updates

Full Changelog: v3.27.0...v3.27.1

v3.27.0

Choose a tag to compare

@github-actions github-actions released this 22 Feb 16:04
v3.27.0
7fb1461

What's Changed

Added

  • Preliminary Spanner dialect support (#966)

Changed

  • Minimum Go version is now 1.25
  • SQL migration templates no longer include StatementBegin and StatementEnd annotations. These are only needed for complex statements containing semicolons (e.g., stored procedures). See docs for details.
  • Various dependency upgrades

Other

  • Added formatting for YDB table names to include folder (#1007)
  • Fix tests for StarRocks 3.5 (#1024)
  • CI improvements (#1000, #1005, #1008)

Full Changelog: v3.26.0...v3.27.0

v3.26.0

Choose a tag to compare

@github-actions github-actions released this 03 Oct 13:32
v3.26.0
3d1474d

What's Changed

  • Add *slog.Logger support to goose provider via option WithSlog (#989)
  • Add convenience WithTableName provider option (#985)
  • Minor bug fixes and dependency upgrades
  • Add general purpose Locker interface to support DB locking with a table-based Postgres
    implementation via lock.NewPostgresTableLocker (#993 for more details)
    • Unlike SessionLocker, this uses the *sql.DB connection pool
    • Add WithLocker option to goose provider

New Contributors

Full Changelog: v3.25.0...v3.26.0

v3.25.0

Choose a tag to compare

@github-actions github-actions released this 24 Aug 20:50
v3.25.0
35106f1

What's Changed

  • Upgrade go deps (#976)
  • Remove references/tests for vertica and add deprecation warnings (#978)
  • Add Aurora DSQL as a new database dialect to goose Provider (#971)
  • Add DDL isolation support for Aurora DSQL compatibility (#970)
  • Update Apply to respect no versioning option (#950)
  • Expose dialect Querier (#939)

New Contributors

Full Changelog: v3.24.3...v3.25.0

v3.24.3

Choose a tag to compare

@github-actions github-actions released this 07 May 01:31
v3.24.3
c6cc2e2

What's Changed

  • Add GOOSE_TABLE environment variable -- lower priority than -table flag, but higher than the
    default table name. (#932)
  • Dependency updates

New Contributors

  • @d6o made their first contribution in #932

Full Changelog: v3.24.2...v3.24.3

v3.24.2

Choose a tag to compare

@github-actions github-actions released this 28 Mar 02:15
v3.24.2
b63ff99

What's Changed

  • Add TableExists table existence check for the mysql dialect (#895)
  • Upgrade minimum Go version to 1.23
  • Various dependency updates

New Contributors

Full Changelog: v3.24.1...v3.24.2

v3.24.1

Choose a tag to compare

@github-actions github-actions released this 07 Jan 14:33
v3.24.1
dc90c17

What's Changed

  • Fix regression (v3.23.1 and v3.24.0) in postgres migration table existence check for
    non-default schema. (#882, #883, #884).

New Contributors

Full Changelog: v3.24.0...v3.24.1