MIGUEL
PILAPIL.

Problem

Local government units in the Philippines still track resident records, complaints, and document requests on paper or in scattered spreadsheets. Residents have no way to check the status of their submitted requests.

Build

Residents submit requests and get a tracking number to check status (submitted → under review → approved → ready to claim). Admin dashboard lets barangay staff review, approve/reject, and manage all records. Replaces manual logbooks with a single system.

Decision

Used Prisma over raw SQL to keep schema migrations type-safe as the data model changed across development — barangay record structures kept shifting as requirements came in. Kept the resident flow to four steps as a deliberate constraint, not a limitation.

Result

Live demo at brgyorg-ph.vercel.app · GitHub at github.com/sainttlaurel. Concept project, built solo from schema to deployment.

Problem

Independent car dealers need an affordable way to list inventory, track sales, and manage customer relationships without expensive dealership software.

Build

Full-stack car trading platform with vehicle listings, sales tracking dashboards, and a customer relationship module — replacing manual spreadsheet tracking for each dealer.

Decision

Used PostgreSQL for relational inventory data across dealers, vehicles, and transactions instead of a document DB — the relational model better represents the actual business logic of car trading, where every vehicle is linked to a dealer, sale, and customer history.

Result

Live at sacredgarage.vercel.app. Built solo — frontend, backend API, and database schema. Inventory updates reflect immediately across the platform.

Problem

Event photobooths need a fast, no-login way for guests to capture and share photos without staff intervention. Traditional setups require a dedicated operator and expensive hardware.

Build

Browser-based photo capture with filters, a gallery view, and shareable sessions — no app install required. Guests scan a QR code and start shooting.

Decision

Built anonymous, session-based access instead of requiring accounts — guests at an event won't sign up for anything, so removing that friction was the actual product requirement.

Result

Live at cli-studiodev.vercel.app · GitHub at github.com/sainttlaurel (part of active client project, repo available on request).