SQLx: The Rust SQL Toolkit
SQLx is an asynchronous, pure Rust SQL crate that enables developers to write and execute SQL queries with compile-time safety and without relying on a domain-specific language (DSL). It supports multiple databases and provides features like connection pooling, automatic statement preparation, and row streaming, making it ideal for high-performance applications that require robust database interactions.
Features
Truly asynchronous with built-in support for async/await
Compile-time checked queries ensuring SQL correctness
Database agnostic, supporting PostgreSQL, MySQL, MariaDB, and MSSQL
Pure Rust implementation with zero unsafe code in key drivers
Cross-platform compatibility and easy integration with various runtimes
Built-in connection pooling and row streaming for efficient data handling
Automatic statement preparation and caching to optimize query execution
Support for nested transactions and asynchronous notifications