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.
Typical backends
Run the read-only HTTP query API over a populated SQLite table.
Caveats
- I/O contractThis component has no pipeline inputs or outputs; it serves an HTTP endpoint over a SQLite file that some other process populates, returning all columns of each row ordered newest-first with no projection.
- Hard constraintThe database is opened read-only, so the file must already exist and be populated out-of-band; the endpoint never writes, creates or migrates the table.
- Parameter interactionA request limit above
max_limit is silently clamped, and a request with no limit uses default_limit; the time-window parameters filter on a received-timestamp column when present.
- State lifetime
db_path, table and the bearer token are fixed at deploy time and require a redeploy to change, while the limits and busy timeout can be adjusted at runtime.
- CompatibilityResponses set permissive cross-origin headers and the health check is unauthenticated even when a bearer token is set, so place sensitive deployments behind an additional access gate.
- Hard constraintThe table name must be a plain alphanumeric identifier; an unusual name fails validation at startup.