The MySQL Document Store is a JSON based NoSQL database does not require the use of Structured Query Language (SQL) to interact with the database. No more embedding ugly strings of SQL in your beautiful PHP code. The new API calls (via the MySQL X Devapi PECL extension) follow modern programming design for all the CRUD functions of the document store. Each document has a payload of 1GB (compared to MongoDB's 16mb) and runs on proven, reliable MySQL technology. And if you have older relational data, the MySQL Document Store lets you access them plus the new document store data at the same time. This is a through introduction for those wishing to switch over to the MySQL Document Store with plenty of programming examples.

Slides at https://slideshare.net/davidmstokes

Comments

Please login to leave a comment

Really informative about the document store, how it integrates with the rest of MySQL, and how to use it.

Great talk!
Mr. Dave knows how to handle his crowd.
I enjoyed the talk, the fast paced info feed, the typos, the jokes.. anything but boring.

Rated 5

Dana Luther at 11:44 on 10 Feb 2019

Excellent information! I especially appreciated the info on how to set up the X DevApi and how to select information across tables and collections.

Rated 5

Ravi Gehlot at 11:59 on 10 Feb 2019

I loved this talk! Dave gave me some new info that I had no idea of before. I was like, wow...didn't know you could do that or wow..didn't know this was even available. Great info!. Thanks, Dave!

Hi Dave! Well, you brought the fun in your presentation while providing a useful introduction to MySQL 8.0. Glad I had the chance to meet you earlier in the vendor area, which only piqued my interest further in attending the talk. Making specific calls to the database through PHP is something I have limited experience with. Frankly, the SQL syntax is confusing and can be frustrating to work with at times. The version 8.0 update appears to add a lot more versatility and ease of use to interaction with MySQL.