What's new

Managed databses for sqlc vet

If you're using sqlc vet to write rules that require access to a running database, sqlc can now start and manage that database for you. PostgreSQL support is available today, with MySQL on the way.

When you turn on managed databases, sqlc will use your schema to create a template database that it can copy to make future runs of sqlc vet very performant.

This feature relies on configuration obtained via sqlc Cloud. If you're interested in early access you can sign up here or send us an email at hello@sqlc.dev.

Read more in the managed databases documentation.

What's changed

• build(deps): bump golang from 1.21.0 to 1.21.1 by @dependabot in build(deps): bump golang from 1.21.0 to 1.21.1 #2711
• fix(codegen/golang): Refactor imports code to match templates by @kyleconroy in fix(codegen/golang): Refactor imports code to match templates #2709
• ci: bump go version to latest in workflows by @andrewmbenton in ci: bump go version to latest in workflows #2722
• fix(codegen/golang): support name type by @orisano in fix(codegen/golang): support name type #2715
• fix(wasm): Move Runner struct to shared file by @kyleconroy in fix(wasm): Move Runner struct to shared file #2725
• fix(engine/sqlite): fix grammer to avoid missing join_constraint by @orisano in fix(engine/sqlite): fix grammer to avoid missing join_constraint #2732
• fix(convert): Support YAML anchors in plugin options by @kyleconroy in fix(convert): Support YAML anchors in plugin options #2733
• Enables the configuration of copyfrom.go similar to quierer and friends by @XanderAtGoingDutch in Enables the configuration of copyfrom.go similar to quierer and friends #2727
• test(endtoend): Verify all schemas in endtoend by @kyleconroy in test(endtoend): Verify all schemas in endtoend #2744
• test(examples): Use a hosted database for example testing by @kyleconroy in test(examples): Use a hosted database for example testing #2749
• test(endtoend): Pull region from environment by @kyleconroy in test(endtoend): Pull region from environment #2750
• build(deps): bump google.golang.org/grpc from 1.57.0 to 1.58.1 by @dependabot in build(deps): bump google.golang.org/grpc from 1.57.0 to 1.58.1 #2743
• build(deps): Bump wasmtime-go from v12 to v13 by @kyleconroy in build(deps): Bump wasmtime-go from v12 to v13 #2756
• docs: clarify nullable override behavior by @andrewmbenton in docs: clarify nullable override behavior #2753
• build(windows): Downgrade to mingw 11.2.0 by @kyleconroy in build(windows): Downgrade to mingw 11.2.0 #2757
• build(deps): bump urllib3 from 2.0.4 to 2.0.5 in /docs by @dependabot in build(deps): bump urllib3 from 2.0.4 to 2.0.5 in /docs #2747
• build(deps): bump google.golang.org/grpc from 1.58.1 to 1.58.2 by @dependabot in build(deps): bump google.golang.org/grpc from 1.58.1 to 1.58.2 #2758
• feat(vet): Run rules against a managed database by @kyleconroy in feat(vet): Run rules against a managed database #2751
• chore(endtoend): Skip tests if secrets are missing by @kyleconroy in chore(endtoend): Skip tests if secrets are missing #2763
• docs: Add managed databases to sidebar by @kyleconroy in docs: Add managed databases to sidebar #2764
• fix: Disallow time.Time in mysql :copyfrom queries, not all queries by @Jille in fix: Disallow time.Time in mysql :copyfrom queries, not all queries #2768
• chore: Skip certain tests on PRs by @kyleconroy in chore: Skip certain tests on PRs #2769
• feat(upload): Point upload command at new endpoint by @kyleconroy in feat(upload): Point upload command at new endpoint #2772
• fix(engine/sqlite): Fix convert process for VALUES by @orisano in fix(engine/sqlite): Fix convert process for VALUES #2737
• docs: Release notes for v1.22.0 by @andrewmbenton in docs: Release notes for v1.22.0 #2773
• docs: Pull renaming and type overrides into separate sections by @kyleconroy in docs: Pull renaming and type overrides into separate sections #2774
• docs: Update the docs banner for managed dbs by @kyleconroy in docs: Update the docs banner for managed dbs #2775
• build(deps): bump github.com/google/cel-go from 0.18.0 to 0.18.1 by @dependabot in build(deps): bump github.com/google/cel-go from 0.18.0 to 0.18.1 #2778
• feat(compiler): Support DO statements by @kyleconroy in feat(compiler): Support DO statements #2777
• docs: update changelog with all v1.22.0 changes by @andrewmbenton in docs: update changelog with all v1.22.0 changes #2780
• cmd/sqlc: Bump version to v1.22.0 by @kyleconroy in cmd/sqlc: Bump version to v1.22.0 #2776

New Contributors

• @XanderAtGoingDutch made their first contribution in Enables the configuration of copyfrom.go similar to quierer and friends #2727

Full Changelog: v1.21.0...v1.22.0