2 unstable releases
0.25.0 | Aug 22, 2024 |
---|---|
0.24.0 | Jun 7, 2024 |
#987 in Database interfaces
2,790 downloads per month
Used in 23 crates
(via holochain_sqlite)
9KB
102 lines
r2d2-sqlite
r2d2 connection pool for sqlite based on Steven Fackler's r2d2-postgres.
lib.rs
:
Sqlite support for the r2d2
connection pool.
Library crate: r2d2-sqlite
Integrated with: r2d2 and rusqlite
Example
extern crate r2d2;
extern crate r2d2_sqlite;
extern crate rusqlite;
use std::thread;
use r2d2_sqlite::SqliteConnectionManager;
use rusqlite::params;
fn main() {
let manager = SqliteConnectionManager::file("file.db");
let pool = r2d2::Pool::new(manager).unwrap();
pool.get()
.unwrap()
.execute("CREATE TABLE IF NOT EXISTS foo (bar INTEGER)", params![])
.unwrap();
(0..10)
.map(|i| {
let pool = pool.clone();
thread::spawn(move || {
let conn = pool.get().unwrap();
conn.execute("INSERT INTO foo (bar) VALUES (?)", &[&i])
.unwrap();
})
})
.collect::<Vec<_>>()
.into_iter()
.map(thread::JoinHandle::join)
.collect::<Result<_, _>>()
.unwrap()
}
Dependencies
~28MB
~453K SLoC