Posts tagged "sqlite"

A finished query can leave a read transaction open. Use Rust to see how that snapshot limits SQLite checkpoints and what changes when the reader ends.

Keep an interactive SQLite importer resumable and bounded. Commit batches with their progress and give foreground writes an explicit busy policy.

A valid Rust project ID can still reference a missing row. Check foreign-key enforcement when opening each connection and exercise real deletion rules.

Build a small local notes store with rusqlite, a versioned schema, bound values, transactions, and a check that committed data survives reopening.

Give one thread a SQLite connection, limit its request queue, and check that Tokio can run another task while a submitted write remains pending.