The JSON data type and functions that support it comprise one of the most interesting features introduced in MySQL 5.7 for application developers. But no feature is a "Golden Hammer." We need to apply a little expertise to get the best result, and avoid misusing it. I'll show practical examples that work well with JSON, and other scenarios where conventional columns perform better.
Questions addressed in this presentation:
- How much space does JSON data use, compared to conventional data?
- What is the performance of querying JSON vs. conventional data?
- How do I create indexes for JSON data?
- What kind of data is best to store in JSON?
- How do I get the best of both worlds?
Bill Karwin has many years of experience as a database developer, consultant, and trainer. He published the popular book "SQL Antipatterns: Avoiding the Pitfalls of Database Programming." Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.