Using MySQL Document Store with Node.js

on YouTube ↗26m

" summary

Shows how to connect Node.js to MySQL Document Store over the MySQL X protocol, use the Node connector and a connection pool, call execute then fetchAll, and bind parameters for sanitized queries. Builds an Express REST API demo that lists documents, selects fields, paginates, and runs raw SQL with JSON_TABLE / JSON_OBJECT to compute aggregated analytics — e.g. summing lowest hole scores over 14,870 rounds — and it works.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 1:35MySQL Document Store
3. 3:00Anatomy of Document Store
4. 4:22Node.js connection
5. 5:24Demo setup
6. 9:22Basic document retrieval
7. 13:25Filtering and field selection
8. 18:49Raw SQL analytics
9. 23:23Document Store features
10. 24:04Resources
11. 24:48Q&A

" related talks

• 37mUsing MySQL Document Store with Node jsScott Stroz · UtahJS Conf 2023
• 31mMySQL 8.0 Document Store - Discovery of a new worldFrederic Descamps · Percona Live Online 2020
• 26mMySQL Without the SQL -- Oh My!Dave Stokes · Data Con LA 2020
• 28mJavaScript Mode and the MySQL ShellDavid Stokes · OpenJS World 2021
• 30mSponsored talk" MySQL 8 loves JavaScript"Sanjay Manwani · JSFoo 2018
• 50mMySQL 8.0: SQL and NoSQL ScalabilityVittorio Cioe · HighLoad++ Moscow 2018
• 44mMaking RESTful Web Services the Easy Way with Node.jsDan McGhan · QCon São Paulo 2018
• 29mHow De-normalizing Your Data with JSON Can Boost Query PerformanceDavid Stokes · PHP UK Conference 2019