Designed and built a self-hosted household management web application from scratch as a full-stack solo project, serving as a multi-family platform to replace commercial solutions like Grocy
Implemented multi-household support with password/PIN protection, role-based permissions (admin/moderator hierarchies), and data isolation between families sharing the same installation
Built five integrated modules: inventory tracking with barcode scanning, recipe management, meal planning, chore assignment with a points/rewards system, and a household calendar
Developed a RESTful PHP API with prepared statements, proper foreign key relationships, and comprehensive error handling across all endpoints
Implemented PWA functionality including service workers with network-first caching strategy, offline support, push notifications with per-item timing controls, and installable app experience
Created a user authentication system with browser fingerprinting, username/password login, user registration, and JSON array-based permission structures stored in MySQL
Integrated barcode scanning for inventory management using the HTML5-QRCode library, enabling quick product lookup and stock updates
Connected recipe ingredients bidirectionally with the inventory system and linked the meal planner to recipes for seamless cross-module data flow
Engineered a data migration system to transition users from localStorage to MySQL backend without data loss
Deployed on a Ubuntu VPS with nginx, with full UTF-8/emoji support, responsive mobile-first design, and cross-browser compatibility
