MySQL
Running MySQL in Docker With a Data Volume That Persists
Run MySQL 8.4 in Docker with a named volume, environment variables, a custom config, health checks, initialization scripts and safe upgrades.
6 min read
Topic
Tooling
Clients, formatters, linters and CLIs worth installing. Small tools that save hours.
PostgreSQL
Creating Your First Database User and Schema in PostgreSQL
Create your first PostgreSQL role, database and schema: CREATE ROLE with LOGIN, a database with an owner, search_path, and the public schema change.
7 min read
MySQL
Installing MySQL 8.4 on macOS Linux and Windows Step by Step
Install MySQL 8.4 LTS on macOS, Ubuntu and Windows: package sources, first start, the root account, secure setup and checks that the server works.
6 min read
PostgreSQL
Running PostgreSQL in Docker With a Persistent Volume
Run PostgreSQL in Docker with a named volume so data survives restarts, set the password and database on first start, publish the port safely and use Compose.
7 min read
MySQLGuide
Getting a MySQL Server Running and Usable From Scratch
A beginner guide to getting a MySQL server running: choose a version, install, secure, connect, create users and fix the first errors.
16 min read
PostgreSQL
Installing PostgreSQL on macOS Linux and Windows Today
Install PostgreSQL on macOS with Homebrew, on Linux with packages and on Windows with the installer, then check that the service runs.
7 min read
YAML
Diffing YAML Files Without Whitespace Noise or Reordering
diff -w hides YAML indentation changes that alter meaning. Normalize both files with yq sort_keys and compare as data to ignore layout and order only.
6 min read
YAML
Merging YAML Files From the Command Line With yq Safely
Deep-merge a base and an override with yq eval-all, choose whether lists replace or append, and check what a null or an empty value in the override does.
6 min read
XML
When XML Is Still the Right Format and When It Is Not
Documents with inline markup, schemas that partners must honor, signatures and long-lived standards keep XML in use. A checklist of five situations.
6 min read
XML
XML Versus Protocol Buffers for Services and Messages
50,000 orders in four formats: protobuf was 5.1 MB, JSON 10.8 MB, XML 14.2 MB, and it parsed in 9 ms against 161 for XML. What that buys and costs.
5 min read
XML
Compressing XML Archives and Reading Them In Place
A 127 MB XML file shrank to 14.8 MB with gzip, 15.4 MB with zstd and 10.8 MB with xz. Costs in seconds, and how to parse a gzip file without unpacking.
6 min read
YAML
Fixing YAML Indentation Errors With a Linter and Editor
A messy file with nine findings, reported by yamllint line by line, then repaired with yq and a project config. The workflow that finds and fixes indentation.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.