NoSQL doesn't mean No Schema

on YouTube ↗44m

" summary

Claim: NoSQL still has a schema and it belongs in code. Uses Python plus the jsonschema validator and BSON (Pongo) to embed a JSON Schema dictionary in a model class, raise exceptions on invalid instances, and run migration by introducing versioned classes and converting documents. Generates millions of documents to test performance (one aggregation once takes 15 minutes, prompting index or model changes). Outcome: validation and migration strategy works and prevents silent chaos. schema still exists json schema in code versioned class migrations

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 1:08What a schema really is
3. 5:41SQL vs NoSQL schemas
4. 8:11Schema in Python and NoSQL
5. 13:36JSON Schema as metadata
6. 16:47Use cases for schema design
7. 21:44Data validation before insert
8. 24:54CRUD with schema validation
9. 27:45Schema migration strategies
10. 33:01Schema must exist in code
11. 37:08JSON validation limits
12. 40:25Handling NoSQL updates
13. 42:12Discipline in schema usage
14. 43:20Sharing schema across apps

" related talks

• 01h 01mNoSQL: An AnalysisAndrew J. Brust · PASS Business Analytics Conference 2013
• 18mFrom SQL to NOSQL - a gentle intro for DevsJoe Karlsson · Conf42 JavaScript 2020
• 53mThe NoSQL Store everyone ignores: PostgreSQLStephan Hochdorfer · PHP UK Conference 2015
• 34mNoSQL Database Cloud Service: Most flexible NoSQL DatabaseDAVE RUBIN · Oracle DatabaseWorld 2021
• 01h 02mDesign Good Schemas - Get a Better DatabaseNuri Halperin · NDC Oslo 2023
• 45mSay YES! to NoSQL: A Guide on When to Ditch Relational DatabasesAdrienne Braganza Tacke · NDC Sydney 2020
• 46mFrom Tables to Documents -- Changing Your Database MindsetLauren Schaefer · NDC Oslo 2020
• 45mNoSQL Data Modeling for Front-end DevelopersStanimira Vlaeva · angularday 2021