JSON
Reading JSON in Ruby With the json Gem and Its Options
JSON.parse in Ruby 3.4 with json 2.9.1: symbolized keys, big numbers, NaN, comments that parse by default, max_nesting 100, create_additions and errors.
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
Reading JSON in PHP With json decode and Throw on Error
json_decode in PHP 8.5 returns null on bad input unless you throw. Arrays or objects, big integers, depth 512, flags and the list versus object trap.
6 min read
JSON
Reading JSON in Rust With serde json and Typed Structs
Read JSON in Rust with serde_json 1.0.154: derived structs, Option and null, deny_unknown_fields, duplicates, integer ranges, the 128 level limit and enums.
6 min read
JSON
Reading JSON in C Sharp With System Text Json Defaults
What System.Text.Json does by default in .NET 9: exact-case names, JsonSerializerDefaults.Web, enum surprises, the 64 level depth limit and duplicate keys.
6 min read
JSON
Reading JSON in Java With Jackson Records and Trees
Read JSON in Java with Jackson 2.20: records, JsonNode trees, unknown fields, duplicate keys, the nesting and number limits, and the date trap on writing.
6 min read
JSON
Handling Unknown JSON Fields in Go Without Losing Data
Go ignores unknown JSON members by default. Reject them with DisallowUnknownFields, keep them with a raw map, and see where each option stops working.
6 min read
PostgreSQL
SQL JSON Support Added in Recent Versions of PostgreSQL
SQL/JSON in PostgreSQL 16 to 18: constructors, IS JSON, JSON_EXISTS, JSON_QUERY, JSON_VALUE and JSON_TABLE, with examples.
6 min read
YAML
Converting YAML to a Markdown Table for Docs and READMEs
Generate a Markdown table from a YAML list in Python, escaping pipes, joining lists, handling blanks and keeping the table in sync with the YAML in CI.
6 min read
YAML
Converting an Excel Sheet of Settings Into YAML Using Python
Read a key, value and type sheet with openpyxl, build nested YAML from dotted keys, and keep versions, dates and blanks from changing on the way.
7 min read
YAML
Converting YAML to XML With Python and Valid Names
Convert YAML to XML with xmltodict, using @ keys for attributes, repeated elements for lists, and checks for invalid names and the single-root rule.
7 min read
YAML
Converting a CSV Into a YAML List With Correct Types
Turn CSV rows into a YAML list of mappings in Python, keeping zip codes as text and giving integers, floats, booleans and empty cells the right types.
6 min read
YAML
Converting YAML to CSV for Review in a Spreadsheet
Flatten a YAML list of service records into a CSV a reviewer can sort and filter, handling nested keys, list values, missing fields and Excel encoding.
6 min read
Get new articles by email
We send one email when a new article is published. No spam.