Blog category
4=posts
JSON, XML, YAML, CSV, SQL — and the conversion headaches between them.
Data
- csvdataexcel
CSV parsing is harder than you think (and why `split(',')` isn't enough)
Quoted fields, escaped quotes, embedded newlines, UTF-8 BOMs, Excel's opinions. A tour of every CSV footgun and the libraries that handle them.
2 min readRead - jsonjavascriptpython
NaN, null and undefined in JSON: what serialises to what
JSON has null. JavaScript has null, undefined and NaN. Python has None. This is the table of what survives each conversion — and the traps everyone hits.
2 min readRead - jsonyamlconfig
How to convert JSON to YAML (and back) without breaking things
JSON ↔ YAML looks simple until you hit anchors, multi-line strings, booleans that aren't booleans, and the Norway problem.
5 min readRead - jsonxmldata
JSON vs XML in 2026: which should you actually use?
JSON won the API war — but XML still rules in finance, government, and SOAP. Here's a no-nonsense breakdown of when each makes sense.
5 min readRead