LIMIT 50 OFFSET 45000 reads forty-five thousand rows and discards them, which is fine until somebody paginates to the end. The row-value comparison is the part that trips…
A list component that takes items and a key, where the key must be a property of the item, was previously untypeable in a single-file component. The generic…
A message shape is a contract with every consumer that exists and every consumer that is mid-deploy. Adding an optional field is safe because an old consumer ignores…
An encrypted backup is a backup you cannot restore unless the key is somewhere the restore procedure can reach. Encryption at rest is right and it introduces a…
Hand-written validation in a REST callback, when the argument definition can do it and produce documentation at the same time. The argument schema validates before the callback runs,…
The May release adds a dark mode built on CSS variables and a data-bs-theme attribute, which works well until the palette is not theirs. The parallel -rgb variables…
A layered architecture documented in a diagram from 2019 and enforced by nothing, with 88 violations by the time anybody checked. The baseline is what makes this adoptable:…
An index containing every column the query touches means the table is never read, and the plan says Using index. The column order is the design: equality predicates…
The PHP SDK reached 1.0 this year and the auto-instrumentation is thinner than the equivalent in other runtimes. The gap is the whole problem — a trace that…