Databases are the worst. Here is a repository of public posts by companies when a database (or a few) caused that company staff some long term trauma
May this list serve as a lesson as you use these tools of pain
- Github tells us why cross region failover is not that simple
- GIthub again reminds us that scaling databases is hard
- Linear teaches us why foreign keys are a considered harmful
- Vaccuum your transaction logs!
- "Always have plenty of access guard rails for your production databases. And make it very hard to delete data", GitLab.....Also, replication is not deletion protection 🫠
- RPOs and RTOs are fantasies. Unless you practice them
- There are databases everywhere. Even ones you can't control that can still cause you pain
- The worst kind of database outage is data loss/corruption. Way worse than downtime
- If you are a nascant database vendor, job #1 is to not lose data
- Fault domains mean nothing if it all comes down to one database, as Heroku learned recently
- Foreign keys....strike again!
- Oh my...sometimes the nightmare keeps going
- Even 'INSTANT' schema changes can go sideways
Maintained by Silvia Botros. PRs welcome