ALL POSTS
Thoughts, experiments, and documentation.
How We Debugged a 300+ Million Row PostgreSQL Table and Turned a 2 Second Query into a Millisecond Query
How we diagnosed a slow query on a 300M+ row PostgreSQL table, fixed a bad composite index, and rebuilt a backfill that caused a 12-hour WAL contention incident.
How Fun Balls Works: Real-Time Physics, Webcam Blob Detection, and Canvas Rendering in React
Deep technical breakdown of a React physics playground: Matter.js engine, webcam red-blob detection, flood-fill analysis, oriented bounding boxes
OpenRouter Setup in VSCode for AI Development
Learn how to integrate OpenRouter with VSCode to access multiple AI models effortlessly, boosting developer productivity and efficiency.
Automated SEO Blog Creation: New Leafpad Business
Launch an automated SEO blog business with Leafpad's single-prompt integration. Generate optimized content for Loveable, Replit, and coding platforms.
Making Loveable Sites SEO-Friendly with spa-ssr-renderer
Built a simple caching server that makes SPAs crawlable without expensive services. Open-sourced solution for Loveable and any SPA framework SEO optimization.
Random UUID is a performance killed in database
Detailed analysis of UUID primary key performance costs: 3x index bloat, 64% throughput loss. Includes PostgreSQL benchmarks and solutions for production databa
Scaling Smler to 1 Billion Links: How Efficient Architecture Beats Expensive Infrastructure
How I scaled smler, a URL shortener built for TRAI compliance, to handle 1 billion links using just two 2-core servers with PM2 Node.js clustering
Building leafpad: A Purpose Built Blog CMS for Developers
Why I built leafpad.io as a simplified alternative to headless CMS platforms. A single-line integration for blogs that works with AI coding assistants and modern development workflows.