How do you work with SQLite in Rust?

Question

Accepted Answer

**rusqlite** — SQLite bindings.

**Basic:**
```rust
use rusqlite::{Connection, Result};

fn main() -> Result<()> {
    let conn = Connection::open("my.db")?;

conn.execute(
        "CREATE TABLE IF NOT EXISTS users (
            id INTEGER PRIMARY KEY,
            name TEXT NOT NULL
        )",
        [],
    )?;

conn.execute(
        "INSERT INTO users (name) VALUES (?1)",
        ["Alice"],
    )?;

let name: String = conn.query_row(
        "SELECT name FROM users WHERE id = 1",
        [],
        |row| row.get(0),
    )?;

Ok(())
}
```

**Key:** rusqlite for SQLite, execute for queries.

Rust: How do you work with SQLite in Rust?