Posts tagged "developer-tools"

You write SQL declaratively, but the database engine decides how to execute it. We open up Postgres EXPLAIN to show how query planners actually choose strategies.

JSON Schema gives you contract-driven validation for any JSON payload. We walk through the spec, the keywords that matter, and how it powers OpenAPI and Zod.

Generating TypeScript interfaces from a JSON sample looks like magic, but it's a careful walk through structural inference. We explain the rules these tools use and when they get it wrong.

LCP, INP, CLS, TTFB — the alphabet soup of web performance. We explain what each metric measures, what passes the bar, and how to actually move your scores up.

Three popular diagram-as-code tools, three different philosophies. We compare syntax, layout engines, output quality, and which one fits your README versus your architecture doc.

Why do some PDF forms work everywhere and others demand Adobe Reader? It comes down to two competing PDF form standards. Here is what each does and why one is dying.

Browsers don't have a Python interpreter. So how do online Python runners work? The answer is WebAssembly and a project called Pyodide. Here's the full story.

Random IDs are everywhere, but the trade-offs differ. We compare collision odds, sortability, length, and database performance for the four most common modern ID schemes.