~/talk

Help! I Need To UnSQLize My Application

Talkat PyCon Italia 2023 · 2023-05-25..05-28· [databases]
slides:none on file

Shows how to convert relational schemas into MongoDB documents, including concrete patterns: use embedding for co-accessed data, avoid unbounded arrays (16 MB limit), and use the extended reference pattern to include ID plus denormalized name. Demonstrates joins with aggregation pipeline stages like $lookup/$match/$group, and notes transactional or two-step updates to keep denormalized copies consistent. Describes a relational migrator (ODBC→Mongo) that syncs data and cites a real migration of 20 terabytes from Oracle to MongoDB.

AI-written summary · about

  1. 0:00Introduction
  2. 1:15Agenda
  3. 1:50Whats a Nosql
  4. 2:23Whats a Document Database
  5. 4:07Traditional Data Model
  6. 4:53Document Database
  7. 13:07Aggregation Pipeline
  8. 14:10Joining Data
  9. 14:53Extended Reference Pattern
  10. 20:37Migration
  11. 22:52Recap
  12. 24:17Additional Resources
~/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.