Announcing SQLx 0.3 - Now with SQLite

:toolbox: The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.

Crates.io version chat docs.rs docs Download

  • Truly Asynchronous . Built from the ground-up using async/await for maximum concurrency.

  • Type-safe SQL (if you want it) without DSLs. Use the query!() macro to check your SQL and bind parameters at compile time. (You can still use dynamic SQL queries if you like.)

  • Database Agnostic . Support for PostgreSQL, MySQL, and SQLite.

  • Pure Rust . The Postgres and MySQL/MariaDB drivers are written in pure Rust using zero unsafe code.

  • Runtime Agnostic . Works on async-std or tokio with the runtime-async-std or runtime-tokio cargo feature flag.

† SQLx uses #![forbid(unsafe_code)] unless the sqlite feature is enabled. As the SQLite driver interacts with C, those interactions are unsafe .


Changelog

v0.3

This release is the culmination of a lot of work from us at the LaunchBadge team, as well as an overwhelming influx of new contributors, which is something we're extremely grateful for.

  • SQLite3

  • User-defined types with derives (enumerations and structural records)

  • LISTEN / NOTIFY in Postgres

  • Many more types ( JSON/JSONB, NUMERIC, arrays, composites, and more )

See details in the changelog.

5 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.