rust-sqlx-patterns

What problem does it solve?

Writing clean, maintainable database access in Rust by providing proven SQLx patterns for reads, writes, transactions, and dynamic queries.

Core Features & Use Cases

• Simple Reads/Writes: wrap queries into small helper functions using PgPool and map results to domain structs.
• Transactional Operations: use Transaction<'_, Postgres> to guarantee atomicity across statements.
• Reusable Queries with PgExecutor: write generic queries that work with a pool or a transaction.
• Complex/Optional Filters with SeaQuery: build dynamic filters for flexible querying.
• Migrations: structure and guidelines for SQL migrations with sqlx.

Quick Start

Start by implementing a simple read or write against a PgPool, then upgrade to transactional blocks and a reusable PgExecutor for complex operations.