JSON has become the standard document interchange format over the
last several years. MySQL 5.7 added a native JSON data type
and it has been greatly enhanced with version 8.0.
But many in the relational world have complained the the NoSQL
approach does not allow you to have rigor on your data. That is
to make sure an integer value is really an integer and within
specified ranges or string of the proper length. And there was no
way to make sure that email addresses are not listed under a
combination of E-mail, e-mail, eMail, and eMAIL. JSON is
great for many things but traditional, normalized data was better
for making certain that your data matched what was
specified.
If only there was a way to enforce come rigor on JSON data! Or a
way to annotate (pronounced 'document') your JSON data. Well
there is. MySQL 8.0.17 has added the ability to validate JSON
documents against a schema following the guidelines of the …
Showing entries 1 to 1
Jul
22
2019
Showing entries 1 to 1