sqll 0.14.3

Efficient interface to SQLite that doesn't get in your way
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

use std::io::{self, Write};

use std::time::Instant;

use sqll::{OpenOptions, Row};

#[derive(Row)]
struct Person<'stmt> {
    id: i32,
    name: &'stmt str,
}

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let c = OpenOptions::new()
        .create()
        .read_write()
        .no_mutex()
        .open("wal-people.db")?;

    c.execute(
        r#"
        pragma journal_mode = WAL;

        CREATE TABLE IF NOT EXISTS persons (
            id INTEGER PRIMARY KEY,
            name TEXT NOT NULL
        )
        "#,
    )?;

    let mut stmt = c
        .prepare_with("SELECT id, name FROM persons")
        .persistent()
        .build()?;

    // WAL only supports one writer, if you run this in multiple processes this
    // checks at what point the write operation fails.
    loop {
        let mut o = io::sink();

        let start = Instant::now();
        let mut c = 0;

        for _ in 0..100_000 {
            stmt.reset()?;

            writeln!(o, "Found persons:")?;

            while let Some(p) = stmt.next::<Person<'_>>()? {
                c += 1;
                writeln!(o, "ID: {}, Name: {}", p.id, p.name)?;
            }
        }

        println!("Elapsed: {:?}", start.elapsed());
        println!("Total persons found: {c}");
    }
}