Databases
Indexes Explained Without the Jargon
An index is a sorted lookup the database keeps alongside your table. Understanding that one sentence explains almost every indexin…
Writing
Blog
Guides, updates and the occasional opinion.
Databases
Choosing Between MySQL, PostgreSQL and SQLite
All three are excellent. The right answer depends on concurrency, data shape and who maintains it.
Databases
Database Backups for Applications That Cannot Stop
Copying a database file while it is being written produces a backup that restores into corruption. Here is how to take a consisten…
Databases
Reading a Slow Query Log Without Being a DBA
The slow query log tells you exactly which statements are costing you. Most people never turn it on.
Databases
Query Pagination That Stays Fast on Large Tables
OFFSET-based pagination degrades exactly where it matters: deep in a large result set.
Databases
Normalisation, and When to Deliberately Break It
Normalise until it hurts, denormalise until it works — but know which pain you are trading for.