spg-embedded 7.9.31

Embedded SQL database for Rust. Single-writer, WAL-backed, crash-safe. Zero external dependencies. PG-flavoured SQL with FOREIGN KEY, JOINs, vectors (HNSW/pgvector ops), and a cold tier.
Documentation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
//! 30-second tour. `cargo run --example hello`.

use spg_embedded::Database;

fn main() -> Result<(), spg_embedded::EngineError> {
    let mut db = Database::open_in_memory();
    db.execute("CREATE TABLE users (id INT NOT NULL, name TEXT)")?;
    db.execute("INSERT INTO users VALUES (1, 'alice'), (2, 'bob')")?;
    let rows = db.query("SELECT id, name FROM users ORDER BY id")?;
    for row in rows {
        println!("{row:?}");
    }
    Ok(())
}