MySQL JSON Data Use Guide

Dave Stokes

Tuesday 24 October 2017 from 14:45 to 15:45

Talk in English - US at ZendCon 2017
Track Name: Artist E
Short URL: https://joind.in/talk/5d482 (QR-Code (opens in new window))

Avg. Rating

MySQL 5.7 provides a JSON data type. Previously you could store JSON formatted data in some sort of text field but then you would have to use REGEX which would reduce the quality of your work life, make your grumpy, and would be frustrated when you had to maintain it. Now you have over two dozen functions, can create materialized columns from JSON data that can be indexed for fast searchers, and can output data in JSON. This is a quick introduction for PHP developers to learn to incorporate this new data type with plenty of programming examples.

Comments

Comments are closed.

John Fansler at 15:16 on 24 Oct 2017 (via Web2 LIVE)

Good overview of these new features - I look forward to trying generated columns and getting more into the JSON functions!

Robert A Engel at 16:12 on 24 Oct 2017 (via Web2 LIVE)

Great to have a look at the power of JSON with Mysql, and some new features coming in 8.0... Bash completion!!!

Alex Vinot at 08:34 on 26 Oct 2017 (via Web2 LIVE)

good stuff

Jason Davis at 12:34 on 31 Oct 2017 (via Web2 LIVE)

Loved seeing examples