Рет қаралды 74,218
To learn more about PlanetScale, head to 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:
* planetscale.com/learn/courses/mysql-for-developers/schema/json
* planetscale.com/learn/courses/mysql-for-developers/indexes/indexing-json-columns
Or some of our blog posts:
* planetscale.com/blog/indexing-json-in-mysql
* planetscale.com/blog/the-mysql-json-data-type
The SQL for the products table shown in the video is available here: www.digitalocean.com/community/tutorials/working-with-json-in-mysql.
---------------
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.gg/pDUGAAFEJx
• TikTok: www.tiktok.com/@planetscale
• Twitch: www.twitch.tv/planetscale
• LinkedIn: www.linkedin.com/company/planetscale