From Tables to Documents - Changing Your Database Mindset

on YouTube ↗41m

" summary

Compares MySQL and MongoDB using Python code and concrete user documents (Lesley, Ron, Lauren) to show that documents map to language data structures, making queries and updates faster and simpler — the demo shows 27 lines vs 2 lines of code for the same profile update. Explains sharding for horizontal scaling, flexible schema (omit fields instead of nulls), the outlier and polymorphic patterns for huge follower lists, and why data accessed together should be stored together so multi-document transactions are rarely needed.

AI-written summary · about

" chapters (7)

1. 0:00Introduction and speaker intro
2. 2:09From Ron Swanson to database mindset
3. 4:59Documents and JSON explained
4. 14:21Term mapping tables to documents
5. 18:58Four advantages of document databases
6. 31:40Changing your database mindset
7. 39:44Conclusion and resources

" related talks

• 46mFrom Tables to Documents -- Changing Your Database MindsetLauren Schaefer · NDC Oslo 2020
• 38mFrom Tables to Documents—Changing Your Database MindsetLauren Schaefer · Berlin Buzzwords 2021
• 01h 00mThe Modern Database Debate: Documents, Tables, or Documents in Tables?Franck Pachot · IntelliJ IDEA Conf 2025
• 30mHelp! I Need To UnSQLize My ApplicationJoel Lord · PyCon Italia 2023
• 44mThe Developer's Guide to Data Modelling with Document DatabasesAdrienne Braganza Tacke · NDC Porto 2022
• 18mFrom SQL to NOSQL - a gentle intro for DevsJoe Karlsson · Conf42 JavaScript 2020
• 29mSwitching to MongoDB: The challenges of translating database schemasKatie Bell · PyCon AU 2024
• 26mNoSQL Data Modeling for Front-end DevelopersStanimira Vlaeva · EnterpriseNG 2021