MySQL 5.7 + JSON

MySQL 5.7 + JSON

Explore the new JSON support in MySQL 5.7 through this PHP UK Conference talk. Learn about the JSON datatype, functions for handling JSON documents, storage and indexing options, and performance benchmarks for various use cases. Discover how to combine NoSQL flexibility with relational database strengths, covering topics like adjacent paths, sample data, SQL integration, generated columns, schemaless features, and JSON arrays and objects. Gain insights into JSON flexibility, denormalization techniques, and practical considerations for implementation. Understand JSON path operators, standardization efforts, and limitations to make informed decisions about using JSON in MySQL projects.