The final part of Oh Dear’s series on SQL performance. Mattias introduces phpunit-query-count-assertions, a package that catches N+1 queries, duplicate queries, and missing indexes in your test suite. Since implementing this at Oh Dear, they’ve eliminated 15% of their SELECT queries.
PHP
Build an Agent-Friendly CLI Tool in PHP and Run It Anywhere With CPX
This tutorial shows how to build a PHP CLI tool that returns JSON, package it for Composer, and run it from anywhere with CPX. It also explains why CPX is a nicer alternative to globally Read more…