JSON in the Database, Let’s Play with That a Bit
summary
Shows how to store and work with JSON inside a database for PHP projects: discusses using JSON columns in relational databases, querying and updating JSON data, and practical manipulation techniques from within PHP. Covers concrete database features and PHP-side approaches for handling JSON payloads.
AI-written summary · about
chapters (9)
- 0:00Opening
- 1:05Relational databases
- 4:45Differences between databases
- 8:03Virtual columns
- 10:02Functions
- 11:33Other functions
- 15:20When to use JSON?
- 16:59Performance
- 18:10Questions
related talks
30mJSON support in MySQL
51mDealing with JSON in the relational world
47mDealing with JSON in the Relational World
42mHow to Store JSON in a Database Without Attracting the DBA's Attention
44mWho is Jason, and what’s he doing in my database?
29mRetire your tables. It's all JSON now.
19mJSON Support: news, non-news, and the bigger picture
14mJSON data structure – the hidden gem inside your database engine