Using MySQL Document Store with Node js
summary
Shows how to use Node.js with MySQL Document Store via @mysql/xdevapi and the X Protocol (port 33060), including connection pooling, sessions, and collection anatomy (id, doc, json_uncore_schema). Demonstrates CRUD: list 14,879 documents, paginate with limit/offset, select fields and sort, dot-path find and bound parameters, and modify/remove with required WHERE. Shows raw SQL using JSON_TABLE/JSON_OBJECT to aggregate 14 years of rounds (80 golfers) and surprisingly computes a best-nine total of 20.
AI-written summary · about
chapters (16)
- 0:00Introduction and speaker intro
- 1:09NoSQL vs relational databases
- 3:18What is MySQL Document Store
- 6:09Accessing MySQL Document Store
- 8:40Setting up Node.js connector
- 11:54CRUD API with find method
- 14:06Pagination with limit and offset
- 16:40Sorting and field selection
- 19:07Using WHERE clauses in queries
- 21:38Parameter binding and functions
- 24:28Grouping and aggregation
- 26:53Advanced reporting with JSON functions
- 30:47Adding documents to store
- 32:53Modifying and removing documents
- 33:58Resources and contact info
- 35:03Q&A and giveaway
related talks
26mUsing MySQL Document Store with Node.js
31mMySQL 8.0 Document Store - Discovery of a new world
26mMySQL Without the SQL -- Oh My!
28mJavaScript Mode and the MySQL Shell
50mMySQL 8.0: SQL and NoSQL Scalability
30mSponsored talk" MySQL 8 loves JavaScript"
46mFrom Tables to Documents -- Changing Your Database Mindset
24mState of the Dolphin