XML
Reading XML in Java With JAXB Annotations and Its Defaults
Map XML to Java classes with Jakarta XML Binding, read attributes, lists and optional elements, and see a bad boolean and a bad number accepted silently.
6 min read
Library
Everything you need to level up your coding skills.
CSV
Stripping Personal Data From a CSV Before Sharing It
Remove, generalize and pseudonymize the personal columns of a CSV with DuckDB before it leaves your team, then check that no one can still be singled out.
7 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
Excel
Building a Budget Workbook From Query Output Reliably
Build a budget workbook from SQL output: actuals from the ledger, budget versions in a table, variances, planner input cells and a frozen release.
7 min read
CSV
Why a Hostile CSV Upload Can Hurt Your Application Server
A CSV upload needs no exploit to take a server down: compressed bombs, one huge field, an unclosed quote and wide files, each with the limit that stops it.
7 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
XML
DOM Versus SAX Versus StAX Parsing in Java Compared
The three Java XML APIs on one 36.6 MB file: DOM ran out of memory at a 256 MB heap and took 1.03 s with 1 GB, while SAX and StAX ran in 32 MB in about 0.3 s.
7 min read
CSV
Escaping Formula Characters in a CSV Export Safely
A small function that neutralizes formula triggers in CSV text cells, why negative numbers must be exempt, and a test table to keep the fix from regressing.
7 min read
Excel
Reconciling Bank Statements Against a Database Table
Reconcile a bank statement against a ledger table: load it, match in passes, list unmatched items on both sides and explain the closing difference.
8 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
CSV
CSV Injection and How Formulas in a Cell Become an Attack
How a name starting with an equals sign turns your CSV export into an attack on whoever opens it, what payloads do, and how to test your own exports.
7 min read
XML
Splitting a Big XML File by Repeating Element Safely
Split a 36.6 MB XML file into eight valid files of 25,000 orders with iterparse in 1.5 seconds at 21 MB, and see why split -l produces broken XML.
6 min read
Get new articles by email
We send one email when a new article is published. No spam.