Performance
A shop ledger page, 1899. Every line adds up.
Understanding React Server Components in Next.js 14: A Deep Dive
A comprehensive guide to React Server Components in Next.js 14, exploring the paradigm shift in how we build React applications, with practical examples and performance implications.
10 min read
Blocking the Event Loop: Finding Latency Spikes in Async Python Pipelines
Find and fix blocking calls that stall an asyncio event loop, using debug mode, to_thread and executors, and why asyncio.sleep(0) hides the problem.
4 min read
Reading EXPLAIN ANALYZE When You Are New to PostgreSQL
A beginner-friendly way to read EXPLAIN ANALYZE output: what to look at first, how to compare estimated and actual rows, and what the buffers numbers tell you.
5 min read
The Missing Index on a JOIN: The Beginner Fix for Slow PostgreSQL Queries
PostgreSQL does not index foreign key columns automatically. Learn how to spot the missing index behind a slow JOIN and add it safely with CREATE INDEX CONCURRENTLY.
4 min read
Fixing Slow Serialization of Large Nested Pydantic Responses in FastAPI
An endpoint returns quickly in the database but slowly over HTTP. Profile first, then reduce response_model overhead, validate once, trim payloads, and paginate.
5 min read
Make Next.js Navigation Feel Fast on Slow Networks
Reduce the frozen feeling when clicking links on slow connections by using loading.tsx, Suspense boundaries, prefetching, and pending indicators in the App Router.
4 min read