Store your app's events in Supabase

import hmac
from collections import Counter
from datetime import datetime, timedelta, timezone
from clickruntime import on_event, on_trigger, credentials, http, notify

SUPABASE_URL = "https://your-project.supabase.co"

def sb_headers(**extra):
    key = credentials.secret("SUPABASE_SECRET_KEY")
    return {"apikey": key, "Authorization": f"Bearer {key}", **extra}

@on_event
def handle(event):
    if not hmac.compare_digest(event.header("x-webhook-token") or "", credentials.secret("WEBHOOK_TOKEN")):
        return {"ok": False}
    body = event.json or {}
    row = {"type": body.get("type", "unknown"), "payload": body, "event_id": event.event_id}
    http.post(f"{SUPABASE_URL}/rest/v1/events", json=row, headers=sb_headers(Prefer="return=minimal")).raise_for_status()
    return {"ok": True}

@on_trigger
def weekly(event):
    since = (datetime.now(timezone.utc) - timedelta(days=7)).isoformat()
    rows = http.get(f"{SUPABASE_URL}/rest/v1/events", params={"select": "type", "created_at": f"gte.{since}"},
                    headers=sb_headers()).json()
    counts = Counter(r["type"] for r in rows)
    notify.email_me(f"{len(rows)} events last week", "\n".join(f"{t}: {n}" for t, n in counts.most_common()))
    return dict(counts)