mysql

MySQL Workbench 8.0 MySQL Workbench 8.0 (8.0.11 rc, published on Thursday, 19 Apr 2018) Source: MySQL Workbench 8.0

MySQL 8.0: From SQL Tables to JSON Documents (and back again) One of the nice things about MySQL 8.0 is the ability to combine the relational and document models. As a developer, you can choose to work with traditional SQL tables, with schemaless JSON documents, or with both types at the same time.… Source: MySQL 8.0: From SQL Tables to JSON Documents (and back again)

MySQL 8.0 Regular expressions and character properties In MySQL 8.0 we have replaced the old regular expression library with the ICU regex library.  See Martin’s blog on the topic. The main goal is to get full Unicode support for regular expressions, but in addition we get a lot of neat features.… Source: MySQL 8.0 Regular expressions and character properties

New Regular Expression Functions in MySQL 8.0 In MySQL 8.0 we introduce the ICU library to handle our regular expression support. This library is maintained by the Unicode Consortium and is used on a wide variety on platforms. The reason we switch libraries is threefold: security, Unicode support and functionality.… Source: New Regular Expression Functions in MySQL 8.0

Partial update of JSON values MySQL 8.0 introduces partial update of JSON values, which is a nice performance improvement for applications that frequently update small portions of large JSON documents. Before, in MySQL 5.7, whenever you made a change to a stored JSON document, the full new JSON document would be written to the database, even if the update just changed a few bytes in the document.… Source: Partial update of JSON values