Opening project dossier…
Opening project dossier…
A serialized inventory and order system for a sneaker reseller selling over Facebook Live and a walk-in counter.
The business sells imported pairs during Facebook Live streams to an audience of more than 100,000 followers. Verbal claims and flooded inboxes made double-selling and untracked stock a constant risk.
The system tracks each individual pair from supplier intake through reservation, verified payment, and delivery.
Guaranteeing a single pair is never sold twice while hundreds of viewers claim at once, on a database without real row locks.
Laravel 13 MVC with a deliberately thick service layer (orders, payments, reporting, audit) behind thin controllers. Blade, Tailwind 4, and Alpine.js on the front end. Developed on SQLite, deployed on Render with Docker and managed PostgreSQL.
Row locks are no-ops on SQLite, which is why claiming relies on a single conditional UPDATE rather than locking.
There is intentionally no unique index on order items per pair, because a cancelled pair may be sold again.
Built with a three-person team for the College of Computing Education; Christian led IT.
Free-tier host; may take a moment to wake
Status source: Production deployment with a live demo and 96 feature tests.
Project references: shoeboy README · christianlascuna.dev
Let’s talk about your web, mobile or desktop app, automation, AI, QA, or CRM project.
Discuss your project