v0.16.0-beta.0

What's Changed

• feat(postgres): Add support for setting STRATEGY during db creation by @alexdor in #343
• feat(mysql): Allow to Grant permissions on specific columns in table by @ymaniukevich in #330
• feat(pgsql): extend Grant kind specification with schema, tables, columns, sequences, routines, foreign data wrappers, foreign servers by @fernandezcuesta in #345
• feat: add support for alternative connection secret formats by @fernandezcuesta in #362

Bumps

• chore: bump github.com/antchfx/xpath from 1.2.0 to 1.3.6 by @dependabot[bot] in #349
• chore: bump actions/cache from 5.0.3 to 5.0.5 by @dependabot[bot] in #367
• chore: bump github.com/microsoft/go-mssqldb from 1.9.8 to 1.10.0 by @dependabot[bot] in #364
• chore: bump actions/upload-artifact from 7.0.0 to 7.0.1 by @dependabot[bot] in #368
• chore: bump github/codeql-action from 4.35.1 to 4.35.4 by @dependabot[bot] in #369
• chore: bump distroless/static from f512d81 to e3f9456 in /cluster/images/provider-sql by @dependabot[bot] in #356
• chore: bump go.opentelemetry.io/otel from 1.39.0 to 1.41.0 by @dependabot[bot] in #360
• chore: bump github.com/lib/pq from 1.11.2 to 1.12.3 by @dependabot[bot] in #365
• chore: bump github.com/crossplane/crossplane-runtime/v2 from 2.1.0 to 2.2.1 by @dependabot[bot] in #366
• chore: e2e: remove redundant mariadb e2e tests by @chlunde in #373

New Contributors

• @alexdor made their first contribution in #343
• @ymaniukevich made their first contribution in #330

Full Changelog: v0.15.0...v0.16.0-beta.0

v0.15.0

What's Changed

• Add support for defaultCharacterSet and defaultCollation by @AntonAleksandrov13 in #311
• feat: Add ability to optionally create Database contained user, instead of Instance level by @baburciu in #299
• chore: add fernandezcuesta to OWNERS by @chlunde in #331
• PG Schema cascade delete by @stevendborrelli in #333
• feat: Add crossplane_managed_resource_* state metrics by @lkiii in #308

Significant bumps

• chore: bump github.com/lib/pq from 1.10.9 to 1.11.2 by @dependabot[bot] in #317
• chore: replace archived denisenkom/go-mssqldb with microsoft/go-mssqldb by @chlunde in #326
• chore: build with Go 1.26 by @chlunde in #323

Build changes

• feat: Add MSSQL e2e integration test by @baburciu in #300
• e2e: Use rollout status on the statefulset to avoid race condition for pod start by @chlunde in #314
• chore: use OIDC for codecov by @chlunde in #325
• chore: use build/makelib/local.xpkg.mk for e2e cluster by @chlunde in #328
• chore: Delete unused Dockerfile by @chlunde in #327
• chore: update base image hash and add tag and dependabot config by @chlunde in #322
• chore: bump distroless/static from 01e550f to f512d81 in /cluster/images/provider-sql by @dependabot[bot] in #338

Dependabot

