A verified survey platform built for trustworthy research.

Data quality. Free survey tools allow anyone to respond. A dissertation about engineering students at a Ghanaian university can end up answered by bots, click-farms, or strangers from another continent — invalidating the dataset.

Access & cost. Paid panels are unaffordable for many independent and student researchers, while social-media recruiting depends on the researcher's personal network. People with smaller networks systematically get less data.

CampusVerify combines academically verified student accounts with registered General/Researcher accounts for lecturers, NGOs, companies, independent researchers, and community respondents. Student surveys can remain campus-scoped, while wider studies can reach the public audience.

Instead of money, the platform runs on a credit economy: you earn one credit for each quality response you give, and spend credits to publish your own surveys. This aligns incentives — every researcher is also a respondent.

• Frontend: React 19 + TanStack Start (file-based routing, server functions, SSR) on Vite 7, styled with Tailwind CSS v4 and shadcn/ui primitives.
• Backend: Postgres + Supabase Auth for identity. Business logic runs as TanStack server functions secured by an authentication middleware; webhooks live as server routes.
• Data layer: Row-Level Security on every table. A has_role() security-definer function avoids RLS recursion. Triggers protect sensitive columns (credits, user types, survey rules) from direct modification.
• Offline: A service worker caches survey payloads; responses queue in IndexedDB and replay on reconnect.
• Hosting: Edge runtime (Cloudflare Workers) — cold-start free, geographically close to Ghanaian users.

Every table in the public schema has RLS enabled. Roles are stored in a separate user_roles table — never on the profile — and checked via has_role(user_id, role), a SECURITY DEFINER function that prevents privilege-escalation attacks common in naive Supabase apps.

Sensitive columns (a user's credit balance, a survey's published flag, a profile's verification status) cannot be edited via the API even by the row's owner. Database triggers reject any attempt; only internal server logic can update them. A "speed-trap" trigger flags suspiciously fast responses as fraud, while still honouring genuine offline-sync timing.

Realtime broadcasts are restricted to a safe column allow-list so sensitive fields (email hash, flagging metadata, raw identifiers) are never wired to the websocket.

• Migrations as source of truth. Every schema change ships as a numbered SQL migration in supabase/migrations/.
• Type-safe routing. TanStack Router generates route types at build time; broken links fail the build, not production.
• Semantic design tokens. No raw colours in components — every shade is a token defined in src/styles.css, giving consistent light/dark behaviour.
• PWA installable. The app ships a manifest and icons; users can install it to their home screen.

1. Create an account from the home page using any academic email; confirm the verification link.
2. Open the feed — it shows surveys scoped to your campus, with credit rewards and remaining slots.
3. Answer one survey to earn credits and observe the offline indicator (try toggling airplane mode mid-answer).
4. Publish your own survey; spend credits, then open the Analytics view to see live results.
5. Build a report from the analytics page and export the PDF — this is the artefact a researcher would submit.