PostgreSQLGuide
Setting Up PostgreSQL for Development Without Fighting It
Set up PostgreSQL for development: choose native or Docker, pick a version, create a user, connect, find the config files and fix common errors.
18 min read
Tag
hub
102 posts
YAMLGuide
YAML Syntax You Need to Stop Guessing At and Start Knowing
A complete guide to everyday YAML syntax: indentation, scalars, quoting, collections, block strings, anchors, null and versions, tested with real parsers.
19 min read
JSONGuide
Fixing JSON Parse Errors by Reading the Message Properly
How to read a JSON parse error: what the position means in Python, Node, PHP and jq, twelve common causes, and a method that finds the bad byte fast.
18 min read
XMLGuide
Fixing XML Parse Errors Fast With a Triage Routine
A tested routine for XML that will not parse: check the bytes, then the encoding, then the characters, then the structure, with an error message dictionary.
19 min read
ExcelGuide
Getting Excel Data Into a Database Without Heartbreak
A complete method for loading Excel into PostgreSQL, MySQL, SQLite or SQL Server: read as text, stage, check counts, convert types and reload safely.
18 min read
Editor's pick
CSVGuide
Everything a CSV File Does and Does Not Promise You
A CSV file promises rows and delimiters and little else. See what six readers did with one awkward file, and how to read CSV without guessing.
24 min read