docs(architecture): backend architecture record #67

Merged

raisondetredev merged 1 commit from refs/pull/67/head into main

2026-06-26 02:28:51 +02:00

raisondetredev commented

2026-06-26 01:14:28 +02:00

(Migrated from codeberg.org)

Adds docs/architecture.md — the backend architecture: migrations-as-schema + the standard table recipe, the RLS-first model (per-user auth.uid() vs read-only reference tables), RPC safety conventions (SECURITY INVOKER, search_path='', escaping), the Realtime publication, Storage buckets, the three Edge Functions (LanguageTool / Judge0 / link-verify), self-hosting, and the sync contract the app's offline-first engine relies on (server-stamped updated_at, soft deletes, server FKs). README pointer. Docs only.

Part of a 3-repo documentation pass — app project-halkyon/halkyon-learn#692, curator project-halkyon/halkyon-curator#20.

Adds **`docs/architecture.md`** — the backend architecture: migrations-as-schema + the standard table recipe, the **RLS-first** model (per-user `auth.uid()` vs read-only reference tables), **RPC safety conventions** (SECURITY INVOKER, `search_path=''`, escaping), the Realtime publication, **Storage** buckets, the three **Edge Functions** (LanguageTool / Judge0 / link-verify), self-hosting, and the **sync contract** the app's offline-first engine relies on (server-stamped `updated_at`, soft deletes, server FKs). README pointer. Docs only. Part of a 3-repo documentation pass — app project-halkyon/halkyon-learn#692, curator project-halkyon/halkyon-curator#20.