Archive
json
-
json_validate and typed class constants, four months in
Measured numbers from validating a 24.7 MiB partner payload with json_validate instead of decoding and discarding it, the one case where it saves nothing, and what typed class constants caught in our code.
-
JSON_THROW_ON_ERROR earned its keep
A truncated partner payload decoded to null for nineteen days and nobody noticed, because json_decode reports failure with the same value it returns on success. One PHP 7.3 flag fixed that.
-
MySQL 5.7 JSON columns, and the regrets that followed
A support lookup read 2.4 million rows to return 41 of them, because the predicate sat inside a JSON document. The generated column fix, the two details that broke it first, and what I keep out of documents now.