Problem
Diagnosed a Supabase Cached-Egress overage to root cause: crawler traffic x image variants x cold caches, with no CDN in front of storage.
Decisions
Remediated across the stack — image thumbnails, next/image tuning, video re-encoding, payload/DTO trimming, DB query consolidation (N count-queries collapsed into one RPC), and a CDN architecture plan. Also built the product's multi-party 'white-label' order flow (a distributor buys on credit; a different end-customer receives it and sees a fully white-labeled tracking page — no brand, no price), GitHub Actions CI/CD coordinating backend + web + web-admin deploys, a native Android APK build with a custom in-app self-updater distributed via Supabase Storage, service-key/RLS and price-integrity security audits, and a 1,600+ test backend suite plus Playwright E2E.
Outcome
A production e-commerce platform running live for real users on a single DigitalOcean droplet — designed, built, and operated solo, with the egress overage remediated and a coordinated multi-app release pipeline in place.