A regular expression stripping card numbers from log lines works until the format changes, and it is applied after the value has already been passed around. Redacting by…
match (true) is a conditional expression, which is the form most people find last and use most. The value over an if-chain is that it is an expression,…
A priority field does not help when the worker is already four minutes into a nightly export. Splitting by latency requirement rather than by importance is the framing…
Two applies against one state file at the same time produce a state that describes neither result, and the backend lock is the only thing that prevents it.…
EXPLAIN shows the plan and the optimiser’s estimates, and the estimates are frequently wrong — a query planned for 40 rows that reads 400,000 looks entirely healthy. The…
A pattern registered against a category that does not exist yet lands silently in uncategorized, which is a tab nobody opens. The priority is load-bearing and there is…
An environment attaches secrets and an approval requirement to a job, which puts the gate in the platform rather than in a convention. Scoping the secrets to the…
Each condition in a meta_query becomes another self-join against a table that is usually the largest in the database. Modelling a filterable attribute as a taxonomy rather than…