Struct DbPool 

pub struct DbPool { /* private fields */ }

Thread-safe SQLite connection pool (single writer via Mutex).

For a web server workload the single-writer approach is acceptable because SQLite WAL mode allows concurrent readers. All writes are serialised through the Mutex.

Implementations

impl DbPool

pub fn open(db_path: &Path) -> Result<Self, Error>

Open or create the SQLite database at the given path and run migrations.

Errors

Returns an error if the database cannot be opened or migrations fail.

pub fn open_in_memory() -> Result<Self, Error>

Open an in-memory database (useful for tests).

Errors

Returns an error if the in-memory database cannot be created.

pub fn with_conn<F, T>(&self, f: F) -> Result<T, Error>

where F: FnOnce(&Connection) -> Result<T, Error>,

Execute a closure with an exclusive lock on the connection.

Errors

Returns any error produced by the closure. If the internal mutex is poisoned, recovers the guard and continues to serve requests.

Trait Implementations

impl Clone for DbPool

fn clone(&self) -> DbPool

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.