• chore: bump actions/upload-artifact from 5.0.0 to 6.0.0 by @dependabot[bot] in #302
• chore: bump docker/setup-buildx-action from 3.11.1 to 3.12.0 by @dependabot[bot] in #304
• chore: bump golangci/golangci-lint-action from 9.1.0 to 9.2.0 by @dependabot[bot] in #306
• chore: bump github/codeql-action from 4.31.5 to 4.32.3 by @dependabot[bot] in #318
• chore: bump docker/login-action from 3.6.0 to 3.7.0 by @dependabot[bot] in #319
• chore: bump actions/cache from 4.3.0 to 5.0.3 by @dependabot[bot] in #320
• chore: bump actions/checkout from 6.0.0 to 6.0.2 by @dependabot[bot] in #316
• chore: bump actions/setup-go from 6.0.0 to 6.2.0 by @dependabot[bot] in #321
• chore: bump codecov/codecov-action from 5.4.2 to 5.5.2 by @dependabot[bot] in #303
• chore: bump filippo.io/edwards25519 from 1.1.0 to 1.1.1 by @dependabot[bot] in #329
• chore: bump github/codeql-action from 4.32.3 to 4.32.5 by @dependabot[bot] in #339
• chore: bump actions/upload-artifact from 6.0.0 to 7.0.0 by @dependabot[bot] in #334
• chore: bump actions/setup-go from 6.2.0 to 6.3.0 by @dependabot[bot] in #335
• chore: bump actions/setup-go from 6.3.0 to 6.4.0 by @dependabot[bot] in #354
• chore: bump github/codeql-action from 4.32.5 to 4.35.1 by @dependabot[bot] in #355
• chore: bump docker/setup-qemu-action from 3.7.0 to 4.0.0 by @dependabot[bot] in #352
• chore: bump docker/login-action from 3.7.0 to 4.0.0 by @dependabot[bot] in #351
• chore: bump docker/setup-buildx-action from 3.12.0 to 4.0.0 by @dependabot[bot] in #353
• chore: bump docker/login-action from 4.0.0 to 4.1.0 by @dependabot[bot] in #371
• chore: bump codecov/codecov-action from 5.5.2 to 6.0.0 by @dependabot[bot] in #370
• chore: bump google.golang.org/grpc from 1.72.1 to 1.79.3 by @dependabot[bot] in #346

New Contributors

• @baburciu made their first contribution in #300
• @AntonAleksandrov13 made their first contribution in #311
• @stevendborrelli made their first contribution in #333
• @lkiii made their first contribution in #308

Full Changelog: v0.14.0...v0.15.0

v0.14.0

This release adds PostgreSQL DefaultPrivileges support by @xocasdashdash, fixes namespaced resource bugs for both MySQL and PostgreSQL.

What's Changed

• Adds support for DefaultPrivileges in postgres by @xocasdashdash in #199
• fix: MySQL namespaced providerconfig used wrong type - CannotConnectToProvider by @chlunde in #289
• fix: Namespaced PostgreSQL extension did not use namespaced database reference by @chlunde in #290
• chore: Remove tracker and set up type-safe connectors by @chlunde in #284

Significant dependency changes

• chore: bump github.com/go-sql-driver/mysql from 1.5.0 to 1.9.3 by @dependabot[bot] in #246

Minor dependency changes

• chore: bump github.com/crossplane/upjet/v2 from 2.0.0 to 2.1.0 by @dependabot[bot] in #280
• chore: bump golang.org/x/crypto from 0.41.0 to 0.45.0 by @dependabot[bot] in #283
• chore: bump github.com/crossplane/upjet/v2 from 2.1.0 to 2.2.0 by @dependabot[bot] in #296
• chore: bump github.com/crossplane/crossplane-runtime/v2 from 2.0.0 to 2.1.0 by @dependabot[bot] in #295

Build related changes

• chore: bump github/codeql-action from 4.30.8 to 4.31.2 by @dependabot[bot] in #281
• chore: bump actions/upload-artifact from 4.6.2 to 5.0.0 by @dependabot[bot] in #282
• chore: Update to crossplane CLI for newer docker compatibility by @chlunde in #286
• chore: bump actions/checkout from 5.0.0 to 6.0.0 by @dependabot[bot] in #294
• chore: bump docker/setup-qemu-action from 3.6.0 to 3.7.0 by @dependabot[bot] in #293
• chore: bump github/codeql-action from 4.31.2 to 4.31.5 by @dependabot[bot] in #291
• chore: bump golangci/golangci-lint-action from 8.0.0 to 9.1.0 by @dependabot[bot] in #292

New Contributors

• @xocasdashdash made their first contribution in #199

Full Changelog: v0.13.0...v0.14.0

v0.13.0

This release introduces Crossplane v2 support by @nateinaction and @tydanny! Thank you both for the excellent work! For examples, see https://github.com/crossplane-contrib/provider-sql/tree/master/examples/namespaced or https://marketplace.upbound.io/providers/crossplane-contrib/provider-sql/v0.13.0

What's Changed

