Uncategorized – Page 245 – Türker Yıldırım

Filtering a WooCommerce catalogue without the meta tables

Deep diveOctober 6, 201516 min read

Five filters over 30,000 variations, and a request that never returns. Replacing EAV meta joins with a denormalised index table kept in sync by product hooks.

Dependency injection works fine without a container

NoteOctober 6, 20152 min read

Dependency injection is passing collaborators in rather than constructing them inside. A container is a tool for assembling those graphs automatically. The two get conflated so thoroughly that…

A mock asserts an interaction; a stub only answers

NoteSeptember 30, 20152 min read

PHPUnit builds both with the same method, which is why the distinction gets lost. A stub exists to let the test proceed — it returns a value. A…

SplFixedArray when the array is large and the shape is known

NoteSeptember 25, 20151 min read

A PHP array is a hash table even when the keys are 0 to n. That flexibility costs memory — roughly three times what a plain C array…

SQL_CALC_FOUND_ROWS is usually slower than a second COUNT

NoteSeptember 25, 20151 min read

SQL_CALC_FOUND_ROWS promises the total row count for free alongside a LIMITed page, in one query. The catch is that it forces MySQL to evaluate every matching row rather…

A covering index answers the query without touching rows

NoteSeptember 24, 20151 min read

An index lookup normally finds a primary key and then goes to the table to fetch the columns you asked for — a second read per row. If…

__invoke turns an object into a callable

NoteSeptember 22, 20152 min read

A class with a single meaningful method usually ends up named after the verb — PriceFormatter::format() — and read as a stutter at every call site. __invoke() lets…

Restructuring an application for Laravel 5

Deep diveSeptember 17, 201510 min read

4.2 to 5.0 is not an upgrade, it is a relocation. Moving an application through it in an order that keeps it booting at every step.

A fail2ban jail for nginx auth, not just SSH

NoteSeptember 15, 20152 min read

fail2ban is installed for SSH and left there, but the same brute force runs against every HTTP login on the box — a WordPress admin, a staging basic-auth…

A .dockerignore matters more than the Dockerfile length

NoteSeptember 14, 20151 min read

Before a build starts, the whole context directory is sent to the daemon. Without a .dockerignore that includes .git, node_modules and every previous build artefact — commonly hundreds…