Skip to content

Practical JSON in MySQL 5.7

Photo of Ike Walker
Hosted By
Ike W.
Practical JSON in MySQL 5.7

Details

This month's presenter is Ike Walker, Database Architect at Flite.

Native JSON support is new for MySQL in version 5.7, but how much should we be using it? Is this merely an optimization for the JSON data that many of us have been storing for years in previous versions of MySQL, or is it time to consider expanded use cases for JSON in MySQL?

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. I will discuss several specific use cases.

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

------------- Logistics -------------

MIT's map with the building (E51) highlighted: http://whereis.mit.edu/map-jpg?selection=E5... (http://whereis.mit.edu/map-jpg?selection=E51&Buildings=go)

MIT's map with the Kendall square T stop highlighted: http://whereis.mit.edu/map-jpg?selection=L5... (http://whereis.mit.edu/map-jpg?selection=L5&Landmarks=go) (the stop is in red on that map, and you can see E51 in the bottom right)

MIT's maps with parking lot information: http://whereis.mit.edu/map-jpg?selection=P4... (http://whereis.mit.edu/map-jpg?selection=P4&Parking=go) and http://whereis.mit.edu/map-jpg?selection=P5... (http://whereis.mit.edu/map-jpg?selection=P5&Parking=go)

Note that MIT lots are free to park in after 3 pm or so, even if it says "reserved for faculty"

Free pizza and soda will be served, so please RSVP accurately.

To RSVP anonymously, please login to the Meetup site with the e-mail address "admin at sheeri dot com" and the password "guest". For more information, see: https://www.meetup.com/mysqlbos/calendar/

Photo of The Boston MySQL Meetup Group group
The Boston MySQL Meetup Group
See more events