News
Go's sql. Null[T] Will Never Get JSON Support. Here's What We Built Instead.
5+ hour, 53+ min ago (271+ words) Go 1. 22 gave us sql. Null[T] " a generic nullable type for SQL. Problem solved? No. Try marshaling it to JSON: That's not "Alice". That's not null. That's a broken API response. This is a permanent gap in Go's standard library....
The Postgre SQL Guide to Partial Indexes on Soft Deletes
2+ hour, 31+ min ago (34+ words) If every hot query ignores deleted rows, stop paying to index them. Soft deletes feel cheap right up until your busiest query starts with WHERE "...
What `os. cpu_count()` Gets Wrong in a CPU-Limited Kubernetes Pod
1+ week, 2+ day ago (1219+ words) This article is originally published on my personal blog. I gave a pod 500m CPU and then went inside and asked Python how many CPUs it could see. The answer was 20, and that seemed worth understanding. I start by checking what…...
Database Indexing and Query Optimization for Python Developers
9+ hour, 36+ min ago (611+ words) Fixing N+1 queries with select_related/prefetch_related or selectinload (see the previous post) gets you down to a small, sane number of queries per request. The next bottleneck is what each query costs once the table has millions of rows " and that is…...
Database Indexing and Query Optimization for Java Developers
9+ hour, 36+ min ago (668+ words) Fixing N+1 queries (see the previous post) gets your Hibernate app down to a handful of queries per request. The next bottleneck is what each of those queries costs once your tables have millions of rows " and that is almost…...
Why I Ditched Context API for Redux.
7+ hour, 23+ min ago (162+ words) When you first start building multi-component apps in React, you quickly hit a frustrating wall: prop drilling. Passing data down through five layers of "...
I Built a Safer HTTP Client in Go After Too Many Timeouts
8+ hour, 14+ min ago (20+ words) The timeout problems looked random at first, until I realized my Go service was calling other services without enough discipline....
Is Your Unity Game's Physics a Hidden Bottleneck?
12+ hour, 32+ min ago (1021+ words) Unlock CPU Power with Jobs and Burst Introduction It's 2026, and player expectations for high-fidelity, responsive game worlds have never been higher. Yet, for many Unity developers, the pursuit of complex physics, intricate AI, or large-scale simulations often runs headlong into…...
How V8 Optimizes Your Java Script
8+ hour, 59+ min ago (33+ words) If you started writing Java Script a decade ago, you probably remember it being the butt of performance jokes. It was slow, interpreted, and relied on browser hacks to "...
How I got LCP under 2s on a 38-page Blazor Web Assembly site (Cloudflare Pages)
13+ hour, 57+ min ago (1291+ words) I run Smart Tax Calc. in " a free Indian tax calculator platform built as a Blazor Web Assembly SPA on Cloudflare Pages. 38 tools, 20+ blog articles, all client-side. Very static, very cheap to host, easy to iterate. For the first several…...