Input Gears — Tech Gadget Store
High-performance mechanical keyboard store featuring Redis caching, instant filtering, and persistent carts.
Executive Summary
The Challenge
Cart state persistence across reloads and database load during traffic spikes with high-variant mechanical keyboard inventory.
The Solution
Next.js 15 App Router, Upstash Redis cache-aside layer for low-latency catalog queries, and Prisma ACID transactions on PostgreSQL.
Measurable Impact
Instant catalog response with Redis caching, persistent Zustand carts without hydration mismatch, and secure Stripe checkout flow.
Technologies
Key Decisions
Why Better-Auth over NextAuth or Clerk?
Better-Auth gave complete database ownership with zero third-party lock-in and seamless Prisma schema integration for multi-role accounts.
Why Upstash Redis for caching?
Serverless Redis handles traffic spikes without database connection exhaustion, keeping catalog reads fast and decoupled from PostgreSQL load.
Why domain-driven module structure?
Separating features (cart, products, checkout) into isolated modules keeps the codebase maintainable as features expand.
Retrospective
Hardest Part
Role-based access control across storefront and admin — getting the middleware logic right for protected routes took significant planning.
Biggest Insight
Redis caching strategy matters more than raw database optimization for read-heavy e-commerce pages.
Do Differently
I would implement optimistic UI updates for the cart actions to make the user experience feel even more instantaneous.
Key Highlights
Multi-Role Admin & Storefront
Role-based views for customers and managers to streamline order processing.
Low-Latency Edge Catalog Caching
Upstash Redis cache-aside layer eliminates database bottlenecks on high-traffic product listings.
Secure Stripe Fulfillment
Idempotent webhook signatures with transaction rollback protection against duplicate orders.
Admin Analytics & Inventory
Live revenue analytics, warehouse stock alerts, and coupon rule management in a unified console.
Next Project
Sneho - Child Care ConnectInterested in discussing this project or exploring collaboration? Let's talk