Data Ops

Snapshot studio

Quick reference for the three snapshot sources and their readiness before flipping NEXT_PUBLIC_PHASE0_SOURCE.

  • Know which source (seed, Supabase, Convex) is ready or blocked
  • Tie snapshot work back to the Phase 0 checklist and dual-write plan
  • Track next actions for each source (SQL regen, validations, CLI import)
DocsPhase 0 deployDocsClaude plan

Seed (local)

ready

Current default; backed by `store.ts` + `seed.ts`. Provides deterministic snapshot used in dev/offline.

Next actions

  • Refactor to use preset factories
  • Add smoke tests around joins
  • Document overrides

Supabase

in-progress

Reads `phase0_nodes` + `phase0_discussion_posts`, remaps UUIDs → slugs. RLS enforces owner_id.

Next actions

  • Finish seed SQL regeneration workflow
  • Add live validations against facet matrix
  • Expose CLI to import snapshot

Convex

planned

Query `phase0:loadSnapshot` (Convex HTTP). Holds same node/discussion shape as Supabase.

Next actions

  • Implement loader query + builder
  • Add mutations for writes (pins, bookmarks)
  • Decide on event-sourcing story