All projects · Supabase Full-Stack Apps
BuildPro — Case Study Manager
A single-file, no-auth full-stack demo of a case-study/portfolio manager for a web agency.
A single-file, no-auth full-stack demo of a case-study/portfolio manager for a web agency. It pairs a light public 'Our Work' marketing site (featured projects + service-filtered case-study grid) with a dark admin dashboard (stats, searchable table, SVG donut chart, recent-activity feed, and an add/edit modal with image upload) backed by Supabase, falling back to bundled mock data when no keys are configured.
- Two-surface single-file app: public marketing site + dark admin dashboard toggled via a hash router (#public/#admin) with a floating switch button
- Three-state content model (Draft private / Published public / Featured highlighted) enforced in the public query so only polished 'proof assets' surface
- Live-computed admin analytics: stat cards, a hand-drawn SVG donut chart of status distribution, and a recent-activity feed
- Image upload to a Supabase Storage bucket (getPublicUrl) plus a full SQL schema with RLS policies; graceful 'Demo mode' mock fallback when Supabase keys are absent
Built with: HTML, CSS, JavaScript, Supabase (Postgres + Storage), supabase-js v2 (CDN), PostgreSQL / SQL (RLS policies, storage buckets), Plus Jakarta Sans (Google Fonts), hash-based view routing, inline SVG