CSV
Reading a CSV File in Java With OpenCSV and Commons CSV
Read CSV in Java with OpenCSV and Commons CSV: a backslash escape that breaks paths, ints that turn blanks into 0, and a writer that quotes everything.
10 min read
Library
Everything you need to level up your coding skills.
YAMLGuide
YAML Security Pitfalls and How to Test Your Own Code
Seven ways YAML hurts: object loading, alias bombs, size, type confusion, duplicate keys, leaked secrets and values used as code, tested in five languages.
17 min read
ExcelGuide
Reading and Writing Excel From JavaScript Java and C Sharp
Cross language reference for reading and writing xlsx in JavaScript, Java, C Sharp, PHP, R, Go, Ruby and Rust: libraries, types, dates, memory and security.
17 min read
XMLGuide
Comparing and Versioning XML Files in Git and in Pipelines
A tested guide to comparing XML, from canonical form and keyed record diffs to Git diffs, merges, feed shape checks and schema compatibility.
18 min read
JSON
Oracle JSON_TABLE for Turning Documents Into Rows Explained
How Oracle's JSON_TABLE projects a JSON document into relational rows and columns, with row paths, nested paths, ordinality, ON ERROR and ON EMPTY clauses.
7 min read
CSV
Reading and Writing CSV in Go With encoding csv and Streams
Read and write CSV in Go with encoding/csv: quoting, field-count errors, LazyQuotes, the BOM it leaves in, ReuseRecord and 2,000,000 rows in 7 MB.
9 min read
Excel
Replacing a Fragile Excel Model With a Query and a View
Move a fragile Excel model into a SQL view: map inputs, calculations and outputs, translate formulas, run both in parallel and keep Excel as the front end.
8 min read
Editor's pick
CSVGuide
Reading CSV Files in Go Java R Rust and C Sharp Compared
Ten languages read the same awkward CSV files: speed on 2,000,000 rows, BOM, bad quotes, ragged rows, leading zeros and defaults that bite, plus a test list.
18 min read
XML
Why Excel Complains About an XML Source Having No Schema
When Excel says the XML source has no schema, it infers one. What the guess means, why it breaks on optional and repeating data, and how to supply a schema.
5 min read
JSON
Building JSON From Query Results With FOR JSON in SQL Server
Turn SQL Server rows into JSON with FOR JSON PATH and AUTO, nest child rows, control nulls and wrappers, and avoid the double-encoding trap with JSON_QUERY.
7 min read
Excel
Checking Totals Between Two Excel Reports With SQL
Reconcile two Excel reports with SQL: compare grand totals, then group totals, then rows with a full outer join, and sort the differences into causes.
7 min read
CSV
Fixing Garbled Characters in a Downloaded CSV From a Web App
A CSV from your web app opens as Zoë in Excel. Check the bytes, the charset header and the BOM the server sends, then fix Express, Blobs and file names.
8 min read
Get new articles by email
We send one email when a new article is published. No spam.