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
UUIDs, ULIDs and Sqids: A Practical Deep Dive
A practical deep dive into UUIDs, ULIDs, and Sqids, from generation models and sorting behavior to database storage, public IDs, and security trade-offs. Read more