To learn more about PlanetScale, head to https://planetscale.com/youtube!

MySQL has first party support for JSON documents and it can be a really nice escape hatch from the rigid structure of a relational database.

To learn more, check out some videos from our free course:
* https://planetscale.com/learn/courses...
* https://planetscale.com/learn/courses...

Or some of our blog posts:
* https://planetscale.com/blog/indexing...
* https://planetscale.com/blog/themysq...

The SQL for the products table shown in the video is available here: https://www.digitalocean.com/communit....


00:00 MySQL supports NoSQL
01:15 When to use JSON
04:20 JSON versus TEXT columns
07:00 Efficient JSON storage
07:45 Creating JSON objects with SQL
11:00 Extracting JSON from the document
14:40 JSON arrays
17:20 Querying on JSON columns
18:50 Query an array's items
19:40 Indexing JSON documents
22:48 Generated columns
26:00 JSON blob storage
27:09 Making JSON invisible
29:00 Updating documents in place


Follow PlanetScale on social media
• Twitter:   / planetscale  
• Discord:   / discord  
• TikTok:   / planetscale  
• Twitch:   / planetscale  
• LinkedIn:   / planetscale