Talk in English - US at Longhorn PHP 2026
Track Name:
Hill Country D
Short URL: https://joind.in/talk/a18b7
(QR-Code (opens in new window))
JSON is the data interchange format of choice. But its performance in a relational database is horrible. RDMS are built around standard data types such as INTERGERS and CHAR. There are many good reasons to store data in JSON in your database, but you give up many powerful features of SQL to do so. The answer is JSON_DATA(), which *temporarily* converts JSON to relational data types, unleashing Window Functions, Aggregates, and more. You will learn how to perform simple conversions with JSON_TABLE(), move on to working with embedded data, and handle missing data or errors. Finally, we will look at alternatives that can be faster, such as materializing the data or using other JSON functions.
Comments
Comments are closed.