Skip to content

Type to search titles, headings, and body text.

patterns / sqlite-backed-graph

category:
G-storage
stage:
storage
cost:
low
kit:
core
tools:
Claude Code, OpenCode

sqlite-backed-graph

What it does

Stores nodes and edges as two related SQLite tables joined by foreign keys — a storage shape sized for one team working on one machine, not a distributed system.

Inputs

  • The node and edge schema, expressed as two table definitions.

Outputs

  • A single queryable local database file holding the entire graph.

Failure mode if skipped

A team reaches for a distributed graph database and takes on its operational overhead — backups, networking, a service to keep running — before the scale of the graph ever justified paying that cost.

Kit: starters/sqlite-backed-graph/README.md

Starter kit

Loading the sqlite-backed-graph starter kit…