Struct Database 

pub struct Database {
    pool: SqlitePool,
}

Database handle providing synchronous API over async SQLx operations. Uses a bridge pattern with RUNTIME.block_on() to maintain synchronous interface for compatibility with existing single-threaded event loop.

Fields

pool: SqlitePool

Implementations

impl Database

pub fn new<P: AsRef<Path> + Debug>(path: P) -> Result<Self, Error>

Create a new database connection pool.

Does not run any migrations — call Database::migrate after construction.

Arguments

• path - Path to the SQLite database file (will be created if it doesn’t exist)

Returns

• Ok(Database) - Successfully connected database
• Err(Error) - Connection failure

pub fn close(&self)

Close all connections in the pool, checkpointing WAL and releasing file handles.

After calling this, no further database operations should be performed. This must be called before unmounting the filesystem that contains the database file, to ensure SQLite releases all file descriptors and flushes any pending WAL data.

pub fn pool(&self) -> &SqlitePool

Returns a reference to the SQLite connection pool.

pub fn migration_runner(&self) -> MigrationRunner

Returns a MigrationRunner bound to this database’s pool.

Use this to execute all registered runtime migrations after the database is initialized.

pub fn migrate(&self) -> Result<(), Error>

Run all migrations: sqlx file migrations first, then runtime macro migrations.

Must be called once after Database::new before the database is used. Intended for use in the synchronous startup path.

Trait Implementations

impl Clone for Database

fn clone(&self) -> Database

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Database

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

Formats the value using the given formatter.