MySQL and JSON

By Dave Stokes

Elevator Pitch

Need to store a JSON document in a database and be able to search through that document quickly? Or do you need to store data but lack any Structured Query Language skills? MySQL now has a JSON data type where you can store JSON docs in a column of a table and use the new X Protocol for a doc store.

Description

Need to store a JSON document in a database and be able to search through that document quickly? Or do you need to store data but lack any Structured Query Language skills? MySQL now has a JSON data type where you can store JSON docs in a column of a table. There are also supporting functions for this new data type plus you can use generated columns for SQL indexed searches. This session has many programming examples and will show you nest practices for using JSON plus it will explore the new X DevAPI for using MySQL as a document store from your programming language of choice without using SQL. You will walk out of this session fully empowered to use JSON with MySQL.