JSONGuide
Event Analytics on JSON Properties in PostgreSQL Tested
A tested guide to analytics on JSON event data: envelope versus properties, funnels and retention, typed columns, indexes, type drift and backfills.
19 min read
Topic
JSON
Nested, loosely typed and everywhere. Query it, flatten it, validate it and store it without losing what the nesting meant.
JSONGuide
Testing Code That Produces JSON From Asserts to Contracts
A tested guide to testing JSON output: asserts, snapshots, volatile fields, schemas, generated data, fixtures and property tests, with a mutation matrix.
17 min read
JSON
Parsing JSON in Go With Struct Tags and the Standard Library
Decode JSON into Go structs with struct tags: null versus missing with pointers, case-insensitive keys, int64 ids, wrong-type errors and the omitempty trap.
6 min read
JSONGuide
JSON in Go Java Rust C Sharp PHP Ruby Compared Side by Side
One order document read in Go, Java, Rust, C#, PHP, Ruby, Python, Node and Bash: unknown keys, case, nulls, big ints, depth, duplicates and strictness.
18 min read
JSON
Partial Updates and Patch Semantics in JSON APIs Done Right
Why a PUT drops fields, why dict.update clobbers nested objects, how absent differs from null in Pydantic, and how field-level SQL avoids lost updates.
7 min read
JSON
JSON Columns and Schema Drift and How to Find It Early
Measure schema drift in a jsonb column with key counts and type counts, see how it changes a sum, and stop it with a NOT VALID check constraint.
6 min read
JSONGuide
Using JSON in Application Design Without Making a Mess
A tested guide to where JSON belongs in an application: columns, API shapes, settings, events, drift and patches, with measured costs in PostgreSQL.
17 min read
JSONGuide
JSON Security Mistakes in Apps and Pipelines and Their Fixes
A tested guide to JSON security: where bodies turn hostile, parser differences, prototype pollution, SQL, limits, numbers, logs, and a checklist.
18 min read
JSONGuide
JSONPath JMESPath and SQL Path Expressions Compared
JSONPath, JMESPath, jq and the path dialects of PostgreSQL, MySQL and SQLite tested on one document: syntax, null handling, speed, indexes, portability.
19 min read
YAML
Converting JSON to YAML Without Losing Types or Quotes
Convert JSON to YAML with a YAML library so strings like yes, 3.10 and 02134 keep their quotes, and see what string formatting does to the same data.
7 min read
JSONGuide
Comparing and Patching JSON Documents Without Surprises
A tested guide to diffing, patching and merging JSON: normalizing, array identity, JSON Patch, Merge Patch, atomic apply, deep merge, history and tests.
17 min read
YAML
Converting YAML to JSON in Python Without Date Errors
Convert YAML to JSON with PyYAML and json, and handle the cases that break it: dates, sets, integer keys, NaN, anchors, several documents and complex keys.
6 min read
Get new articles by email
We send one email when a new article is published. No spam.