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.
Overview
Syllabus
Introduction
About MySQL
adjacentpath
sample data
SQL integration
Generated columns
Virtual columns
Virtual columns restrictions
Schemaless feature type
Updating generated columns
Index Performance
adjacentunquote
JSON Array
JSON Object
Replace
Jason Valid
Jason Valid Integration
Should we use it
JSON Flexibility
Denormalization
Happy Medium
Questions
Text Fields
Comparisons
Benchmark
JSON Object Limitations
JSON Path Operators
JSON Standardization
Taught by
PHP UK Conference
