Struct DbPools 

pub struct DbPools { /* private fields */ }

Read pool + dedicated single-connection write pool for the same SQLite file. SQLite is single-writer system-wide, so a multi-connection pool fighting for the writer lock just generates SQLITE_BUSY and (under deferred transactions) SQLITE_BUSY_SNAPSHOT. Funnelling all writes from one process through a single connection turns within-process contention into an in-process queue (deterministic) instead of SQLite-level lock contention (probabilistic, retry-required). Reads keep the wider pool — WAL mode lets readers run concurrently.

Implementations

impl DbPools

pub async fn open( db_path: &Path, max_read_connections: u32, connect_timeout: Duration, busy_timeout: Duration, ) -> Result<Self, Error>

Open both pools for the SQLite file at db_path with shared PRAGMAs.

The write pool connects first so WAL mode (persisted in the database header) is set before the read pool opens. max_read_connections sizes only the read pool; the write pool is always single-connection by design.

pub fn read(&self) -> &DbReadConnection

Borrow the read pool (multi-connection).

pub fn write(&self) -> &DbWriteConnection

Borrow the write pool (single-connection, retries handled inside).

Trait Implementations

impl Debug for DbPools

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.