Skip to main content

SQLite

Overview​

SQLite is a serverless, embedded SQL database stored in a single file—ideal for mobile apps, browser storage (via WASM), local tools, and low-traffic web stacks (sometimes with write limitations). It implements most of SQL with ACID transactions per connection discipline.

Key concepts​

  • Single writer — One writer at a time; many readers otherwise.
  • File format — Portable .sqlite database file.
  • Types — Dynamic typing with affinity rules.
  • WAL mode — Write-ahead logging for concurrency/performance.
  • When not to use — High write concurrency across many clients—consider client/server DB.

App ↔ SQLite​

Sample: CLI session​

.open local.db
CREATE TABLE notes (
  id INTEGER PRIMARY KEY,
  body TEXT NOT NULL
);
INSERT INTO notes (body) VALUES ('buy milk');
SELECT * FROM notes;

References​