Struct SqliteBackend 

pub struct SqliteBackend { /* private fields */ }

Implementations

impl SqliteBackend

pub async fn new(url: &str) -> Result<Self>

Create a new SQLite backend with connection pool

pub async fn memory() -> Result<Self>

Create an in-memory SQLite database

pub async fn file(path: &str) -> Result<Self>

Create a file-based SQLite database

pub async fn optimize(&mut self) -> Result<()>

Optimize the database (VACUUM)

pub async fn analyze(&mut self) -> Result<()>

Analyze the database for query optimization

pub async fn database_size(&mut self) -> Result<i64>

Get database size in bytes

pub async fn list_tables(&mut self) -> Result<Vec<String>>

Get list of all tables

pub async fn table_info(&mut self, table_name: &str) -> Result<Vec<ColumnInfo>>

Get table info

pub async fn checkpoint(&mut self) -> Result<()>

Checkpoint the WAL file

Trait Implementations

impl DatabaseBackend for SqliteBackend

fn connect<'life0, 'async_trait>( url: &'life0 str, ) -> Pin<Box<dyn Future<Output = Result<Self>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Connect to the database

fn execute<'life0, 'life1, 'async_trait>( &'life0 mut self, sql: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<u64>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Execute a SQL statement (no results)

fn query<'life0, 'life1, 'async_trait>( &'life0 mut self, sql: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<QueryResult>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Query and return results

fn begin_transaction<'life0, 'async_trait>( &'life0 mut self, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Begin a transaction

fn commit<'life0, 'async_trait>( &'life0 mut self, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Commit the current transaction

fn rollback<'life0, 'async_trait>( &'life0 mut self, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Rollback the current transaction

fn is_connected(&self) -> bool

Check if connected

fn close<'async_trait>( self, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait,

Close the connection