Architecture · Supabase product analytics
Supabase product analytics · ingest behind RLS
Supabase product analytics · ingest behind RLS
Architecture diagram: an event client and a seed script cross a key-gated ingest Edge Function and a single shared RLS boundary into Supabase Postgres, where the analytics and experiments schemas feed a per-variant A/B result that a Streamlit dashboard and a plain SQL client both read.
POSTGRES · RLS ON EVERY TABLE
POST · API-KEY
KEY HASH
SERVICE ROLE
SELECT · RLS
ANON · 0 ROWS
INSERT EVENT
ASSIGNMENTS
A/B RESULT
SQL VIEW
IN
Event client
POST · x-api-key
FN
Edge Function · ingest
Deno · SHA-256 key hash
IN
Seed script
service role · 8k users
GATE
RLS boundary
my_orgs() · security definer
EXT
Streamlit dashboard
supabase-py · anon key
EXT
Web SQL · psql
PostgREST · anon key
DB
analytics
events · users · 8 SQL views
DB
experiments
assignments · metrics · variants
A/B
v_results
29.6% vs 40.7% · p 1.7e-10
LEGEND
Input / caller
Backend / function
Security / RLS
External / client
Store / table
Focal / A/B result