A multi-megabyte JSON export often freezes text editors and online viewers, yet parsing it takes only a few hundred milliseconds. We benchmarked a 45 MB, 500,000-record sample to measure time and memory at each stage, show why line count and node count are the real cost, and provide a size-based tool decision table covering online viewing, command-line extraction, streaming, and desktop apps.
Advanced~6 min readUpdated 2026-11-07
Feeding a whole .jsonl file to JSON.parse and getting an error almost never means the file is broken — it means the wrong reading strategy. This guide covers the standard ways to inspect and read JSONL line by line, the commands for converting to and from JSON arrays, a six-row table of common bad lines, and the correct way to consume JSONL from streaming HTTP responses.
Intermediate~9 min readUpdated 2026-11-06
A finished schema is where decay begins, not where work ends: one typo silently widens validation, one refactor breaks every fixture. This guide gives a workable contract testing setup — positive, negative, and snapshot fixtures, schema-first linting, compile-once reuse, and four CI gates that turn contract breakage into a red build.
Advanced~8 min readUpdated 2026-11-05
Nine experiments against a real converter: the first-row-keys strategy silently drops fields, null/missing/empty all collapse into blank cells, a 20-digit integer loses precision at JSON.parse time, and dot-collision flattening merges two different keys into one column. How headers are built, which values mutate, and how to pick a strategy by downstream use.
Intermediate~6 min readUpdated 2026-11-04