• Add Crossplane v2 support by @nateinaction and @tydanny in #267
• Relax MySQL Database schema, forProvider is optional by @chlunde in #255
• Publish package to ghcr.io by using reusable workflows by @chlunde in #243

Significant bumps

• chore: bump github.com/lib/pq from 1.8.0 to 1.10.9 by @dependabot[bot] in #247
• chore: bump github.com/google/go-cmp from 0.6.0 to 0.7.0 by @dependabot[bot] in #250

Build changes

• Repair e2e by swapping MariaDB/PostgreSQL helm charts with k8s manifests by @chlunde in #277
• chore: Enable monthly dependabot PRs by @chlunde in #234

Dependabot

• chore: bump github.com/DATA-DOG/go-sqlmock from 1.5.0 to 1.5.2 by @dependabot[bot] in #248
• chore: bump docker/setup-buildx-action from 3.10.0 to 3.11.1 by @dependabot[bot] in #256
• chore: bump github/codeql-action from 3.28.16 to 3.30.3 by @dependabot[bot] in #270
• chore: bump actions/setup-go from 5.4.0 to 6.0.0 by @dependabot[bot] in #268
• chore: bump actions/checkout from 4.2.2 to 5.0.0 by @dependabot[bot] in #271
• chore: bump golangci/golangci-lint-action from 7.0.0 to 8.0.0 by @dependabot[bot] in #253
• chore: bump docker/login-action from 3.4.0 to 3.5.0 by @dependabot[bot] in #273
• chore: bump actions/cache from 4.2.3 to 4.3.0 by @dependabot[bot] in #272
• chore: bump docker/login-action from 3.5.0 to 3.6.0 by @dependabot[bot] in #275
• chore: bump github/codeql-action from 3.30.3 to 3.30.5 by @dependabot[bot] in #274

New Contributors

• @nateinaction made their first contribution in #267

Full Changelog: v0.12.0...v0.13.0

v0.13.0-rc.0

This prerelease is available as xpkg.upbound.io/crossplane-contrib/provider-sql:v0.12.0-17.g2dd5eb1.

What's Changed

• Add Crossplane v2 support by @nateinaction and @tydanny in #267
• Relax MySQL Database schema, forProvider is optional by @chlunde in #255
• Publish package to ghcr.io by using reusable workflows by @chlunde in #243

Significant bumps

• chore: bump github.com/lib/pq from 1.8.0 to 1.10.9 by @dependabot[bot] in #247
• chore: bump github.com/google/go-cmp from 0.6.0 to 0.7.0 by @dependabot[bot] in #250

Build changes

• Repair e2e by swapping MariaDB/PostgreSQL helm charts with k8s manifests by @chlunde in #277
• chore: Enable monthly dependabot PRs by @chlunde in #234

Dependabot

• chore: bump github.com/DATA-DOG/go-sqlmock from 1.5.0 to 1.5.2 by @dependabot[bot] in #248
• chore: bump docker/setup-buildx-action from 3.10.0 to 3.11.1 by @dependabot[bot] in #256
• chore: bump github/codeql-action from 3.28.16 to 3.30.3 by @dependabot[bot] in #270
• chore: bump actions/setup-go from 5.4.0 to 6.0.0 by @dependabot[bot] in #268
• chore: bump actions/checkout from 4.2.2 to 5.0.0 by @dependabot[bot] in #271
• chore: bump golangci/golangci-lint-action from 7.0.0 to 8.0.0 by @dependabot[bot] in #253
• chore: bump docker/login-action from 3.4.0 to 3.5.0 by @dependabot[bot] in #273
• chore: bump actions/cache from 4.2.3 to 4.3.0 by @dependabot[bot] in #272
• chore: bump docker/login-action from 3.5.0 to 3.6.0 by @dependabot[bot] in #275
• chore: bump github/codeql-action from 3.30.3 to 3.30.5 by @dependabot[bot] in #274

New Contributors

• @nateinaction made their first contribution in #267

Full Changelog: v0.12.0...v0.13.0-rc.0

v0.12.0

This release supports management policies and contains security updates.

Like the previous release, it is only available under xpkg.upbound.io/crossplane-contrib/provider-sql:v0.12.0. We plan to support xpkg.crossplane.io in the next release.

