Writing to a modern database may feel instantaneous, but the engine shoves compaction, indexing, and replication into background jobs. That trade‑off boosts latency for the next write burst and can surprise operators when resource limits are hit. Understanding this shift helps you tune throughput and avoid hidden performance cliffs.
The post shows how starting with project constraints, static content with pinpoint interactivity, lets you avoid heavyweight SPA frameworks and ship near‑zero JavaScript. By using tools like Astro’s islands of interactivity, you cut bundle size, boost performance and keep the codebase lean.
They moved oversell protection from Redis to MySQL using per‑unit rows and SKIP LOCKED, achieving required throughput during Black Friday 2025's $5.1 M/min sales, while improving consistency. The shift shows MySQL can handle high‑contention inventory workloads, challenging the “use a cache” dogma.
An old CMF Phone 1 now runs Surf, a finance tracker, screen‑sharing and several web apps, surviving reboots and network switches. Its 8‑core ARM CPU, 8 GB RAM, Wi‑Fi 6 and built‑in battery replace a small Hetzner VPS, and the author shares what hardware tricks work and which Linux‑flashing attempts fail.