Descriptions:
A solo founder behind Yorby — a social media marketing platform that helps businesses find and remix viral content formats — documents the specific engineering decisions that scaled the app from zero to over 10,000 users and $4,000 in monthly revenue within 30 days, after launching with no attention paid to performance optimization.
The first intervention was upgrading the Supabase compute instance from the $20/month micro tier to the $200/month XL tier after hitting hard limits under load. The more technically instructive optimization involved using Claude Code with the Supabase MCP integration to conduct a systematic performance audit: tagging slow pages in the codebase, tracing their PostgreSQL queries, connecting to the live Supabase project via MCP to inspect table schemas and existing indexes, and generating the missing index definitions. The video argues this workflow — letting Claude Code bridge application code and live database state in a single session — collapsed what would typically be a multi-hour manual investigation into a focused, directed process.
The largest overall performance gain came from offloading heavy read operations from PostgreSQL to Redis via Upstash, a serverless Redis provider. The founder also covers application-layer caching strategy and the Zed code editor, which he tested during this optimization cycle. The video closes with a candid discussion of architectural tradeoffs he’s still evaluating — including more aggressive edge caching and CDN configuration — making it a practical retrospective for indie developers building production NextJS and Supabase applications at early growth scale.
📺 Source: Your Average Tech Bro · Published February 17, 2026
🏷️ Format: Workflow Case Study
