AI summary by TwinMind

The Worst Typo I Ever Made

Tom Scott

11m 24s

The "Oh No" Second Concept

  • Defines "oh no second" as moment after making terrible mistake when consequences flash through mind
  • Examples: sending text to wrong person, deleting wrong file, spilling secrets
  • Stomach-dropping moment when only response is "oh no"

Website Migration Project Setup

  • Speaker was 18-19 years old, in charge of converting old website to new faster platform
  • Half dozen volunteers spent days transferring articles, copying from old site, updating and saving
  • Final task: search/replace across all content pages to add formatting
  • Needed to replace three dashes (---) with HTML tag for horizontal line
  • Mid-2000s standard SQL database, no fancy tools
  • Working directly on live database via command line

The Fatal Typo

  • Intended SQL command: replace dashes with HTML tag in content field
  • Command should have referenced content field (backticks for database field names)
  • Actually typed 'content' with apostrophes (literal string)
  • Result: replaced all content in 5,000 articles with literal word "content"
  • Affected entire live website, wiping out all volunteer work

Undo Systems in Computing History

  • Undo command invented independently multiple times in 1970s at Xerox PARC
  • Assigned to Ctrl+Z keyboard shortcut
  • Most undo systems are linear: ordered list of commands to step back/forward through
  • Basic implementation: store exact document state after every command/keystroke
  • Memory intensive but works as simple mental model

Advanced Undo Concepts

  • Time travel problem: going back and making changes breaks future timeline
  • Undo trees: create new timeline branches when changing history after going back
  • Some text editors visualize branches but too complicated for mainstream appeal
  • Source control systems (like Git): every commit saved forever, multiple people can work simultaneously
  • Keystroke-level undo works in fast memory vs file-level saves to slower disk

Microsoft Word Fast Save Feature

  • 1990s feature: appended changes to end of file instead of rewriting entire document
  • Avoided 5-10 second save times on slow computers
  • Security risk: saved content users thought was deleted
  • Feature removed in 2003

Modern Cloud-Based Saving

  • Google Docs: keystrokes constantly saved and synchronized
  • Never need to hit save manually
  • Changes mental model of how work is saved
  • Sometimes don't want every keystroke saved (boss's colorful comments, accidentally pasted passwords)

Database Transactions and Safety

  • SQL databases have transaction system: START TRANSACTION, COMMIT, ROLLBACK
  • Edits accepted but not permanently saved until COMMIT
  • ROLLBACK cancels all commands in transaction
  • Speaker didn't use transaction safety net

Root Cause Analysis

  • Typo itself was reasonable mistake anyone could make
  • Real problem: poor decisions leading up to it
    • Working on live database
    • Overconfidence in simple command
    • No backup system
    • No safety nets
  • Days of volunteer work lost
  • Should have had daily/hourly backups

Lessons Learned

  • Overconfidence and negligence were root causes, not the typo
  • Programmers have magical "undo" ability that physical-world professionals lack
  • Essential to have backups of code, thesis, photos, databases
  • Don't postpone backup creation
  • Test that backups actually work
  • Lesson typically only learned once

Password Security Segment

  • Password managers recommended due to security breaches
  • Companies' security breaches often involve stolen username/password lists
  • Reusing passwords/variations is dangerous
  • Dashlane recommendation with security white paper validation
  • Features: long complicated passwords, cross-platform sync, autofill capabilities
  • Business version for team password sharing
  • Promotional offer: dashlane.com/tomscott, code "tomscott" for 10% off premium

TwinMind

Get summaries like this for your own meetings

TwinMind takes notes in the background during meetings, lectures, and calls, then writes the summary for you.

Free plan to get started

No bot joins your calls

Phone, desktop & Chrome apps

Your next meeting, summarized like this

TwinMind listens in the background and turns meetings, lectures, and calls into searchable notes you can chat with. Start free.

Available on phone, desktop & Chrome

Your next meeting, summarized like this

TwinMind listens in the background and turns meetings, lectures, and calls into searchable notes you can chat with. Start free.

Available on phone, desktop & Chrome

Your next meeting, summarized like this

TwinMind listens in the background and turns meetings, lectures, and calls into searchable notes you can chat with. Start free.

Available on phone, desktop & Chrome