Search for a command to run...
Articles tagged with #databases
Version control for database schema Day 127 of 149 馃憠 Full deep-dive with code examples The Recipe Card Analogy Your grandma's recipe evolves: Version 1: Original recipe Version 2: Add a pinch of salt Version 3: Use brown sugar instead of white Eac...
Saved SQL scripts in the database Day 126 of 149 馃憠 Full deep-dive with code examples The Restaurant Kitchen Analogy Ordering at a restaurant: You don't tell the chef each step: "Boil water, add pasta, cook 10 min..." You just say: "Spaghetti Carbo...
Organizing data to reduce redundancy Day 125 of 149 馃憠 Full deep-dive with code examples The Address Book Analogy Bad address book: "John Smith, 123 Main St, Sydney NSW 2000" "John Smith, 123 Main St, Sydney NSW 2000" (repeated!) What if John moves...
Pick two: consistency, availability, partition tolerance Day 124 of 149 馃憠 Full deep-dive with code examples The Three Wishes Analogy A genie says: "Pick any TWO wishes, but not all three" Wish 1: Fastest car Wish 2: Cheapest car Wish 3: Most relia...
Guarantees for data reliability Day 123 of 149 馃憠 Full deep-dive with code examples The Bank Transfer Analogy Transferring money from Account A to B: Subtract the amount from A Add the amount to B What if the power goes out between steps? A lost ...
Copying data to multiple servers Day 122 of 149 馃憠 Full deep-dive with code examples The Backup Copy Analogy Important documents: One copy at home One copy at the bank One copy at your lawyer's If your house burns down, you still have copies! Data...