Spiral Sounds
Overview
Full-stack Progressive Web App for vinyl record enthusiasts. RESTful Express.js API with JWT authentication, role-based access control, SQLite database with migrations, real-time WebSocket updates, debounced search, persistent cart, wishlist, and A+ security rating. 95%+ test coverage with Jest.
Challenge
Building a production-grade e-commerce PWA without a modern framework — proving full-stack fundamentals with vanilla JS, a custom Express API, and raw SQL.
Solution
REST API with JWT auth, role-based access control, SQLite migrations, and relationship modelling (users, products, reviews, wishlists, cart items). Real-time WebSocket integration for live analytics. 300ms debounced search. PWA with app shortcuts and offline support.
Impact
95%+ Jest test coverage. A+ security rating. PWA works offline and installable. Real-time WebSocket updates deliver live inventory changes without polling.