Flexible Data Schema in MySQL (JSON)
summary
Covers storing IoT sensor data in MySQL using JSON to handle changing schemas. Compares implementation options and JSON features in MySQL 5.7 and MySQL 8.0 for building flexible storage schemas.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 7:42Sensor data storage problems
- 13:21JSON in MySQL 5.7
- 20:20Query optimization with JSON
- 34:27JSON for complex data structures
- 45:07Q&A
related talks
30mJSON support in MySQL
44mAdventures in MySQL
50mMySQL 8.0: SQL and NoSQL Scalability
51mDealing with JSON in the relational world
58mMySQL 5 7 + JSON
29mRetire your tables. It's all JSON now.
29mHow De-normalizing Your Data with JSON Can Boost Query Performance
47mDealing with JSON in the Relational World
