Dealing with JSON in the Relational World
summary
Relational databases now include a native JSON type and SQL (since 2016) adds JSON functions, with a concrete comparison of formats: MongoDB streaming BSON keeps field order, MySQL BJSON and Postgres extensions trade off key sorting and duplicate-field behavior, while Oracle JSON binary adds versioning and client-side encoding. The demo shows a compatibility layer that runs MongoDB-style apps by switching a URL, and JSON relational duality views that map documents to tables for inserts, queries, and partial updates.
AI-written summary · about
chapters (19)
- 0:00Introduction
- 1:07JSON in relational databases
- 3:40Storing JSON in columns
- 7:55JSON data types and storage
- 11:06SQL standard support for JSON
- 13:13Binary JSON formats compared
- 20:18Binary JSON format details
- 24:11JSON document size best practices
- 24:53Programming language JSON support
- 26:41Document API and SODA
- 28:51MongoDB API compatibility
- 29:53Oracle in Docker
- 31:19Relational data for JSON duality
- 33:24JSON from relational data
- 35:52JSON normalization pitfalls
- 37:20JSON relational duality views
- 41:11Free Oracle resources
- 43:19JSON storage benefits and validation
- 45:04Oracle Docker limitations
related talks
51mDealing with JSON in the relational world
45mHow Well Do Relational Database Engines Support JSON?
44mWho is Jason, and what’s he doing in my database?
48mHow Well Do Relational Database Engines Support JSON?
15mPlug-and-Play for JSON and MongoDB Developers
50mSQL, JSON, and Java
29mRetire your tables. It's all JSON now.
01h 06mSQL ❤️ JSON: The Best of Both Worlds