JSONGuide
Moving Between JSON and MongoDB Documents Without Loss
A working guide to moving data between JSON and MongoDB: types, import flags, Extended JSON exports, round trips, flattening, nested queries, validation.
17 min read
Library
Everything you need to level up your coding skills.
Excel
Versioning Template Layouts So Old Files Still Import
Version Excel template layouts so the loader recognizes old files: a version cell, compatible changes, migration rules, a support window and a changelog.
8 min read
CSV
Importing a CSV Into Google Sheets With the Right Types
Import a CSV into Google Sheets without losing zeros or flipping dates: the import dialog, the locale, IMPORTDATA and an Apps Script that keeps text.
6 min read
PostgreSQL
Partition Pruning in PostgreSQL and Checking It Works
Partition pruning in PostgreSQL explained: plan time and run time pruning, what defeats it, how to read EXPLAIN output and a checklist for fixing queries.
7 min read
Excel
Reserving Notes in a Separate Sheet of Import Templates
Give notes, comments and instructions their own place in an import template so the data sheet stays a clean table, and make the loader ignore strays.
7 min read
XML
Using yq to Read XML From the Command Line and Pipelines
Two different tools are called yq. Both read XML and print JSON or YAML, with different prefixes for attributes. See each one's output and which you have.
6 min read
CSV
Saving an Excel Sheet as CSV Without the Extra Commas
Excel adds trailing commas and blank rows to a CSV when empty cells outside your data hold formatting. Find the used range, clear it and check the file.
7 min read
JSONGuide
Pulling JSON From APIs Into a Database Reliably in Python
A working guide to loading JSON APIs into a database: raw pages, pagination, rate limits, upserts, cursors, shape checks and retries, with a tested loader.
17 min read
Excel
Data Types per Column in Templates That Feed a Database
Map Excel template columns to database types: text for identifiers, real dates, fixed-decimal numbers, flags and lists, with validation and checks.
7 min read
CSV
Why Excel Shows a CSV in One Column and What Causes It
Excel puts a whole CSV row in one cell for five different reasons. Learn how to tell which one you have by reading the first line of the file.
7 min read
YAML
YAML Versus JSON for Configuration Files That Last
Comments, types, size, parse speed and safety compared with measured numbers, plus why JSON is nearly valid YAML. One format costs 55 times more to parse.
6 min read
XML
Editing XML Files in Place From a Script Without Damage
Change a value, add an attribute and delete an element in XML from a script with xmlstarlet or lxml, and compare with sed on diffs, comments and escaping.
6 min read
Get new articles by email
We send one email when a new article is published. No spam.