The Worst Typo I Ever Made

Summary by Krater

Tom Scott discusses the history and mechanics of the undo feature in computing, exploring how a database typo led to a catastrophic update without backups and why modern undo systems require proper transaction safety or versioning.

From the video

Answers: What happens when an undo command is missing and a database update goes wrong?

• Undo functionality in software
• Database transactions and rollback
• SQL update query mistakes
• History of undo in text editors
• Source control systems and branching

What it concludes

• The undo command was invented independently several times, with the Xerox PARC research center first assigning it to the control-Z keyboard shortcut in the 1970s.
• Saving everything in files that users thought they deleted was a massive privacy and security risk that got turned off in Microsoft Word in 2003.
• Without transactional safety mechanisms like START TRANSACTION and ROLLBACK in SQL, unbacked-up live database updates can lead to catastrophic errors.
• Using a password manager like Dashlane allows users to securely manage and synchronize complex, unique passwords across multiple devices and platforms.