ankurah-storage-sqlite 0.7.18

Ankurah storage engine using SQLite
Documentation

SQLite storage engine for Ankurah

Provides a lightweight embedded database storage option using SQLite. Sits between Sled (pure KV) and Postgres (full SQL server), offering:

  • Single-file database (portable, easy backup)
  • Full SQL query capabilities without external server
  • Native support on all platforms including mobile (iOS, Android)

SQLite Version Requirements

This implementation requires SQLite 3.45.0 or later for JSONB support. The rusqlite crate with the "bundled" feature includes a compatible SQLite version by default. JSONB support enables:

  • jsonb() function for type-aware JSON comparisons
  • -> and ->> operators for JSON path traversal
  • Efficient JSONB storage as BLOB

See SQLite JSON documentation for details.

Example

use ankurah_storage_sqlite::SqliteStorageEngine;

// Open a file-based database
let storage = SqliteStorageEngine::open("myapp.db").await?;

// Or use an in-memory database for testing
let storage = SqliteStorageEngine::open_in_memory().await?;