Struct SqlitePool 

pub struct SqlitePool { /* private fields */ }

A connection pool for SQLite.

This pool provides connection reuse for file-based SQLite databases, significantly improving performance by avoiding repeated connection opens.

Example

use prax_sqlite::{SqlitePool, SqliteConfig};

let pool = SqlitePool::new(SqliteConfig::file("data.db")).await?;
let conn = pool.get().await?;
// Use connection...
// Connection is returned to pool when dropped

Implementations

impl SqlitePool

pub async fn new(config: SqliteConfig) -> SqliteResult<Self>

Create a new connection pool from configuration.

pub async fn with_pool_config( config: SqliteConfig, pool_config: PoolConfig, ) -> SqliteResult<Self>

Create a new connection pool with custom pool configuration.

pub async fn get(&self) -> SqliteResult<SqliteConnection>

Get a connection from the pool.

For file-based databases, this will try to reuse an idle connection before opening a new one. For in-memory databases, always opens a new connection (since each connection has its own database).

pub fn config(&self) -> &SqliteConfig

Get the pool configuration.

pub fn pool_config(&self) -> &PoolConfig

Get the pool settings.

pub fn stats(&self) -> PoolStats

Get pool statistics.

pub fn reset_stats(&self)

Reset pool statistics.

pub async fn is_healthy(&self) -> bool

Check if the pool is healthy by attempting to get a connection.

pub fn available_permits(&self) -> usize

Get the number of available permits (potential concurrent connections).

pub fn idle_count(&self) -> usize

Get the number of idle connections in the pool.

pub fn builder() -> SqlitePoolBuilder

Create a builder for configuring the pool.

Trait Implementations

impl Clone for SqlitePool

fn clone(&self) -> SqlitePool

Returns a duplicate of the value.

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

Performs copy-assignment from source.