News for hackers. Stuff that matters.

A comment on Show HN: sqlc-gen-sqlx, a sqlc plugin for generating sqlx Rust code.

Re:Show HN: sqlc-gen-sqlx, a sqlc plugin for generating sqlx... by leeknoww on Monday April 13, 2026 @02:41AM (#47748475)
How does this handle prepared statement caching compared to writing sqlx queries directly? Been burned before by N+1 prepared statement creation in high-throughput services. Also curious if there's a migration story since sqlc plugins are relatively new, did you hit any gotchas moving existing sqlx codebases over?
[ Parent | on HN ]
Re:Show HN: sqlc-gen-sqlx, a sqlc plugin for generating sqlx... by jrandolf on Monday April 13, 2026 @02:58AM (#47748608)
This plugin uses sqlx underneath which handles prepared statement caching. Regarding migration, we just used a coding agent to migrate our database infrastructure to it. It takes <20 minutes and remember this really only helps with static queries. We do support sqlc's dynamic queries though.

Tip: you can use case statements and etc. to create static queries even when you have conditionals.

Also, read https://news.ycombinator.com/newsguidelines.html#generated

[ Parent | on HN ]