sqlite

Overview ¶

Package sqlite is the embedded, single-node docstore.Store backed by SQLite (modernc.org/sqlite, pure Go, driver name "sqlite").

Documents live in one table:

docs(site, collection, id, data JSON text, created_at, updated_at,
     created_by, updated_by, version, PRIMARY KEY (site, collection, id))

with timestamps stored as sortable integers (unix nanoseconds, always whole microseconds) and an index on (site, collection, created_at, id) for the default listing order. Filters, ordering and pagination are pushed into SQL using json_extract/json_type so that the type-strict semantics of SPEC §5.2 hold exactly (see query.go).

The database runs in WAL mode. Writes go through a dedicated single connection (SQLite allows one writer at a time; serialising in-process avoids SQLITE_BUSY churn) using BEGIN IMMEDIATE transactions, while reads use a separate read-only pool and proceed concurrently. busy_timeout covers other processes sharing the file.