One of the humbling things about working at Oracle with the
various MySQL personnel is that you are often blown away by
something one of them says or does. And that is on a
regular basis. In this case it is Dr. Charles Bell who gave
a great series of presentations last June at the Southeast
In particular he presented in a full formed state some ideas that had been rattling around in my skull (but no way near as coherent) on how to take advantage of the MySQL JSON data type. Below are his points from his slide deck. I was reviewing my notes from his presentation when I realized that this information really needs to be more widely disseminated. And I would like your feedback on these ideas?
1.. We can use a JSON field to eliminate one of the issues of traditional database solutions: many-to-many-joins
- This allows more freedom to store unstructured data (data with pieces …