~/talk

From Tables to Documents—Changing Your Database Mindset

on YouTube 38m
Talkat Berlin Buzzwords 2021 · 2021-06-15..06-17· [databases]

speaker

name:Lauren Schaefer
links:none on file

resources

video:https://youtu.be/IkjgiWYmUTI
slides:none on file

summary

Compares MySQL and MongoDB with Python code and real examples, claiming four concrete gains: scale horizontally by sharding (cheaper, no downtime), query faster by avoiding expensive joins, pivot easier with a flexible schema (add a school field to one user without ALTER TABLE), and program faster — a demo shows 27 lines of SQL/Python vs 2 lines for a MongoDB update because documents map to data structures. Advises three shifts: embrace document diversity, store data accessed together, and avoid relying on multi-document transactions.

AI-written summary · about

chapters (7)

  1. 0:00Start
  2. 17:45Term Mapping Summary
  3. 22:27Pivot easier!
  4. 23:56Program faster!
  5. 31:14Embrace document diversity
  6. 32:11Data that is accessed together should be stored together
  7. 34:37Tread carefully with transactions

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.