Skip to content

Type to search titles, headings, and body text.

patterns / postgres-backed-graph

category:
G-storage
stage:
storage
cost:
medium
kit:
extended
tools:
Claude Code

postgres-backed-graph

What it does

Represents the graph as adjacency-list tables inside Postgres, aimed at a team already operating Postgres that needs several writers touching the graph at once with real transaction guarantees.

Inputs

  • The node and edge schema, laid out as relational tables.
  • The concurrent write load the graph needs to support.

Outputs

  • A transactionally consistent graph store, shared safely across multiple concurrent writers.

Failure mode if skipped

Multiple writers touching a file-based graph at the same time corrupt it, with no transaction to roll back to and no lock to have stopped them.

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

Starter kit

Loading the postgres-backed-graph starter kit…