Pragmatic software engineering notes on web telemetry, search indexation, SQL internals, and QA automation. Written by Chris since 2010.
How Measurement Protocol referral spam polluted client-side analytics across the open web, why Ghost Referrers broke attribution for independent publishers, and why raw server edge logs and direct search index verification remain the only ground truth.
Read full article →A systems-level look at how search engine schedulers prioritize crawl queues, why thin render trees get dropped after initial fetch, and how engineering teams audit real-time URL indexation status without triggering rate limits.
Read full article →Why flaky end-to-end authentication tests stall deployment pipelines, and how catch-all disposable test inboxes, webhook inspectors, and Model Context Protocol (MCP) endpoints let coding agents verify signup flows in milliseconds.
Read full article →
Benchmarking LEFT JOIN ... WHERE IS NULL against NOT EXISTS and NOT IN subqueries across millions of rows in InnoDB, and how nullable foreign keys silently break naive anti-joins.