Discover with context
Editorial catalog browsing, establishment details, reviews, and map-aware location information make recommendations easier to evaluate.
Community product
Kwentong Kusina
A warm, community-driven food discovery product built around trustworthy local recommendations.
Role
Frontend engineering, Supabase/Postgres design, authorization, moderation workflows, testing, and protected deployment.
Built with
React · Vite · Supabase · PostgreSQL · Row Level Security · Vercel
The brief
Why it exists.
Local food discovery is richer when recommendations, places, and community context are approachable and responsibly curated.
- For
- People looking for places to eat, contributors sharing knowledge, and moderators maintaining useful catalog information.
- The outcome
- A responsive food-review experience where people discover establishments, share reviews, propose details, and participate in moderated location data.
Product experience
What it helps people do.
Community contributions
Verified users can propose catalog and location changes, vote on candidates, and see typed revision information instead of opaque records.
Operational moderation
Administrators and helpers have focused moderation responsibilities, while read-only demo roles make the product easier to explore safely.
Screenshot 1 / 2 Editorial food discovery
Engineering notes
Decisions beneath the surface.
Database-enforced authorization
Problem
Hiding UI controls does not protect reviews, proposals, roles, or stored media from direct requests.
Approach
PostgreSQL functions and Row Level Security enforce ownership, moderation, lifecycle, and storage permissions at the data boundary.
Moderation without erasing the story
Problem
Community content needs correction and review while retaining accountable decisions and revisions.
Approach
Proposal threads, decision reasons, typed field revisions, and controlled visibility preserve useful history for moderators and contributors.
Location contributions that stay credible
Problem
Places need flexible community input without immediately turning every suggestion into the official location.
Approach
Candidate suggestions, voting, and moderator selection separate community signal from the official pin.
Architecture
Small diagram, clear boundaries.
01
Visitors & contributors
02
React product interface
03
Supabase Auth & Edge Functions
04
PostgreSQL RLS & storage
Quality
- Frontend unit coverage
- Postgres policy and function tests
- Protected main branch quality gate
- Production deployment smoke checks
Security & trust
- Postgres RLS policies
- Role and lifecycle enforcement
- Turnstile-protected access path
- Soft deletion preserves auditability
Live application
See the product in context.
Embedding depends on the project host's security policy. The external site remains the reliable preview.
Live preview unavailable in embedded mode.
Open live application