Practical engineering tips, design theory and performance breakdowns — written for developers and founders who like their advice tested in production.
Filtering by tag #database — clear
Which free database should you pick for a side project? A comparison of managed Postgres, MongoDB and edge SQLite options, with the limits that matter and how to stay portable.
Read →
The choice isn't about which database is modern or fast. It's about the shape of your data and how you'll query it. A practical comparison and a simple decision process.
Read →
INNER, LEFT, RIGHT and FULL joins, the anti-join trick for "find rows with no match", and why joins sometimes multiply your rows. Clear examples you can run against any SQL database.
Read →
Schema changes cause more scary deploys than almost anything else. How migrations work, the rules that keep them safe, and the expand-and-contract pattern for changes with zero downtime.
Read →
Backups are only real if you can restore them. The 3-2-1 rule, logical dumps vs point-in-time recovery, how often to back up, and the restore drill that most teams skip until it's too late.
Read →
Your page loads 20 posts and quietly runs 21 database queries. The N+1 problem is the most common ORM performance bug. Here is how to recognise it and fix it in any stack.
Read →
One missing index can turn a 5ms query into a 5 second one. What indexes are, how to read EXPLAIN, how composite indexes really work, and when an index makes things worse.
Read →
Off-by-one-day birthdays, events that jump an hour twice a year, and reports that disagree between servers. The rules for storing, sending and displaying dates that prevent all of them.
Read →