Struct SqliteIndex 

pub struct SqliteIndex { /* private fields */ }

SQLite-backed sparse index using FTS5 for BM25 search.

Unlike BM25Index (in-memory HashMap), this persists to disk and delegates BM25 scoring to SQLite’s FTS5 extension.

The Connection is wrapped in a Mutex to satisfy the Send + Sync bounds required by SparseIndex. Mutex<T> is Sync when T: Send, and rusqlite::Connection is Send. SQLite in WAL mode supports concurrent readers via separate connections; this single-connection design serializes access within one process.

Implementations

impl SqliteIndex

pub fn open(path: impl AsRef<Path>) -> Result<Self>

Open or create an index at the given path.

pub fn open_in_memory() -> Result<Self>

Open an in-memory index (for testing).

pub fn document_count(&self) -> Result<usize>

Get document count.

pub fn chunk_count(&self) -> Result<usize>

Get chunk count.

pub fn needs_reindex(&self, path: &str, hash: &[u8; 32]) -> Result<bool>

Check if a document needs reindexing by fingerprint.

pub fn insert_document( &self, doc_id: &str, title: Option<&str>, source: Option<&str>, content: &str, chunks: &[(String, String)], fingerprint: Option<(&str, &[u8; 32])>, ) -> Result<()>

Batch-insert a document and its chunks within a transaction.

pub fn remove_document(&self, doc_id: &str) -> Result<()>

Remove a document and its chunks.

Explicitly deletes chunks first (which fires FTS5 sync triggers), then deletes the document row.

pub fn list_fingerprints(&self) -> Result<Vec<(String, Vec<u8>)>>

List all tracked fingerprints (path → blake3 hash).

Used by incremental indexing to detect deleted or changed files.

pub fn remove_by_source(&self, source: &str) -> Result<usize>

Remove all documents (and their chunks) with a given source path.

Used by incremental indexing to remove stale documents before re-inserting.

pub fn search_fts(&self, query: &str, k: usize) -> Result<Vec<FtsResult>>

FTS5 BM25 search. Returns results ordered by descending relevance.

pub fn get_chunk(&self, chunk_id: &str) -> Result<Option<String>>

Get chunk content by ID.

pub fn get_metadata(&self, key: &str) -> Result<Option<String>>

Get a metadata value by key.

pub fn set_metadata(&self, key: &str, value: &str) -> Result<()>

Set a metadata key-value pair.

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

Vacuum and optimize the database.

Trait Implementations

impl Debug for SqliteIndex

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

Formats the value using the given formatter.

impl SparseIndex for SqliteIndex

fn add(&mut self, chunk: &Chunk)

Index a chunk

fn add_batch(&mut self, chunks: &[Chunk])

Index multiple chunks

fn search(&self, query: &str, k: usize) -> Vec<(ChunkId, f32)>

Search for matching chunks

fn remove(&mut self, chunk_id: ChunkId)

Remove a chunk from the index

fn len(&self) -> usize

Get the number of indexed documents

fn is_empty(&self) -> bool

Check if the index is empty