Community Connect

Civic Engagement Platform with Firebase Auth & Supabase RLS

GitHub Repositorycode

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 (road repairs, garbage management) directly to local representatives with transparent status tracking.

architecture

2. TECHNICAL APPROACH & DECISIONS

1Firebase Auth + Supabase RLS Bridge

✓ DECISION CHOSEN

Used Firebase Auth for seamless phone/OTP user authentication, then passed JWT tokens into Supabase PostgreSQL Row Level Security (RLS) policies.

✕ REJECTED ALTERNATIVE

Custom authentication server

Leveraged Firebase's battle-tested phone authentication while taking advantage of 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 maximum 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 (Mobile) & React (Web)Clients

Explore Project Sources

Review live deployment or inspect codebase on GitHub.

View Sourcecode

west

PREVIOUS CASE STUDYMessyData

NEXT CASE STUDYHirenix

east