v0.22.2

Release version v0.22.2

Release sha256 is 40af6dbb1447fb42f9e12d094a79e5adbfcb3669470cf7055896a179ee2e7427

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.22.2/sqlc-gen-csharp.wasm
    sha256: 40af6dbb1447fb42f9e12d094a79e5adbfcb3669470cf7055896a179ee2e7427

Changelog

0a50e11 - Ilan Uzan, 3 minutes ago : [release] fix: GetIdColumnType bugfix (#387)

Contributors

• @SockworkOrange

v0.22.1

Release version v0.22.1

Release sha256 is 0b07a86555e7adf9aed7f5e4eeb5f89762e182420574edf81cf98173e0d80121

Notable changes

We have made significant improvements to the performance of our generated code and introduced a performance benchmark for future reference, here are the current benchmark results:

Provider	Operation	Metric	SQLC	EF Core	SQLC Advantage
MySQL	Read (High Load)	Time	2.85 s	15.47 s	5.4x Faster
		Memory	178 MB	783 MB	77% Less RAM
	Write (300K rows)	Time	3.96 s	77.76 s	19.6x Faster
Postgres	Read (High Load)	Time	11.91 s	12.48 s	1.05x Faster
		Memory	131 MB	387 MB	66% Less RAM
	Write (300K rows)	Time	4.25 s	24.52 s	5.7x Faster
SQLite	Read (High Load)	Time	9.17 s	10.27 s	1.1x Faster
		Memory	127 MB	343 MB	63% Less RAM
	Write (300K rows)	Time	10.74 s	17.81 s	1.6x Faster

📈 Key Takeaways

• Massive Write Performance: SQLC demonstrated an incredible 19.6x speed increase over EF Core in MySQL bulk-write operations (300K rows), reducing execution time from over 77 seconds to under 4 seconds.
• Superior Memory Efficiency: Across all database providers, SQLC consistently used 60% to 77% less memory. This significantly reduces pressure on the Garbage Collector (GC) and lowers operational costs for high-traffic services.
• Optimized for High Load: In complex MySQL read scenarios with high query counts, SQLC remained stable at 2.85s while EF Core's performance degraded to 15.47s (a 5.4x difference).

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.22.1/sqlc-gen-csharp.wasm
    sha256: 0b07a86555e7adf9aed7f5e4eeb5f89762e182420574edf81cf98173e0d80121

Changelog

9d4ac9a - Ilan Uzan, 3 minutes ago : [release] * feat: Add read & write performance benchmark with efcore for all databases (#357)
d9c88a9 - Ilan Uzan, 4 weeks ago : fix: empty options usecase in ExamplesDocGen (#355)

Contributors

• @SockworkOrange

v0.22.0

Release version v0.22.0

Release sha256 is 9de8713ddcde8f21787ed925fb65744aa04f027ea6c23320292dc31d28aab80d

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.22.0/sqlc-gen-csharp.wasm
    sha256: 9de8713ddcde8f21787ed925fb65744aa04f027ea6c23320292dc31d28aab80d

Changelog

07ba684 - Ilan Uzan, 3 minutes ago : [release] [minor] feat: add Async suffix to generated methods by default (#354)
bdb9f51 - Doron Eli, 18 minutes ago : support multi-line sql code generation (#352)
acd05d4 - Jan Biehl, 11 days ago : [minor] Opt out of centralized package management (#339)
2635255 - Doron Eli, 3 weeks ago : fix plugin run without option field (#351)
f2e985f - Ilan Uzan, 6 weeks ago : feat: enable override timestamp to NodaTime.Instant (#335)

Contributors

• @SockworkOrange
• @doron050
• @janbiehl

v0.21.4

Release version v0.21.4

Release sha256 is ceb948980f5a49e2922824f068f812f9ac70287da6dcc8c8199c8b4ceeaec858

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.21.4/sqlc-gen-csharp.wasm
    sha256: ceb948980f5a49e2922824f068f812f9ac70287da6dcc8c8199c8b4ceeaec858

Changelog

6a50da7 - Ilan Uzan, 3 minutes ago : [release] feat: allow override for SQLite integer and text types to bool (#332)
543a9cc - Ilan Uzan, 4 days ago : fix: remove redundant directory (#321)
133d684 - github-actions[bot], 5 days ago : update docs (#320)

Contributors

• @SockworkOrange

v0.21.3

Release version v0.21.3

Release sha256 is a295dd8438c93c1b93d9d6d9e7706913dfade92caf19dbe86ed533214d3dc1ed

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.21.3/sqlc-gen-csharp.wasm
    sha256: a295dd8438c93c1b93d9d6d9e7706913dfade92caf19dbe86ed533214d3dc1ed

Changelog

ecda614 - Ilan Uzan, 3 minutes ago : [release] feat: add option to override string to DateTime for Sqlite (#317)
843cbcc - Ilan Uzan, 2 hours ago : fix: move all tests to be under unit-tests directory (#319)
5ccbb4c - Doron Eli, 2 days ago : [patch] Add test for non null enum type (#315)
d2f7883 - ballistic-booger, 2 weeks ago : fix for not null enum type (#314)
b1b8e7d - Ilan Uzan, 3 weeks ago : fix: upgrade sqlc version to 1.30 (#312)
d8c5a07 - github-actions[bot], 3 weeks ago : update docs (#311)

Contributors

• @SockworkOrange
• @doron050
• @ballistic-booger

v0.21.2

Release version v0.21.2

Release sha256 is 98990c2a46b0e315c7f062f5643e3404ed4150a5ef2808c47a4e10084443506e

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.21.2/sqlc-gen-csharp.wasm
    sha256: 98990c2a46b0e315c7f062f5643e3404ed4150a5ef2808c47a4e10084443506e

Changelog

225ecdf - Ilan Uzan, 3 minutes ago : [release] fix: dotnet warnings (#310)
0be5676 - Ilan Uzan, 2 days ago : fix: refactor enum extensions members (#309)
e13d586 - Ilan Uzan, 3 days ago : fix: update Postgres docs (#308)
62f6e5e - Ilan Uzan, 5 days ago : clean old stale branchs (#274)

Contributors

• @SockworkOrange

v0.21.1

Release version v0.21.1

Release sha256 is f687963c30bbe2a3d4a2abe8343538f3daa1271f683580e779065285304787b9

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.21.1/sqlc-gen-csharp.wasm
    sha256: f687963c30bbe2a3d4a2abe8343538f3daa1271f683580e779065285304787b9

Changelog

7501e7f - Ilan Uzan, 3 minutes ago : [release] [patch] fix: support Postgres JSON data types without cast and in batch insert (#272)
f37ede1 - github-actions[bot], 7 days ago : update docs (#269)

Contributors

• @SockworkOrange

v0.21.0

Release version v0.21.0

Release sha256 is 6a01b8c24418abff5d3c272dd1b4ad69f2b43939bb8866243947db3d167a079c

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.21.0/sqlc-gen-csharp.wasm
    sha256: 6a01b8c24418abff5d3c272dd1b4ad69f2b43939bb8866243947db3d167a079c

Changelog

321c3ec - Ilan Uzan, 3 minutes ago : [release] [minor] fix: standardize assertions across end2end tests (#268)
7f80202 - Ilan Uzan, 11 days ago : feat: support set data type in mysql (#266)
a7ff473 - Doron Eli, 11 days ago : [patch] fix multiple use of name param in sqlite (#267)
49e78fd - github-actions[bot], 3 weeks ago : update docs (#265)

Contributors

• @SockworkOrange
• @doron050

v0.20.0

Release version v0.20.0

Release sha256 is 3d0a7d09a93b6135c4e043acbbd862d28e2535f20a43292a842a75ac37f35aa0

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.20.0/sqlc-gen-csharp.wasm
    sha256: 3d0a7d09a93b6135c4e043acbbd862d28e2535f20a43292a842a75ac37f35aa0

Changelog

5c676bb - Ilan Uzan, 3 minutes ago : [release] [minor] fix: sqlite arguments regex (#264)
4dee8d2 - Ilan Uzan, 11 hours ago : feat: support uuid as id column in Postgres (#261)
70803db - Ilan Uzan, 8 days ago : fix: removing NpgsqlTypeOverrides - relying on driver defaults when possible (#260)

Contributors

• @SockworkOrange

v0.19.0

Release version v0.19.0

Release sha256 is 82e1a2dfc44ba5052c1e310aa2cda82d2825b8dc57000ce4dd6519249e5ea0fe

Configuration example

version: '2'
plugins:
- name: csharp
  wasm:
    url: https://github.com/DaredevilOSS/sqlc-gen-csharp/releases/download/v0.19.0/sqlc-gen-csharp.wasm
    sha256: 82e1a2dfc44ba5052c1e310aa2cda82d2825b8dc57000ce4dd6519249e5ea0fe

Changelog

bbee0b2 - Ilan Uzan, 3 minutes ago : [release][minor] Support JSON & network data types in Postgres
a672655 - Ilan Uzan, 2 weeks ago : feat: support JSON data type in MySQL (#257)

Contributors

• @SockworkOrange