arrow_backBack to All Projects
MobileFull-Stack
PROJECT CASE STUDY // TECHNICAL NARRATIVE
Community Connect
Civic Engagement Platform with Firebase Auth & Supabase RLS
YOUR ROLE & SCOPEFull-Stack Developer
TIMELINE4 Weeks
CORE CONSTRAINTSMulti-platform support (Android + Web) with strict row-level security for citizen grievance reports.
error_outline
1. THE PROBLEM
Citizens struggle to report ward-level civic issues directly to local representatives with transparent status tracking.
architecture
2. TECHNICAL APPROACH & DECISIONS
1Firebase Auth + Supabase RLS Bridge
✓ DECISION CHOSEN
Used Firebase Auth for OTP user authentication, then passed JWT tokens into Supabase PostgreSQL Row Level Security (RLS) policies.
✕ REJECTED ALTERNATIVE
Custom authentication server
Leveraged Firebase's phone auth while utilizing Supabase's declarative SQL authorization rules.
balance
3. TRADE-OFFS & HONEST REFLECTION
Dual-backend integration required syncing JWT tokens between Firebase and Supabase, but provided robust security for citizen reports.
task_alt
4. CONCRETE OUTCOME & METRICS
Shipped a cross-platform civic app allowing citizens to pin geographic issue reports and track resolution progress.
PostgreSQL Row Level SecuritySecurity
Flutter & ReactClients
Explore Project Sources
Review live deployment or inspect codebase on GitHub.