JSON
Why JSON Has No Comments and What People Do Instead
JSON has no comment syntax by design, so a // note fails in every parser tested. What people do instead: _comment keys, $comment, JSONC, JSON5 and YAML.
6 min read
Topic
JSON
Nested, loosely typed and everywhere. Query it, flatten it, validate it and store it without losing what the nesting meant.
JSON
JSON Data Types and What Is Missing From Them Entirely
JSON has six value types and no date, binary, integer, decimal, set or undefined. See what Python and JavaScript do to each missing type when they serialize.
6 min read
JSONGuide
What JSON Allows and What Parsers Quietly Accept in Practice
The JSON grammar fits on a page, and parsers still disagree on trailing commas, NaN, duplicate keys, big numbers and more. A 26-case test across five parsers.
17 min read
JSON
Backfilling Historic Events After a Schema Change Safely
Three ways to rewrite a renamed JSON property across 1.5 million events in PostgreSQL: one UPDATE, batches and a table swap, with WAL, bloat and leftovers.
7 min read
JSON
Handling Properties That Change Type in JSON Event Data
Fix invalid input syntax for type numeric on a JSON property that became a string, null or object, with jsonb_typeof, pg_input_is_valid and a function.
7 min read
JSON
Indexing Hot JSON Properties for Dashboards in PostgreSQL
Expression, partial and GIN indexes on a 2.25 million row jsonb event table: a selective lookup fell from 65 ms to 5 ms, a 4 percent filter got slower.
6 min read
JSON
Extracting Properties Into Typed Columns Nightly From JSON
A nightly job that turns jsonb event properties into a typed facts table in PostgreSQL: safe casts, a watermark, idempotent inserts and a 47x speedup.
7 min read
JSON
Designing JSON Event Properties for Analysis From Day One
Four designs for the same 500,000 purchase events compared on size and query time: verbose nesting, short flat keys, hybrid columns and key/value arrays.
6 min read
JSON
Parsing a Package Registry Metadata File Where Keys Are Data
Read a package metadata document where version numbers are keys: json_each, DuckDB MAP inference, semver sorting, dist-tags versus max, and the time map.
7 min read
JSON
Converting YAML to JSON for Tools That Need It Safely
Convert YAML to JSON with PyYAML and ruamel.yaml, and handle dates, yes and no, octal numbers, non-string keys, anchors, multiple documents and floats.
8 min read
JSON
Converting JSON to YAML on the Command Line Safely
Convert JSON to YAML with yq, Python's yq and a PyYAML one-liner, and see which strings get corrupted by YAML 1.1 readers: NO, yes, 12:30, 0123 and 1e3.
7 min read
JSON
Handling a Weather API With Nested Arrays of Measurements
Weather APIs return columns as parallel arrays. Turn them into rows with pandas and DuckDB, handle nulls and unequal lengths, and keep units and zones.
6 min read
Get new articles by email
We send one email when a new article is published. No spam.