Session persistence: SQLite+FTS5 conversation store #750

Closed
opened 2026-10-27 13:37:35 +00:00 by sam · 0 comments
Owner

Persistent conversation history with full-text search, backed by NellDB (replaces the original SQLite+FTS5 plan since NellDB is Sam's existing distributed store with built-in vector search).\n\n1. Collections: sessions, messages — namespaced in NellDB.\n2. Vector search: NellDB's SearchSimilar for semantic memory recall (upgrades the original FTS5 text-only search).\n3. Replication: Multi-primary sync via nell.Replicator — two archied instances share conversation state.\n4. HLC ordering: Causal ordering for messages across nodes.\n5. Durable backend: logstore.OpenLog for Zstd-compressed append-only persistence.\n\nNellDB replaces both SQLite+FTS5 (conversation store) and file-based MEMORY.md, using a single dependency.

Acceptance Criteria

Conversation history persists across daemon restarts. FTS5 search returns relevant messages. Compression creates child sessions without data loss.


Imported from beads archie-core-1786637495693-225-bbf3bc3b · GitHub #246 · type feature · priority P2 · created 2026-08-08 · closed 2026-08-08

Persistent conversation history with full-text search, backed by NellDB (replaces the original SQLite+FTS5 plan since NellDB is Sam's existing distributed store with built-in vector search).\n\n1. **Collections**: sessions, messages — namespaced in NellDB.\n2. **Vector search**: NellDB's SearchSimilar for semantic memory recall (upgrades the original FTS5 text-only search).\n3. **Replication**: Multi-primary sync via nell.Replicator — two archied instances share conversation state.\n4. **HLC ordering**: Causal ordering for messages across nodes.\n5. **Durable backend**: logstore.OpenLog for Zstd-compressed append-only persistence.\n\nNellDB replaces both SQLite+FTS5 (conversation store) and file-based MEMORY.md, using a single dependency. ### Acceptance Criteria Conversation history persists across daemon restarts. FTS5 search returns relevant messages. Compression creates child sessions without data loss. --- _Imported from beads `archie-core-1786637495693-225-bbf3bc3b` · GitHub #246 · type feature · priority P2 · created 2026-08-08 · closed 2026-08-08_
sam added the mediumfeature labels 2026-10-27 13:37:35 +00:00
sam self-assigned this 2026-10-27 13:37:35 +00:00
sam closed this issue 2026-10-27 13:37:36 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sam/archie#750