Image

11

The MySQL Document Store

The MySQL JSON data type is extremely flexible. It may be a temptation for some to use the MySQL JSON data type by itself to provide an easy-to-use, schemaless data storage option. Simply having a table with one column, and that column being of type JSON, would be a very simple solution. Each row could have up to 1GB of JSON data. This idea is very close to the premise of the MySQL Document Store.

The MySQL JSON data type is the foundation of the MySQL Document Store. Relational databases need schemas and columns defined in tables before they can be used. But a document database enables developers to start saving and ...

Get MySQL and JSON: A Practical Programming Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.