JSON
Versioning a JSON Schema Without Breaking Consumers
Which schema changes break old producers and old consumers: a tested compatibility matrix, open versus closed objects, version numbers and a CI check.
8 min read
Library
Everything you need to level up your coding skills.
XML
Moving From XML to JSON Gracefully Without Losing Meaning
Generic converters guess at lists, attributes and mixed text. Write a small mapping with explicit rules so the JSON stays predictable for every record.
6 min read
JSON
Checking a JSON Column Against a Schema in PostgreSQL
Enforce the shape of a PostgreSQL jsonb column with CHECK constraints, NOT VALID and jsonpath, including the NULL trap that lets a string id pass.
8 min read
XML
Converting JSON to XML With Sensible Element Names
JSON keys can be any string and XML names cannot. Make legal names from spaces and leading digits, write arrays as repeated elements, and mark null.
7 min read
JSON
Generating a JSON Schema From Sample Data and Fixing It
Draft a JSON Schema from sample documents with genson, see what it infers and what it misses, and turn the draft into a contract with DuckDB as a cross-check.
7 min read
XML
Converting XML to JSON and the Attribute Problem Explained
XML has attributes, repeated children and mixed text, and JSON has objects and arrays. Where the mapping is lossy, what xmltodict does, and the fixes.
7 min read
JSON
Reusing Definitions With ref in JSON Schema Documents
Reuse schema pieces with $ref and $defs: local pointers, references between files by $id, recursive trees, and resolver and draft traps in Python and Node.
7 min read
JSON
Using JSON Schema Enums Formats and Patterns Correctly
Where Python and Node disagree on JSON Schema formats and patterns: email, uri, hostname, digits, trailing newlines, plus exact enum and const behavior.
6 min read
CSV
Converting JSON to CSV When the Data Is Nested With Arrays
Flatten nested JSON to CSV with pandas, Python or DuckDB: dotted columns, a row per array item, the order that vanishes and arrays written as Python text.
10 min read
JSON
Validating Arrays and Nested Objects With JSON Schema
Validate arrays of objects, tuples and deep nesting with JSON Schema: items, prefixItems, contains, uniqueItems and error paths, tested in Python.
6 min read
JSON
Required Fields and Optional Fields in JSON Schema
How required, null, empty strings and defaults differ in JSON Schema, with test results for dependentRequired and if-then rules for conditional fields.
6 min read
JSON
Writing Your First JSON Schema From a Real Document
Build a JSON Schema from a user profile document one keyword at a time, run it in Python after each step, and catch typos that a validator ignores silently.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.