Friday, June 12th
(All times US EDT, GMT-4. Time between talks is used for Q&A, discussion, wanton displays of old hardware and boxed Linux software hoarding, and breaks.)
6:00 - 7:00 PM: Dave Stokes - MySQL JSON Document Validation
JSON is a popular data interchange format and MySQL has had a native JSON Data Type for a few years. But until recently there was no way to make sure JSON data included required fields, data type checking, or range checking. But thanks to the JSON-Schema.org's designs, there is now a way to ensure that the JSON data going into your MySQL Database is correct. You will learn how to use constraint checks with the new JSON validation functions to catch bad data before it gets into your server.
Saturday, June 13th
3:30 - 4:30 PM: David Stokes - What’s New With MySQL
MySQL has been releasing new features each quarter for the past few years but do you know what is included in those releases? Well, this session will cover in reverse order the new features such as hash joins, dual password, multi-valued indexes, derived tables, and more. There is some really cool stuff that can save you a lot of grief if you know about them.