MySQL Without the SQL -- Oh My!

on YouTube ↗26m

" summary

Shows how to use X DevAPI over port 33060 to do CRUD on JSON collections, including transactions and generated _id handling; demonstrates a parallel bulk importer that loads 18,000 records (restaurant dataset) and BSON import/convert options; uses MySQL Shell (js/python/sql modes) and a document collection API (add, find, modify, remove) and then uses JSON_TABLE() plus window functions to compute top restaurants by cuisine, proving SQL analytics over schemaless JSON.

AI-written summary · about

" chapters (7)

1. 0:00Start
2. 1:16MySQL Community Edition
3. 1:46Relational Databases
4. 2:14Normalization constraints (foreign keys...) Atomicity, Consistency, Isolation, Durability
5. 10:19New Shell
6. 19:41More Sophisticated Analysis
7. 21:45Conclusion: What Do I Gain?

" related talks

• 37mUsing MySQL Document Store with Node jsScott Stroz · UtahJS Conf 2023
• 28mJavaScript Mode and the MySQL ShellDavid Stokes · OpenJS World 2021
• 45mMySQL Cookbook: Recipes for Your BusinessSveta Smirnova · Percona Live 2022
• 31mMySQL 8.0 Document Store - Discovery of a new worldFrederic Descamps · Percona Live Online 2020
• 45mMySQL Cookbook: Recipes for DevelopersAlkin Tezuysal, Sveta Smirnova · Percona University Istanbul 2022
• 26mUsing MySQL Document Store with Node.jsScott Stroz · DevWorld 2024
• 27mMySQL Shell: the daily tool for devs and adminsVittorio Cioe · Cloud Native & OSS Day Tel Aviv 2019
• 29mHow De-normalizing Your Data with JSON Can Boost Query PerformanceDavid Stokes · PHP UK Conference 2019