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. …
Alpha: four live demos
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. A question becomes a lookup, and old detail fades on a schedule you set.
7.9 times
Smaller file for three hours of API traffic kept as ready answers, every p99 within 0.65%
100 kills
The Engine stopped without warning while it takes in a trading day, with no acknowledged trade lost
$5,804.56
A month of AI usage invoiced, equal to a separate recount to the billionth of a dollar
120 times
Fewer bytes sent upstream for a log dashboard, every point checked against the raw lines
Measured on the 0.1 code with simulated data, in September 2026. Each demo repeats its checks in your browser.
Articles and case studies
All 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, …
Get in touch
Teams who would like to try Precomputing on their own data, and anyone with a question or a use the project should look at, are welcome to write.