technology
Introduction
Answers ready before you ask: one small language keeps counts, percentiles, candles, invoices and log dashboards current in a SQLite file as the data arrives. …
Posts
technology
How It Works
The idea. Decide the questions first. Keep their answers current as each event arrives, in one SQLite file, and let raw detail fade on a schedule while unusual events …
technology
The Policy Language
A policy is a short text file. It names the streams of events you have and the answers to keep ready, and says how long each level of detail survives. The compiler turns …
case studies
API Latency Case Study: A Million Requests Kept as Ready Answers Inside SQLite
A small web service that already keeps its data in SQLite wants the usual answers about its API: how many requests each endpoint gets, how long they take on average, and …
case studies
Market Data Case Study: Four Million Trades Turned Into Candles, Checked After a Pulled Plug
A stock chart is made of candles: for each minute, the first price, the highest, the lowest and the last, with the volume traded. A candle is a window summary, the same …
case studies
AI Usage Billing Case Study: A Month of Invoices That Match a Recount to the Billionth of a Dollar
An AI product that bills by the token has to count every request exactly once, even when the network does not cooperate. Clients retry, and a retry can arrive through a …
case studies
Web Shop Logs Case Study: A Dashboard Sent Upstream in 120 Times Fewer Bytes
A web shop sends its logs to a log platform so a dashboard can show requests, latency, errors, payments and revenue, and so someone can search the lines when things go …
technology
Inside the Engine: Same Answers, 12 to 17 Times Faster
The SQL runtime does all its work inside SQLite: every insert runs a trigger that updates every summary, sketch and answer the policy asks for. That is simple and it runs …
next applications
Next Applications: Eight Places Where Answers Kept Ready Could Fit
The four case studies share one pattern. The questions are known in advance and the events arrive as a stream, so the answers can be kept current as each event lands, …
technology
One File: The SQLite Layout Both Runtimes Write
A Precomputing file is an ordinary SQLite file. Any SQLite tool opens it, the same SQL works on it whichever runtime wrote it, and it carries its own policy, so a reader …