Also, MySQL 8.0 added support for partial update for the JSON_REMOVE(), JSON_SET() and JSON_REPLACE() functions. New features added were Table and Aggregate Functions. We can expect a better performance for sorting and grouping JSON values. Moreover, some existing aggregate functions can now be used as Window functions such as SUM() and AVG().īetter JSON Support. Using MySQL 8 eliminates the need for an additional NoSQL database as it added some very impressive improvement for JSON. You can now make use of SQL Window functions. For each row from a query, perform a calculation using rows related to that row. The latin1 is no longer being used as the default encoding, replaced by UTF8MB4, which is much faster and more flexible. Some notable new features:īetter Unicode support.
More secure, more reliable, better JSON handling and Unicode support, SQL Window functions, and bunches of other performance improvements are being put together in this recent release for the most popular open source database, MySQL 8.0.
0 kommentar(er)
