Comments
This section is the map for the rest of the book. The five stages introduced in the 1.1 chapter overview (parse, analyze/rewrite, plan, portal, execute) are traced here through the actual code: which functions implement each stage, and in what order they get called. The mechanics of each of the five stages are unpacked in later chapters. Here, only the skeleton matters: how a backend starts up, ho
Wabi-Sabi and Whitespace: Eastern Philosophy for Web Design What I learned from studying traditional aesthetics that completely changed how I build interfaces Last year, I spent three weeks in Kyoto. Temples everywhere. One rainy afternoon, I ducked into a small museum dedicated to traditional craftwork. I wasn't expecting much. I'm a web developer, not an art historian. But something clicked. T
PostgreSQL Internals · Chapter 1 Query Processing Suppose a client sends SELECT * FROM users WHERE id = 1. The path that single line travels before coming back as a result row is longer than you might expect. Inside the PostgreSQL backend, that SQL goes through a five-stage pipeline. Backend entry and dispatch. The backend receives the message from the client and decides which processing path it s
Why Figma MCP Isn’t Enough Why Figma MCP Alone Can’t Guarantee Production-Ready UI — and What Product Teams Must Do Instead Extraordinary results require an extraordinary team. I’m surrounded by people who treat design and development like a mission. They are warriors in the tech trenches, and this win belongs to them. No fluff. No filler. Just the facts on how we shattered our veloci
Firefox Extension Icons: Sizes, Formats, and SVG vs PNG The icon is the first thing users see in AMO search results and the add-ons bar. Getting it right matters. For a complete Firefox extension, provide icons at these sizes: { "icons": { "16": "icons/icon-16.png", "32": "icons/icon-32.png", "48": "icons/icon-48.png", "96": "icons/icon-96.png", "128": "icons/icon-128.png"
SQL is widely known for data querying and manipulation but systems do grow; data becomes larger; processes become repetitive and operations become sensitive. SQL has some features which enables it to be considered a fully fledged programming language. Some of the features which I discuss in this article are procedures, functions and transactions. Each of these concepts serve distinct purposes. Sto
Introduction Placing RDS in a private subnet protects it from unauthorized external access — but it also means you can no longer connect directly from your developer machine. This article walks you through a step-by-step guide to securely connect to a private-subnet RDS (PostgreSQL) instance using AWS Client VPN. Developer PC │ │ UDP 443 (TLS / Mutual Certificate Authentication) ▼ Client