Verify SQL queries at compile time in Rust applications using sqlx.
npx skills add https://github.com/patrickhaahr/dotfiles --skill sqlx
Please help me install this Agent Skill. Skill: sqlx Source: https://github.com/patrickhaahr/dotfiles/tree/main/opencode/.config/opencode/skills/sqlx Command: npx skills add https://github.com/patrickhaahr/dotfiles --skill sqlx
sqlx provides a pragmatic approach to executing SQL in Rust without an ORM, offering compile-time verification of queries and safe async execution for database-backed applications. It ensures you can write raw SQL while catching errors at compile time.
Create a Rust project, add sqlx to Cargo.toml with the appropriate features (runtime and database), then establish a connection pool and run a compile-time checked query.
High-intent search queries and answers about installing and using this skill.
Compile-time SQL verification in Rust is achieved using sqlx macros like query! and query_as!, which check raw SQL against your database schema during the build process. This catches query errors early without requiring an ORM.
Yes, you can execute SQL queries asynchronously in Rust with PostgreSQL, MySQL, MariaDB, and SQLite. The sqlx crate provides non-blocking database execution that integrates smoothly with async runtimes like tokio, async-std, or actix.
The best way to catch database query errors before running a Rust application is compile-time SQL verification. By using sqlx macros, the Rust compiler validates your SQL syntax and types against the live database, preventing runtime failures.
To set up compile-time checked SQL queries, create a Rust project, add sqlx to your Cargo.toml with the appropriate runtime and database features, establish a database connection pool, and use the query! macro for your SQL statements.
Compile-time SQL verification works across multiple databases in Rust, offering database-agnostic support for PostgreSQL, MySQL, MariaDB, and SQLite. This allows you to build high-performance microservices with precise cross-database SQL control.
Compile-time SQL macros are used instead of an ORM for Rust microservices to provide safe, direct SQL execution with minimal boilerplate. This approach ensures high performance and precise SQL control while still catching syntax errors during compilation.
imehrImplement Rust database access patterns with SQLx and Diesel.
ngxtmExecute compile-time checked asynchronous SQL queries in Rust with sqlx.
zhenzhizhi12Encode and decode JSON in Cangjie using stdx.encoding.json.
ShaulLavoProvide type-safe SQL ORM queries for TypeScript applications.
