FieldProof
Offline-capable field inspection workflowFlutter · Supabase / Postgres · Next.js · GitHub Actions
A field inspection system built end to end: a Flutter app where inspectors record findings on sites with no signal, a Supabase/Postgres backend, and a Next.js review console where the office reads submitted work.
Ownership, the read-only office view and the freeze on submitted work are enforced by row-level policy in Postgres rather than by the client, so removing the app's own gate leaks nothing. Offline drafts sync through an upsert on a device-generated key, so a retry cannot create a second row.
Verified: 279 Flutter tests and 41 admin tests green in CI; 183 pgTAP assertions covering silent authorization denials, run three times per CI pass; a 38-test smoke against the real hosted project through real Auth, RLS and Storage; a downloadable Android build with its sha256 published; and the offline workflow walked on two Android devices.