ExcelGuide
When a Spreadsheet Has Become a Database and What to Do
How to tell that an Excel file now behaves as a database, choose SQLite, Access or PostgreSQL, design tables, migrate safely and keep Excel as a reader.
17 min read
Tag
hub
102 posts
CSVGuide
CSV Tools Worth Knowing and When to Reach for Each One
A field guide to CSV tools: csvkit, qsv, Miller, DuckDB, sqlite-utils, Polars, pandas and VisiData, run on the same 2 million row file with timings.
18 min read
CSVGuide
CSV Dialects and Variants You Will Run Into in Practice
The CSV dialects that exist in the wild, from RFC 4180 and Excel to PostgreSQL text, MySQL, TSV and pipes, with the settings that tell them apart.
19 min read
JSONGuide
Event Analytics on JSON Properties in PostgreSQL Tested
A tested guide to analytics on JSON event data: envelope versus properties, funnels and retention, typed columns, indexes, type drift and backfills.
19 min read
JSONGuide
Testing Code That Produces JSON From Asserts to Contracts
A tested guide to testing JSON output: asserts, snapshots, volatile fields, schemas, generated data, fixtures and property tests, with a mutation matrix.
17 min read
JSONGuide
JSON in Go Java Rust C Sharp PHP Ruby Compared Side by Side
One order document read in Go, Java, Rust, C#, PHP, Ruby, Python, Node and Bash: unknown keys, case, nulls, big ints, depth, duplicates and strictness.
18 min read
JSONGuide
Using JSON in Application Design Without Making a Mess
A tested guide to where JSON belongs in an application: columns, API shapes, settings, events, drift and patches, with measured costs in PostgreSQL.
17 min read
CSVGuide
Automating CSV Imports Into a Database Without Surprises
Build a CSV import job that runs unattended: idempotent loads, one transaction, reject files, an archive, a ledger, locking, alerts and a safe backfill.
21 min read
JSONGuide
JSON Security Mistakes in Apps and Pipelines and Their Fixes
A tested guide to JSON security: where bodies turn hostile, parser differences, prototype pollution, SQL, limits, numbers, logs, and a checklist.
18 min read
JSONGuide
JSONPath JMESPath and SQL Path Expressions Compared
JSONPath, JMESPath, jq and the path dialects of PostgreSQL, MySQL and SQLite tested on one document: syntax, null handling, speed, indexes, portability.
19 min read
JSONGuide
Comparing and Patching JSON Documents Without Surprises
A tested guide to diffing, patching and merging JSON: normalizing, array identity, JSON Patch, Merge Patch, atomic apply, deep merge, history and tests.
17 min read
ExcelGuide
Excel Reports That Finance Teams Rely On Month After Month
What makes an Excel report dependable for finance: reconciliations, rounding, controls, evidence, invoices, budgets, timesheets and currencies.
16 min read