Definition
Plain language
A lightweight database that lives in a single file, used inside many apps to store data locally.
As stated in the literature
A self-contained, serverless, file-based relational database engine; the format agentic coding IDEs use to cache local session histories that ADR's endpoint sensor parses.
Why it matters: Its simple, single-file design lets apps store and query data locally without running a separate database server.
For example, a phone app might keep all your notes in a single SQLite file on the device instead of on a remote server.
Heard on the show
“On Terminal-Bench v-two, the harder command-line benchmark with stuff like "recover this corrupted SQLite file," the same model goes from forty-seven to fifty-nine.”Episode 003 — How to Pick the Best of Sixteen Coding Agent Rollouts