Help! I Need To UnSQLize My Application
summary
Shows how to move a normalized SQL schema into MongoDB by converting joins into embedded arrays or controlled lookups, using an aggregation pipeline to assemble documents, then writing them with insertMany; recommends aggregation pipeline for transforms, extended reference to keep author IDs plus duplicated names, and a computed counter updated via triggers instead of expensive counts. Mentions MongoDB Atlas for hosting, sharded clusters of replica triplets, and the new MongoDB Relational Migrator tool to automate schema and data conversion.
AI-written summary · about
chapters (9)
- 0:00Introduction and speaker intro
- 1:50Speaker background and contact
- 3:17SQL vs NoSQL and document model
- 9:57Data access patterns in NoSQL
- 15:18Benefits of document databases
- 21:15Working with MongoDB in code
- 27:58Migrating relational data to documents
- 39:32Summary and final tips
- 40:33Q&A session
related talks
30mHelp! I Need To UnSQLize My Application
29mSwitching to MongoDB: The challenges of translating database schemas
29mNoSQL to Distributed SQL: Best Practices and Lessons Learned by Helpshift
25mHybrid Applications with MongoDB and RDBMS
45mNoSQL Data Modeling for Front-end Developers
26mNoSQL Data Modeling for Front-end Developers
18mFrom SQL to NOSQL - a gentle intro for Devs
59mCommon Query Patterns in MQL (Mongo Query Language)