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. …
Tag
Technology
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 …
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 …
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 …