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
Linuxfest.
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 …