TLDR Web Dev · MISCELLANEOUS
HOW I DESTROYED THE COMPANY'S DB
Summary from the TLDR Web Dev newsletter
The author of this article received a support team message about a customer problem, leading to the accidental deletion of all orders in the production database due to a flawed SQL query. The recovery process involved downtime and efforts to restore the database to a previous state. The mistakes made include working on production during the weekend without proper testing, manual database editing, and not using transactions.