What's Changed

• fix: enable management policies by @fernandezcuesta in #215

Security updates

• chore: Update Go to 1.23.9 by @chlunde in #230
• Bump golang.org/x/crypto from 0.21.0 to 0.35.0 by @dependabot in #229
• Bump golang.org/x/net from 0.25.0 to 0.38.0 by @dependabot in #231
• Bump google.golang.org/protobuf from 1.31.0 to 1.33.0 by @dependabot in #232

Maintainer changes

• chore: add chlunde to maintainers list by @Duologic in #225
• Move negz to emeritus status by @chlunde in #226

CI changes

• bump github actions upload-action to latest release due to deprecation by @larhauga in #228
• chore: bump golangci version by @fernandezcuesta in #216
• test: add coverage of managementPolicies to e2e by @chlunde in #233
• chore: remove duplicate entry of golangci version by @fernandezcuesta in #236

New Contributors 🎉

• @fernandezcuesta made their first contribution in #216
• @dependabot made their first contribution in #229

Full Changelog: v0.11.0...v0.12.0

v0.11.0

What's Changed

• feat(postgresql): add revoke public logic to grant and schema resources by @olikyr in #207
• test(postgresql): implement postgresdb integration tests by @olikyr in #208
• ci: update helm repo before intalling mariadb by @olikyr in #209

New Contributors

• @olikyr made their first contribution in #207

Full Changelog: v0.10.0...v0.11.0

v0.10.0

What's Changed

MySQL:

• Give MySQL sql_log_bin at DSN level to take parameter into account by @fgaillot-qosenergy in #171
• optional binlog parameters in mysql connection string by @mleahu in #201
• fix: remove unneeded flush privileges call for mysql by @Duologic in #202
• feat: add custom tls config support to mysql by @silphid in #184
• refactor(mysql): consistent username/host parameters by @Duologic in #205

PostgreSQL:

• PostgreSQL CREATE SCHEMA support by @chlunde in #181
• change the host with endpoint to make it worked by @developer-guy in #198

MSSQL:

• MSSQL allow to define different databases for login an user by @bakito in #192
• add support for MSSQL schema in grants by @bakito in #193

Housekeeping:

• Refresh build system - update to latest Go, Up, crossplane-runtime etc by @chlunde in #182
• chore: add provider install documentation by @Bastichou in #174
• chore: update build/ and Makefile by @Duologic in #204

New Contributors

• @Bastichou made their first contribution in #174
• @fgaillot-qosenergy made their first contribution in #171
• @developer-guy made their first contribution in #198
• @bakito made their first contribution in #192
• @mleahu made their first contribution in #201
• @silphid made their first contribution in #184

Full Changelog: v0.9.0...v0.10.0

v0.9.0

new provider package will be published via upbound Marketplace xpkg.upbound.io/crossplane-contrib/provider-sql:v0.9.0

What's Changed

• fix MSSQL database user bug by @arielsepton in #168
• ci: promote to upbound marketplace by @Duologic in #159

New Contributors

• @arielsepton made their first contribution in #168

Full Changelog: v0.8.0...v0.9.0

v0.8.0

What's Changed

• add option to configure polling interval by @pascal-sochacki in #123
• Fix mysql provider config spec.tls kubebuilder validation enum by @alereca in #138
• update build to bd5297bd16c113cbc5ed1905b1d96aa1cb3078ec by @mirzakopic in #146
• Feat/queries with sql log bin to 0 by @alereca in #135
• postgres: Expand grant privileges where required by @iainlane in #144
• Support MySQL WITH GRANT OPTION (cherry-picks #132) by @jvrplmlmn in #148
• fix: correctly set GRANT OPTION privilege by @jvrplmlmn in #149
• Use bundled packages and update CI for publishing (replaces #119) by @jvrplmlmn in #153
• chore: add maintainers by @Duologic in #155
• ci: only push to Upbound marketplace by @Duologic in #156

New Contributors

• @pascal-sochacki made their first contribution in #123
• @mirzakopic made their first contribution in #146
• @iainlane made their first contribution in #144
• @jvrplmlmn made their first contribution in #148

Full Changelog: v0.7.0...v0.8.0