Struct CoreDb 

pub struct CoreDb { /* private fields */ }

Unified database for sessions, cron, and auth.

Owns a single SqlitePool backed by core.db. Individual stores (SessionManager, CronStore, AuthStore) receive a clone of the pool via from_pool() instead of opening their own connections.

The pool is configured with:

• WAL journal mode — concurrent readers don’t block writers
• Foreign keys ON — referential integrity across all tables
• 2 max connections — one writer + one reader; SQLite serialises writes anyway, so more connections just waste memory (~2 MB page cache each) and cause lock contention on small VMs
• busy_timeout = 5000 — wait up to 5 s for a lock instead of returning SQLITE_BUSY immediately
• synchronous = NORMAL — safe with WAL, avoids fsync per commit
• cache_size = -2000 — 2 MB page cache per connection (default)

Implementations

impl CoreDb

pub async fn new(db_dir: &Path) -> Result<Self>

Open (or create) core.db inside db_dir.

Runs all migrations from ./migrations. If migrations fail due to a checksum mismatch or a removed migration (common during development when migration files are edited in-place), the database is deleted and recreated from scratch.

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

Create an in-memory CoreDb for testing.

Runs all migrations on a shared in-memory database. Each call returns a fresh, empty database.

pub fn pool(&self) -> &SqlitePool

Get a reference to the shared connection pool.