Articles, guides, and thoughts on web development and technology
When your perfectly indexed query starts performing a sequential scan, the culprit isn't your code—it's a stale histogram in the system catalogs.
Stop polling your database and start streaming it: a technical look at turning the Write-Ahead Log into a high-performance event stream.
A technical deep dive into why your covering indexes fail to prevent heap access and how to tune autovacuum to guarantee zero-I/O queries.
The new source-text access in JSON.parse finally solves the BigInt rounding nightmare without the performance tax of a custom parser.
Stop writing manual type guards for your filter functions; TypeScript 5.5 finally understands your logic as deeply as you do.
Move beyond slow pattern matching and learn how to orchestrate virtual tables, shadow indexes, and BM25 ranking to build a production-grade search engine directly in your database.
Discover how a 40-year-old networking optimization is silently sabotaging the responsiveness of your modern real-time APIs and how a single line of code can fix it.
Transitioning to QUIC isn't always a performance win; learn why network middleboxes and ISP 'UDP policing' might be turning your protocol upgrade into a hidden bottleneck.
Bypassing the structured clone algorithm is the only way to achieve sub-millisecond communication between threads in a high-load JavaScript environment.
Vertical centering no longer requires the Flexbox or Grid tax—discover how a 2024 update to the CSS Box Alignment spec finally killed the web's oldest layout struggle.