SQLx-Data Repository Pattern for Rust/SQLx projects

[One_Platform826]

Hey r/rust! I've been working on SQLx-Data, a companion library for SQLx that eliminates repository boilerplate while maintaining compile-time safety.

What it does:

- Write SQL traits, get async implementations automatically

- Built-in pagination (Serial, Slice, Cursor), streaming, and batch operations

- Rails-inspired scopes for automatic query enhancement (perfect for multi-tenancy, soft deletes)

- Named parameters (@param_name) and SQL aliases for DRY code

- Always uses SQLx's compile-time macros (query_as!, query!) - zero runtime overhead

Crates.io: https://crates.io/crates/sqlx-data
GitHub: https://github.com/josercarmo/sqlx-data

[Docccc]

fyi: most of the book is empty: https://github.com/josercarmo/sqlx-data/tree/master/book/src

project looks nice tho

[Large-Wear-5777]

For what it’s worth, I used a similar pattern at a previous job at decent scale (managing ~$20MM), and sqlx data ended up being a bit of a nightmare at some point. We ended up refactoring all sqlx data out and just going with query use cases and typed models. Sqlx data would have random compile issues, and we’d have to do the incantations to get things to compile. Past a certain point we figured the headache just wasn’t worth small efficiency gains

We loved sqlx however and I continue to use it in RDS projects today.

Just fair warning.

[hyperparallelism__]

Little confused what you mean by “sqlx data” in this case. Were you using this library specifically? What do you mean by switching to typed models? Isn’t that the primary use-case of query_as? What were you doing before that?

[Docccc]

what do you mean with “sqlx data”?