Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
sqlc_1.23.0_windows_amd64.zip | 2023-10-24 | 18.3 MB | |
sqlc_1.23.0_windows_amd64.tar.gz | 2023-10-24 | 18.5 MB | |
sqlc_1.23.0_linux_arm64.zip | 2023-10-24 | 35.6 MB | |
sqlc_1.23.0_linux_arm64.tar.gz | 2023-10-24 | 35.7 MB | |
sqlc_1.23.0_linux_amd64.zip | 2023-10-24 | 19.9 MB | |
sqlc_1.23.0_linux_amd64.tar.gz | 2023-10-24 | 20.0 MB | |
sqlc_1.23.0_darwin_arm64.zip | 2023-10-24 | 21.4 MB | |
sqlc_1.23.0_darwin_arm64.tar.gz | 2023-10-24 | 21.5 MB | |
sqlc_1.23.0_darwin_amd64.zip | 2023-10-24 | 22.9 MB | |
sqlc_1.23.0_darwin_amd64.tar.gz | 2023-10-24 | 23.0 MB | |
README.md | 2023-10-24 | 10.6 kB | |
v1.23.0 source code.tar.gz | 2023-10-24 | 1.1 MB | |
v1.23.0 source code.zip | 2023-10-24 | 4.2 MB | |
Totals: 13 Items | 242.1 MB | 0 |
What's new
Database-backed query analysis
With a database connection configured, sqlc generate
will gather metadata from that database to support its query analysis. Turning this on resolves a large number of issues in the backlog related to type inference and more complex queries. The easiest way to try it out is with managed databases.
The database-backed analyzer currently supports PostgreSQL, with MySQL and SQLite support planned in the future.
New createdb
command
When you have a cloud project configured, you can use the new sqlc createdb
command to spin up a new ephemeral database with your schema and print its connection string to standard output. This is useful for integrating with other tools. Read more in the managed databases documentation.
Support for pgvector
If you're using pgvector, say goodbye to custom overrides! sqlc now generates code using pgvector-go as long as you're using pgx
. The pgvector extension is also available in managed databases.
Go build tags
With the new emit_build_tags
configuration parameter you can set build tags for sqlc to add at the top of generated source files.
What's Changed
- chore(endtoend): Fix test output for do tests by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2782
- docs: Add stable anchors to changelog by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2784
- build(deps): bump packaging from 23.1 to 23.2 in /docs by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2791
- Update changelog.md by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2796
- docs: Add sqlc upload to CI / CD guide by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2797
- build(deps): bump urllib3 from 2.0.5 to 2.0.6 in /docs by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2798
- build(deps): bump babel from 2.12.1 to 2.13.0 in /docs by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2799
- test(endtoend): Split shema and queries by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2803
- test: Fix a few incorrect testcases by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2804
- build(deps): bump golang.org/x/sync from 0.3.0 to 0.4.0 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2810
- build(deps): bump golang from 1.21.1 to 1.21.2 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2811
- feat(codegen): add support for build tags (#2012) by @Hyuga-Tsukui in https://github.com/sqlc-dev/sqlc/pull/2807
- docs: fix broken link, add clarity to plugins doc by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2813
- feat(generate): reorder codegen handlers to prefer plugins by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2814
- docs: add clarity and reference to JSON tags by @kalogs-c in https://github.com/sqlc-dev/sqlc/pull/2819
- build(deps): bump github.com/google/go-cmp from 0.5.9 to 0.6.0 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2826
- build(deps): bump golang from 1.21.2 to 1.21.3 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2824
- build(deps): bump google.golang.org/grpc from 1.58.2 to 1.58.3 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2825
- ci: bump go version in workflows by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2835
- refactor(codegen): remove golang and json settings from plugin proto by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2822
- feat(devenv): add vscode settings.json with auto newline by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2834
- feat(generate): support yml extension by @xsadia in https://github.com/sqlc-dev/sqlc/pull/2828
- build(deps): bump golang.org/x/net from 0.12.0 to 0.17.0 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2836
- feat(analyzer): Analyze queries using a running PostgreSQL database by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2805
- fix(codegen): Correct column names in :copyfrom by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2838
- feat(sql/ast): Render AST to SQL by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2815
- docs: Replace form with dashboard link by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2840
- fix(compiler): Search SELECT and UPDATE the same way by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2841
- fix(dolphin): Support more UNIONs for MySQL by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2843
- fix(compiler): Account for parameters without parents by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2844
- fix(postgresql): Remove temporary pool config by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2851
- fix(golang): Escape reserved keywords by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2849
- fix(mysql): Handle simplified CASE statements by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2852
- feat(codegen): Include plugin information by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2846
- fix(engine/dolphin): support enum in ALTER definition by @sapk in https://github.com/sqlc-dev/sqlc/pull/2680
- fix(mysql): Add, drop, rename and change enum values by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2853
- feat(postgresql): Add ALTER VIEW ... SET SCHEMA by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2855
- fix(config): Validate
database
config in all cases by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2856 - test: Add more database analyzer test cases by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2854
- feat(compiler): Parse query parameter metadata from comments by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2850
- fix(compiler): Use correct func signature for
CommentSyntax
on windows by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2867 - fix(codegen/go): Prevent filtering of embedded struct fields by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2868
- fix(compiler): Support functions with OUT params by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2865
- docs: Update examples to use pgx/v5 by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2863
- test: Add more analyzer test cases by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2866
- build(deps): bump urllib3 from 2.0.6 to 2.0.7 in /docs by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2872
- patch: use docker compose v2 and update MYSQL_DATABASE env var by @juanjuanzero in https://github.com/sqlc-dev/sqlc/pull/2870
- build(deps): bump google.golang.org/grpc from 1.58.3 to 1.59.0 by @dependabot in https://github.com/sqlc-dev/sqlc/pull/2876
- feat(postgresql): Support system columns on tables by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2871
- feat(compiler): Support LEFT JOIN on aliased table by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2873
- fix(compiler): Pull in array information from analyzer by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2864
- test: Add more test cases for new analyzer by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2879
- feat: Improve messaging for common cloud config and rpc errors by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2885
- fix(analyzer): Error on unexpanded star expression by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2882
- test(endtoend): Enabled managed-db tests in CI by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2883
- feat: Abort compiler when rpc fails as unauthenticated by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2887
- feat(codegen): Add support for pgvector and pgvector-go by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2888
- docs: Update getting started guides, use pgx for Postgres guide by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2891
- docs: Use managed databases in PostgreSQL getting started guide by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2892
- test: Enabled pgvector tests for managed dbs by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2893
- feat(analyzer): Cache query analysis by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2889
- fix(vet): Remove rollback statements from DDL by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2895
- feat(createdb): Create ephemeral databases by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2894
- docs: Update managed databases doc to discuss codegen by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2897
- docs: Add managed dbs to CI/CD and vet guides by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2896
- feat(debug): Add databases=managed debug option by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2898
- build(deps): Upgrade wasmtime-go from 13.0.0 to 14.0.0 by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2900
- feat(config): Remove managed database validation by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2901
- refactor(codegen): Removed deprecated code and improved speed by @quenbyako in https://github.com/sqlc-dev/sqlc/pull/2899
- docs: Document database-backed query analyzer by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2904
- docs: Release notes for v1.23.0 by @andrewmbenton in https://github.com/sqlc-dev/sqlc/pull/2907
- Release v1.23.0 by @kyleconroy in https://github.com/sqlc-dev/sqlc/pull/2908
New Contributors
- @Hyuga-Tsukui made their first contribution in https://github.com/sqlc-dev/sqlc/pull/2807
- @kalogs-c made their first contribution in https://github.com/sqlc-dev/sqlc/pull/2819
- @xsadia made their first contribution in https://github.com/sqlc-dev/sqlc/pull/2828
- @sapk made their first contribution in https://github.com/sqlc-dev/sqlc/pull/2680
- @juanjuanzero made their first contribution in https://github.com/sqlc-dev/sqlc/pull/2870
- @quenbyako made their first contribution in https://github.com/sqlc-dev/sqlc/pull/2899
Full Changelog: https://github.com/sqlc-dev/sqlc/compare/v1.22.0...v1.23.0