Practical JSON in MySQL 5.7 and beyond
In this session, I will discuss some of the practical uses of JSON in MySQL, focusing on version 5.7 but also discussing options for previous versions, and briefly discussing MySQL 8.0. I will discuss several specific use cases, as well as some JSON antipatterns that should be avoided. Some topics I will address: - The evolution of JSON parsing in MySQL: from stored routines to UDFs to native functions - Real-life use cases: Custom fields, flexible rollups, nested objects, etc. - The power of JSON + virtual columns - Storing JSON as text versus using new JSON data types - Read/write balance considerations - Disk storage implications - Indexing JSON documents in MySQL - Additional JSON features in MySQL 8.0
Database Architect, GitHub
Ike Walker is a Database Architect at GitHub. He has 16 years of experience with relational databases, and has been working with MySQL since 2006. Ike runs the Boston MySQL meetup, and holds a gold badge for mysql on stackoverflow.com.