Show HN: sqlc-gen-sqlx, a sqlc plugin for generating sqlx Rust code

https://github.com/mathematic-inc/sqlc-gen-sqlx

1•jrandolf•1h ago

`sqlc-gen-sqlx` is a `sqlc` (https://sqlc.dev) plugin that generates `sqlx`-oriented Rust code from annotated SQL queries.

The generated API is intentionally small:

- a `const SQL`

- row structs for `:one` and `:many`

- params structs when a query has multiple parameters

- methods on `Queries<E>` that work with `&PgPool`, `&mut PgConnection`, or `&mut Transaction`

Current scope is PostgreSQL. It supports the usual `sqlc` query annotations, plus enums, composite types, batch queries, `COPY FROM`, `sqlc.slice()`, `sqlc.embed()`, and type overrides.

Comments

leeknoww•1h ago

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?

jrandolf•1h ago

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

Caffeine, cocaine, and painkillers detected in sharks from The Bahamas

MRRescue

The problematic contradictions of OpenAI's "Industrial Policy» document

Opus 4.6 hallucinates twice as more today than when it released

GPS Explained (2022)

Forgejo monthly report – March 2026

Levels of AI Adoption for Project Managers

Debian 12 Server Guides

Mhm AGI on a Docker Compose?

That's a Skill Issue

Gen Z fearful AI will take their job they're sabotaging company's AI rollout

India's Navigation System Faces Operational Challenge After Atomic Clock Failure

Tracking down a 25 percent LLVM RISC-V regression

Constellations

Show HN: Amber, a capability-based runtime/compiler for agent benchmarks

SQL Has Problems. We Can Fix Them: Pipe Syntax in SQL (2024)

Show HN: GitBalance – a GitHub-style graph to balance work and health

A Terminal UI (TUI) Alternative to GHelper for Asus ROG / TUF Laptops on Linux

The pros and cons of stretch goals

Pix: How Brazil Built the Perfect Payment System [video]

Oracle gave its new CFO $26M in stock after firing up to 30k workers

Data breach at European fitness chain Basic-Fit [pdf]

Hybrid search (BM25/vectors/RRF) barely improved over pure semantic

NavIC's Clock Crisis, and the Indian Clocks That Could Fix It

Show HN: Show HN:CryptographicTimestamps4 human testimony(2HTMLfiles,noserver)

Tell HN: AI is bringing back waterfall, here's what I've found

A Git helper tool that breaks large merges into parallelizable tasks

If You're Only Running One Claude Code Session, You're Not Going Fast Enough

We built a Green Screen Remover tool to automate batch green screen removal

Ask HN: How are you handling runtime security for your AI agents?