CSV
MySQL LOAD DATA LOCAL INFILE Disabled and How to Enable It
Two switches control LOAD DATA LOCAL, one on the server and one on the client, each failing with its own error code. Enable both safely and know the risk.
6 min read
Tag
how-to
590 posts
YAMLGuide
Reading and Writing YAML in Python Safely and Cleanly
A tested Python guide to YAML: safe loading, speed, strict keys, validation, clean output, round trips, merging, env substitution and a reference module.
20 min read
XML
Converting CSV to XML With a Template That Escapes Correctly
Build XML from CSV rows without string templates that break on an ampersand. Use lxml or escape every value, and handle control characters and empty cells.
7 min read
JSON
Adding and Removing Keys From JSONB With jsonb_set and Minus
Add, rename, merge and delete keys and array elements in PostgreSQL JSONB with jsonb_set, jsonb_insert, || and minus, and see where each does nothing.
8 min read
CSV
Using LOAD DATA INFILE to Import a CSV Into MySQL Tables
Every clause of LOAD DATA INFILE that matters for a CSV, from the tab default to NULL handling, with the output of each variant on MySQL 8.4.
7 min read
XML
Converting XML to YAML for Config Review and What It Breaks
Convert an XML config to YAML so a person can read and diff it, and learn why a YAML 1.1 loader turns the strings no and NO into false and 0755 into 493.
7 min read
JSON
Updating One Key Inside a JSONB Column Without Losing Data
Change a single field in a PostgreSQL JSONB document with jsonb_set or subscripts, increment a counter, and avoid the lost-update and rewrite costs.
8 min read
Editor's pick
CSVGuide
How to Import a CSV File Into MySQL the Reliable Way
LOAD DATA LOCAL turns bad values into warnings and still reports success. Import a CSV into MySQL safely, with a script that checks before it swaps.
23 min read
CSV
Loading a CSV From a URL Into PostgreSQL Without Saving It
Stream a CSV from a web address straight into COPY with curl. See what a 404 and a cut off download do to a plain pipe, and the guards that fix it.
8 min read
XML
Converting XML to Excel With Python and Typed Cells
Write an XML file into an xlsx workbook with openpyxl so numbers are numbers, booleans are booleans and identifiers stay text, and read it back to check.
7 min read
JSON
Extracting Nested JSONB Values With Path Operators
PostgreSQL reads deep JSONB values with #> and #>>, and filters with jsonpath. How array paths, missing keys, strict mode and wildcards actually behave.
8 min read
CSV
Loading a Gzipped CSV Into PostgreSQL Without Unpacking It
Stream a gzipped CSV into PostgreSQL with gunzip and COPY, time it against unpacking first, and see what a truncated archive does to a pipe.
8 min read