Скачать с ютуб You don't need NoSQL (use MySQL) в хорошем качестве

You don't need NoSQL (use MySQL)

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/the-mysq... 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