SQLite

Write Database (SQLite)

SQLite row writer. Accepts any record { $ns: $ts... } and INSERTs one row per tick into a configured table, auto-creating schema from field names when enabled. Non-atomic values serialise as JSON TEXT or drop the row. Pair with a SQLite reader to serve the rows.

Serve SQLite Database

Exposes a local SQLite table as a paginated, read-only HTTP JSON endpoint via serve_sqlite_database. A GET returns recent rows newest-first with offset, limit and time-window parameters; an optional bearer token guards data requests.