Struct SqliteIndexedDB 

pub struct SqliteIndexedDB { /* private fields */ }

Main database interface that combines SQLite with IndexedDB persistence

Implementations

impl SqliteIndexedDB

pub async fn new(config: DatabaseConfig) -> Result<Self, DatabaseError>

pub async fn execute(&mut self, sql: &str) -> Result<QueryResult, DatabaseError>

pub fn prepare( &mut self, sql: &str, ) -> Result<PreparedStatement<'_>, DatabaseError>

Prepare a SQL statement for efficient repeated execution

Example

let mut stmt = db.prepare("SELECT * FROM users WHERE id = ?").unwrap();
for i in 1..=100 {
    let result = stmt.execute(&[ColumnValue::Integer(i)]).await.unwrap();
}
stmt.finalize().unwrap();

pub async fn execute_with_params( &mut self, sql: &str, params: &[ColumnValue], ) -> Result<QueryResult, DatabaseError>

pub async fn execute_batch( &mut self, statements: &[String], ) -> Result<(), DatabaseError>

Execute multiple SQL statements as a batch This is more efficient than calling execute() multiple times when crossing FFI boundaries as it reduces the number of bridge calls from N to 1

pub async fn sync(&mut self) -> Result<(), DatabaseError>

pub async fn close(&mut self) -> Result<(), DatabaseError>

pub fn get_connection(&self) -> &Connection