Scaling WordPress data to 127 million points
A security report built on 127 million data points, and what it took: raw SQL instead of WP_Query, a resumable WP-CLI batch script, and segmentation that finally gave the numbers some contrast.
A security report built on 127 million data points, and what it took: raw SQL instead of WP_Query, a resumable WP-CLI batch script, and segmentation that finally gave the numbers some contrast.
AI writes the query now and I check it. That includes the time an elegant LLM-generated join pushed a production database to 98% CPU, plus the utility I use to export sanitized WooCommerce data for analysis.
The Bits-over-Random Metric compares your retrieval against random chance, which is how you catch the context pollution a high Success@K hides. Notes on staged tool routing and where the collapse regime starts.
The six-month version of this career change is a sales pitch. Coming from a software background it took closer to two years, and the money goes to people who can ship a RAG system that does not leak data, not to people who can write prompts.
A client ran her entire business through WhatsApp until the account was blocked on a Tuesday. What owned digital assets mean in practice, and why Brazil’s first Automattic partner writes WordPress.com into its contracts.
A colleague shipped a custom assistant in a couple of hours by wiring Google Calendar, Microsoft To Do and Notion together. Execution stopped being the bottleneck, and here is a Gemini API scheduler you can start from inside WordPress.
My agent failed the same caching refactor three times before I fixed how I was briefing it. Planning mode, browser access through Playwright MCP, and claude.md files are what turned that into one-shot work.
An agent that is 85% accurate per step is about 20% accurate over ten steps. Lusser’s Law explains why, the Replit database deletion shows what it costs, and a gatekeeper pattern in PHP puts human review in front of the irreversible actions.
Autonomous agents fail in ways that are expensive to clean up. This is how LangGraph interrupts and checkpointers let a person approve a step mid-run, plus the idempotency mistake that made my content agent publish something I never signed off on.
WordPress 7.0 ships the PHP AI Client, and the community has already built connectors for Grok, Mistral, Ollama and OpenRouter. What each one covers, how provider registration works, and the switching case worth testing first.