github crossplane-contrib/provider-sql v0.16.0

pre-releaseone day ago

⚠️⚠️⚠️ Pre-release, do not upgrade yet ⚠️⚠️⚠️

What's Changed

Breaking changes

  • The schema field in DefaultPrivileges is no longer required. Resources using objectType: schema must omit the schema field; resources using other object types still require it (now validated at controller level rather than CRD level).

    • fix(postgresql): make schema optional and conditionally required in DefaultPrivileges by @AGejr in #379

    ⚠️ If you have existing DefaultPrivileges resources with objectType: schema (which never produced valid SQL), they may become undeletable after upgrade. To clean up, remove the finalizer manually:
    shell kubectl patch defaultprivileges <name> -p '{"metadata":{"finalizers":[]}}' --type=merge

New features

  • 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 (credits go to @Sabotaz and @Bastichou for the original work in #235 and #218 respectively) 🙌
  • feat: add support for alternative connection secret formats by @fernandezcuesta in #362
  • feat(postgresql): support WITH INHERIT FALSE on role membership grants (PostgreSQL 16+) by @matthewgreenwaldagility in #361
  • feat(mysql/user): support non-default authentication plugins for IAM auth by @ronlevy1211 in #363
  • feat(postgresql): auto-regenerate role password on restore and support rotation trigger by @JevgeniF in #348

Bug fixes

Bumps

  • chore: bump github.com/antchfx/xpath from 1.2.0 to 1.3.6 by @dependabot[bot] in #349
  • chore: bump github.com/microsoft/go-mssqldb from 1.9.8 to 1.10.0 by @dependabot[bot] in #364
  • chore: bump distroless/static from f512d81 to e3f9456 in /cluster/images/provider-sql by @dependabot[bot] in #356
  • chore: bump distroless/static from e3f9456 to 963fa6c in /cluster/images/provider-sql by @dependabot[bot] in #389
  • 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: bump github.com/go-sql-driver/mysql from 1.9.3 to 1.10.0 by @dependabot[bot] in #383
  • chore: bump golang.org/x/crypto from 0.50.0 to 0.52.0 by @dependabot[bot] in #408
  • chore: bump golang.org/x/net from 0.54.0 to 0.55.0 by @dependabot[bot] in #407
  • chore: bump distroless/static from 963fa6c to f7f8f72 in /cluster/images/provider-sql by @dependabot[bot] in #413

CI

  • chore: bump actions/cache from 5.0.3 to 5.0.5 by @dependabot[bot] in #367
  • chore: bump actions/cache from 5.0.5 to 6.1.0 by @dependabot[bot] in #415
  • 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 github/codeql-action from 4.35.4 to 4.36.0 by @dependabot[bot] in #387
  • chore: bump github/codeql-action/analyze from 4.36.0 to 4.36.2 by @dependabot[bot] in #401
  • chore(build): codeql broken - sync versions to 4.37.1 by @chlunde in #412
  • chore: bump docker/setup-buildx-action from 4.0.0 to 4.1.0 by @dependabot[bot] in #388
  • chore: bump docker/setup-buildx-action from 4.1.0 to 4.2.0 by @dependabot[bot] in #414
  • chore: bump golangci/golangci-lint-action from 9.2.0 to 9.2.1 by @dependabot[bot] in #386
  • chore: bump golangci/golangci-lint-action from 9.2.1 to 9.3.0 by @dependabot[bot] in #402
  • chore: bump codecov/codecov-action from 6.0.0 to 6.0.1 by @dependabot[bot] in #385
  • chore: bump codecov/codecov-action from 6.0.1 to 7.0.0 by @dependabot[bot] in #400
  • chore: bump docker/setup-qemu-action from 4.0.0 to 4.1.0 by @dependabot[bot] in #384
  • chore: bump docker/setup-qemu-action from 4.1.0 to 4.2.0 by @dependabot[bot] in #416
  • chore: bump actions/setup-go from 6.4.0 to 6.5.0 by @dependabot[bot] in #404
  • chore: bump actions/setup-go from 6.5.0 to 7.0.0 by @dependabot[bot] in #418
  • chore: bump docker/login-action from 4.1.0 to 4.4.0 by @dependabot[bot] in #417
  • chore: bump actions/checkout from 6.0.2 to 7.0.0 by @dependabot[bot] in #403

New Contributors

Thanks all for your contributions and continuous efforts!!! 🫶

Full Changelog: v0.15.0...v0.16.0

Don't miss a new provider-sql release

NewReleases is sending notifications on new releases.