SQLite-backed implementation of MemoryStore.
Provides persistent storage for memories using SQLite database. Supports full-text search via SQLite FTS5 extension.
Thread Safety: This implementation is NOT thread-safe. For concurrent access, use connection pooling or synchronization.
Writes: store and storeAll are each one transaction - a batch is stored whole or not at all - and so are deleteMatching and opening the store. A write takes the database's write lock when it begins, waiting up to the connection's busy timeout (sqlite-jdbc's default, 3 seconds) for a writer on another connection to the same file.
Value parameters
- config
-
Store configuration
- dbPath
-
Path to SQLite database file (use ":memory:" for in-memory)
Attributes
- Companion
- object
- Graph
-
- Supertypes
Members list
Value members
Concrete methods
The outcome recorded for key, if it was applied; fenced like every operation.
The outcome recorded for key, if it was applied; fenced like every operation.
Attributes
- Definition Classes
How many applied keys the store holds.
In one transaction: for a key already applied, its recorded outcome, writing nothing - even if the memories it stored have since been deleted. Otherwise stores add, deletes remove, then evicts beyond bounds (MemoryBounds.overflow, over the whole store), and records (key, outcome).
In one transaction: for a key already applied, its recorded outcome, writing nothing - even if the memories it stored have since been deleted. Otherwise stores add, deletes remove, then evicts beyond bounds (MemoryBounds.overflow, over the whole store), and records (key, outcome).
remove names what add replaces, as a consolidation's summary replaces its sources: if any memory of remove is no longer there, another writer replaced it first, so nothing is written and the outcome records that nothing was added or removed. Two writers that replace the same memories therefore never both store a replacement.
Attributes
- Definition Classes
Clear all memories from the store.
Clear all memories from the store.
Attributes
- Returns
-
Empty store or error
- Definition Classes
Close the database connection. Should be called when the store is no longer needed.
Close the database connection. Should be called when the store is no longer needed.
Attributes
Count memories matching a filter.
Count memories matching a filter.
Value parameters
- filter
-
Criteria for counting memories
Attributes
- Returns
-
Count or error
- Definition Classes
Delete a memory by its ID.
Delete a memory by its ID.
Value parameters
- id
-
The memory identifier
Attributes
- Returns
-
Updated store or error
- Definition Classes
Delete all memories matching a filter.
Delete all memories matching a filter.
Value parameters
- filter
-
Criteria for selecting memories to delete
Attributes
- Returns
-
Updated store or error
- Definition Classes
Removes key's record; fenced like every operation. A key that is not there is Right.
Removes key's record; fenced like every operation. A key that is not there is Right.
Attributes
- Definition Classes
Retrieve a memory by its ID.
Retrieve a memory by its ID.
Value parameters
- id
-
The memory identifier
Attributes
- Returns
-
The memory if found, or error
- Definition Classes
Recall memories matching a filter.
Recall memories matching a filter.
This is the primary retrieval method for most use cases. Returns memories sorted by relevance (most relevant first).
Value parameters
- filter
-
Criteria for filtering memories
- limit
-
Maximum number of memories to return
Attributes
- Returns
-
Matching memories sorted by relevance (most relevant first), or error
- Definition Classes
Get the most recent memories.
Get the most recent memories.
Value parameters
- filter
-
Additional filter criteria
- limit
-
Maximum number of memories
Attributes
- Returns
-
Most recent memories
- Definition Classes
Stores add, then deletes remove, in one transaction.
Semantic search for memories similar to a query.
Semantic search for memories similar to a query.
This method uses embeddings for semantic similarity search. Falls back to keyword search if embeddings are not available.
Value parameters
- filter
-
Additional filter criteria
- query
-
The search query
- topK
-
Number of results to return
Attributes
- Returns
-
A list of ScoredMemory objects, sorted by relevance score (highest first), or error
- Definition Classes
Store a new memory.
Store a new memory.
Value parameters
- memory
-
The memory to store
Attributes
- Returns
-
Updated store or error
- Definition Classes
Store memories in one transaction: all of them are stored or, if any fails, none is. The commit - and the file sync behind it - is paid once for the batch, not once per row.
Store memories in one transaction: all of them are stored or, if any fails, none is. The commit - and the file sync behind it - is paid once for the batch, not once per row.
Attributes
- Definition Classes
Update a memory.
Update a memory.
Value parameters
- id
-
The memory identifier
- update
-
Function to transform the memory
Attributes
- Returns
-
Updated store or error
- Definition Classes
Inherited methods
Check if a memory exists.
Check if a memory exists.
Value parameters
- id
-
The memory identifier
Attributes
- Returns
-
True if memory exists
- Inherited from:
- MemoryStore
Get conversation history.
Get conversation history.
Value parameters
- conversationId
-
The conversation identifier
- limit
-
Maximum messages to return
Attributes
- Returns
-
Conversation memories in chronological order
- Inherited from:
- MemoryStore
Get all memories for a specific entity.
Get all memories for a specific entity.
Value parameters
- entityId
-
The entity identifier
Attributes
- Returns
-
All memories related to this entity
- Inherited from:
- MemoryStore
Get high-importance memories.
Get high-importance memories.
Value parameters
- limit
-
Maximum number of memories
- threshold
-
Minimum importance score (0.0 to 1.0)
Attributes
- Returns
-
Important memories
- Inherited from:
- MemoryStore