Case Study: We Are Vista — 75 Pages of Care Management on Supabase

We Are Vista is the operating system for EdgeFlow's Vista care brands. It is the largest single application I've worked on: 75+ pages, 85+ custom React hooks, and deep Supabase integration, used every day across multiple UK care organisations.

It spans referral management, a young-people database, finance (invoicing, timesheets, payroll), compliance with document-expiry alerts, safeguarding, safer recruitment, and maintenance. A dual permission system controls access at both the feature level and the role level across every module.

The integration work is where it gets interesting. Multi-table RLS policies scope data correctly per user, pg_net triggers fire n8n webhooks for referral processing and support-ticket routing, Realtime keeps dashboards live, and pgvector powers AI search across case records. The referral intake pipeline uses Claude to pull structured data straight out of emails and PDFs.

It replaced five or more disconnected tools and takes an estimated ten-plus hours of manual admin off each team every week.