MySQL & JSON

Speaker

davidmstokes's picture
Level: 
Beginner

MySQl 5.7 introduced a new native JSON data type so you can now store valid JSON documents in a column of a table in a MySQL database. This allows you NoSQL storage of data in relational database and the same data can be accessed via Structure Query Language (SQL) or as NoSQL simultaneously. This session will cover how to efficiently use the JSON data type, how to use generated columns to create SQL searchable indexes, and best practaces on when to use/not use JSON data. Also covered will be the new X DevAPI that empowers developers to use MySQL as a document store without having to know SQL.