On the Symfony Finland site they cover a recent announcement from MySQL about the release of their latest version: MySQL 8.0. In this post they cover some of the new features and performance improvements that come with this new version.
The MySQL development team has announced the General Availability of the MySQL 8.0.0 Open Source database.
This is the version following MySQL 5.7 that was released in late 2015 with interesting features like extensive JSON field support. Plenty of work has gone into this version as well and in an introductory post goes in-depth into all the enhancements.
The post includes a listing of eight topics (ironically) for the new updates including:
- Support for Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms (SQL)
- Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes, spatial indexes, and spatial functions.
- Remote management, Undo tablespace management, and new instant DDL.
- OpenSSL improvements, new default authentication, SQL Roles, breaking up the super privilege, password strength, and more.