A library to interact with sqlite from an async context.
This library is tested on both tokio and async_std, however it should be compatible with all async runtimes.
Add async-sqlite to your "dependencies" in your Cargo.toml file.
This can be done by running the command:
cargo add async-sqlite
A Client represents a single background sqlite3 connection that can be called
concurrently from any thread in your program.
To create a sqlite client and run a query:
```rust use async_sqlite::{ClientBuilder, JournalMode};
let client = ClientBuilder::new() .path("/path/to/db.sqlite3") .journal_mode(JournalMode::Wal) .open() .await?;
let value: String = client.conn(|conn| { conn.query_row("SELECT val FROM testing WHERE id=?", [1], |row| row.get(0)) }).await?;
println!("Value is: {value}"); ```
A Pool represents a collection of background sqlite3 connections that can be
called concurrently from any thread in your program.
To create a sqlite pool and run a query:
```rust use async_sqlite::{JournalMode, PoolBuilder};
let pool = PoolBuilder::new() .path("/path/to/db.sqlite3") .journal_mode(JournalMode::Wal) .open() .await?;
let value: String = pool.conn(|conn| { conn.query_row("SELECT val FROM testing WHERE id=?", [1], |row| row.get(0)) }).await?;
println!("Value is: {value}"); ```
This library tries to export almost all features that the underlying rusqlite library contains.
A notable difference is that the bundled feature is enabled by default,
but can be disabled with the following line in your Cargo.toml:
toml
async-sqlite = { version = "*", default-features = false }