Backend Architecture

Architecture of the Supabase / PostgreSQL backend, RPC layer, and workers.

Status: Planned for Phase 2

Backend service topology and database architectures will be documented from SQL migrations in Phase 2.

DATABASE INTEGRITY

INV-AUTHZ

All user data access must be governed strictly by PostgreSQL Row-Level Security (RLS) policies using auth.uid().

Your feedback directly guides the engineering documentation roadmap.

Local Services

Device services including push token capture, local notifications, and storage.

PostgreSQL Database Design

Relational schema design, normalization, indexing strategies, and database constraints.