nexcore-db — Persistent SQLite storage for NexCore Brain working memory.

Replaces the file-based JSON storage with a single SQLite database, providing ACID transactions, WAL mode for concurrent reads, and structured queries across sessions, artifacts, implicit knowledge, and code tracking data.

Architecture

nexcore-brain (business logic)
    ↓
nexcore-db (persistence)
    ↓
rusqlite + SQLite (bundled)

Usage

use nexcore_db::pool::DbPool;
use nexcore_db::sessions;

let pool = DbPool::open_default().expect("open db");
pool.with_conn(|conn| {
    let all = sessions::list_all(conn)?;
    println!("Found {} sessions", all.len());
    Ok(())
}).expect("query");