MySQL's JSON Data Type & Document Store

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.