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
“They store them in SQLite databases and JSONL files in the user's home directory.”Episode 057 — How Uber Caught 206 Leaked Credentials With an LLM-Powered Security Stack