Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Approvals, effects and evidence in one SQLite file (ARCHITECTURE §5).
ctrlrun.SQLiteStateStore — class, defined at src/ctrlrun/state.py:926
from ctrlrun import SQLiteStateStore
class SQLiteStateStore
def __init__(path: str | os.PathLike[str], *, clock: Callable[[], datetime] = _utc_now)
BEGIN IMMEDIATE, which holds the database’s write lock,
and effects.effect_key is a primary key — the UNIQUE(effect_key) constraint — so an
insert that races past the lock still fails rather than overwriting a reservation.
A connection is opened per thread; sqlite3 connections are not shareable. Separate
processes open the same file, which is the point.
Related topics
Move from SQLite to PostgresInMemoryStateStorePostgresStateStoreRunning on PostgresJSONLEventSinkWas this page helpful?