With this work, MySQL continues to grow as a hybrid SQL/NoSQL DBMS, one that can offer the best of both worlds to application developers. Please stay tuned for additional news that ensures MySQL remains the most popular Open Source database for next-generation web, mobile, and Cloud based applications!
A big THANK YOU to everyone in the development team that made this happen!
- JSON datatype and binary storage format
- Server side JSON functions
- JSON comparator
- Expression analyser for Generated Columns
- B-tree index support on virtual generated columns
- Support SEs to create index on virtual generated columns
- B-tree Index Support on non-materialized virtual columns
- Don’t store virtual generated columns in database
You can see the initial blog posts covering this Lab release here:
- JSON Labs Release: Native JSON Data Type and Binary Format
- JSON Labs Release: JSON Functions, Part 1 — Manipulation JSON Data
- JSON Labs Release: JSON Functions, Part 2 — Querying JSON Data
- JSON Labs Release: Effective Functional Indexes in InnoDB
We Need Your Input
Please let us know what you think of these new JSON features! We’d love to hear your feedback!. What would you like to see added or changed? Did you encounter any apparent bugs or performance issues? Please let us know here in the comments, via a bug report, or a support ticket.
Thank you for using MySQL!