CHANGELOG.md

Changelog — aimdb-persistence-sqlite

All notable changes to this crate are documented here.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

Unreleased

0.1.0 — 2026-02-21

Added

• SqliteBackend — Clone-able handle to a dedicated SQLite writer thread
  • Construction via SqliteBackend::new(path): opens or creates the database, enables WAL journal mode, applies schema, then spawns the "aimdb-sqlite" OS thread — all synchronously, so no Tokio runtime is needed at build time
  • Clone is O(1): clones only the SyncSender<DbCommand> handle; the writer thread shuts down when all clones are dropped
• Schema — single record_history table with (id, record_name, value_json, stored_at); composite index on (record_name, stored_at DESC) for efficient range and top-N queries
• WAL mode — PRAGMA journal_mode = WAL allows concurrent readers while a single writer proceeds
• DbCommand actor model — Store, Query, Cleanup commands sent via mpsc::sync_channel(64); each carries a tokio::sync::oneshot reply sender so the async caller awaits without blocking the executor
• store(record_name, value, timestamp) — serialises serde_json::Value to text and INSERTs into record_history
• query(pattern, params) — WITH ranked AS (… ROW_NUMBER() OVER (PARTITION BY record_name …)) window-function query supporting:
  • * wildcard patterns (mapped to SQL LIKE … ESCAPE '\\')
  • Optional time-range bounds (start_time, end_time)
  • Optional per-record limit (limit_per_record: None → no truncation)
• cleanup(older_than) — DELETE … WHERE stored_at < ? with row-count return; called by the retention task registered via with_persistence()
• sanitize_pattern helper — escapes SQL LIKE metacharacters (%, _, \) before mapping the AimDB * wildcard to %
• tracing feature — optional tracing::warn! for corrupted JSON rows encountered during query

---