Library

Everything you need to level up your coding skills.

CSV

MySQL Error 1290 The Server Is Running With secure file priv

Error 1290 blocks LOAD DATA INFILE and INTO OUTFILE outside one directory. Find the allowed path, move the file there, or switch to LOCAL and know the cost.

6 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

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

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

CSV

Skipping Bad Rows During a PostgreSQL CSV Import Safely

PostgreSQL 17 can skip rows with bad values during COPY. See ON_ERROR, REJECT_LIMIT and verbose logging in action, and the errors they do not cover.

7 min read

XML

Converting XML to CSV for Spreadsheet Users Safely

Turn a nested XML file into a flat CSV with Python, joining repeated authors into one cell with correct quoting, and see why pandas read_xml dropped one.

7 min read

CSV

Handling NULL and Empty Strings in PostgreSQL CSV Imports

PostgreSQL loads an unquoted empty field as NULL and a quoted one as an empty string. See the options that change that and the integer error one causes.

8 min read

XMLGuide

Converting XML to JSON CSV YAML and Excel Without Data Loss

One XML file converted to JSON, CSV, YAML and Excel with one parse and four writers, what each target loses, and how to prove nothing went missing.

20 min read

CSV

Loading a CSV Into a Staging Table Then Cleaning It in SQL

Load a messy CSV as text first, then convert it with SQL. Build a three format date parser, a reject table with reasons, and the typed insert.

8 min read

CSV

Importing Only Some CSV Columns Into a PostgreSQL Table

COPY cannot skip file columns. Compare two ways to load three of eight columns of a 2,000,000 row CSV, with timings, and see why cut breaks on quotes.

6 min read

CSV

PostgreSQL Invalid Byte Sequence for UTF8 in a CSV Import

COPY stops with an invalid byte sequence error when a CSV is Latin 1. Fix it with the ENCODING option or client_encoding, and avoid the SQL_ASCII trap.

7 min read

Get new articles by email

We send one email when a new article is published. No spam.