MySQL 8.0 Document Store - Discovery of a new world
summary
Claim: MySQL 8.0 Document Store lets applications treat JSON collections like a schemaless document DB while still using SQL when needed. It ships with X Protocol and connectors plus MySQL Shell and imports Mongo exports — 25,000 documents imported in one command. Documents can be large — documents up to 1 GB — and the server exposes X by default — X Protocol on port 33060. It supports full ACID transactions on JSON, JSON_TABLE, CTEs, window functions, array indexes and JSON schema validation, and the demos show these features working end to end.
AI-written summary · about
chapters (20)
- 0:00Intro
- 2:10MySQL is the DBMS of the Year 2019 !
- 2:25Happy 25th Anniversary MySQL
- 3:03Web Applications 2000's
- 4:08Relational Databases . Data Integrity
- 4:43Web Applications current days
- 6:55Use Objects / Documents Developers want just to use objects
- 9:50How DBAs see data
- 11:55Using MySQL Document Store !
- 12:23A solution for all
- 14:12X Protocol Connectors
- 15:24Installing MySQL Document Store
- 18:08Let's make a query
- 19:28Syntax slightly different than MongoDB
- 20:48And for developers ?
- 22:14CRUD operations for collections
- 24:09Full ACID - Transactions support
- 25:59NoSQL or SQL You have the possibility to write clean and neat code
- 29:03INFO: JSON Notation Shortcut
- 30:25CHECK CONSTRAINTS MySQL 8.0 supports Check Constraints
related talks
50mMySQL 8.0: SQL and NoSQL Scalability
37mUsing MySQL Document Store with Node js
22mMySQL 8.0: an SQL+NoSQL database for microservices
34mMySQL 8.0 New Features
26mUsing MySQL Document Store with Node.js
24mState of the Dolphin
30mSponsored talk" MySQL 8 loves JavaScript"
26mMySQL Without the SQL -- Oh My!