Talk in English - US at SunshinePHP 2017
Track Name:
Key Biscayne 1
Short URL: https://joind.in/talk/7b5a5
(QR-Code (opens in new window))
MySQL now has a native JSON Data type. So like an Integer or a character, you can store an entire valid JSON document in a column of a table in a MySQL database. Sure you could store JSON data in a text field but then you end up using Regular Expressions to search that data and who needs that aggravation? This session will cover how JSON information is store in an optimized binary format, functions you need to know to use that JSON data (How many email fields are in that JSON document or how to update information), the usages of generated columns that take information from JSON documents to materialize a column that is indexed for searching, and lots of programming examples.
Plus there is a new MySQL Protocol and X Devapi that allows you to use a MySQL database as a document store which means no writing queries, no structured query language, and the ability from your favorite programming language to do CRUD (Create, Replace, Update, Delete) directly.
Comments
Comments are closed.
Loved the practical examples for accessing the json data.
If the slide fonts had behaved I'd give it the full 5 thumbs up!
Very well done!
Good facts. Would have been a little better if there was more that wasn't just something out of the manual. Thank tho.