As you may have noticed, MySQL 8.0.16 has been released today !
One of the major long expected feature is the support of
CHECK contraints .
In this post, I wanted to show how we could take advantage of this new feature to validate JSON values.
Let’s take the following example:
So we have a collection of documents representing rates from a user on some episodes. Now, I expect that the value for the rating should be between 0 and …[Read more]