// notes from production

Engineering guides: Next.js, React, Node.js and PostgreSQL

Practical write-ups on the problems that come up again and again in real web products — slow pages, sites that don't rank, memory leaks, tangled state and slow queries. Each one is written to be worked through, not skimmed.

A Poker Night, a Car Dealer, a Restaurant and a Clinic: Four Small Builds That Started With a Problem

A poker night with no chips, a used-car dealer, restaurant tables and a busy clinic: four small custom software builds, and what they teach small businesses.

· 9 min read

How to Fix Core Web Vitals in Next.js (App Router)

A practical guide to fixing LCP, INP and CLS in a Next.js App Router site — how to measure with field data, find the real cause, and ship the fix.

· 11 min read

Next.js App Router SEO: A Complete Checklist

What decides whether a Next.js App Router site ranks: rendering, the Metadata API and its merge gotcha, sitemaps, canonicals, structured data and 404s.

· 12 min read

How to Optimize PostgreSQL Query Performance

Find slow PostgreSQL queries with pg_stat_statements, read EXPLAIN ANALYZE output, choose the right index, and fix N+1 queries, OFFSET pagination and bloat.

· 12 min read

React State Management Best Practices (2026)

Most React state problems come from putting state in the wrong place. Sort it into server, URL, form, local and global state, and the library choice gets easy.

· 10 min read

Node.js Memory Leak Debugging: A Practical Guide

How to confirm a Node.js memory leak, capture heap snapshots safely, read them with the three-snapshot technique, and fix the usual causes.

· 12 min read