MySQL Connector/Net 8.0.8 released

MySQL Connector/Net 8.0.8-dmr has been released on July 12th
14 July 2017   1263
MySQL

MySQL is the world's most popular open source database. MySQL is a central component of the LAMP open-source web application software stack and other "AMP" stacks

The leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more, MySQL releases MySQL Connector/Net 8.0.8

As it is reported, the MySQL Connector/Net 8.0.8 is the fifth development release that expands cross-platform support to Linux and macOS when using Microsoft’s .NET Core framework.

According to MySQL, now,  .NET developers have an opportunity can use the X DevAPI with .NET Core and Entity Framework Core (EF Core)1.0 to create server applications that run on Windows, Linux and macOS.

Changes in MySQL Connector/Net 8.0.8 Changes in MySQL Connector/Net 8.0.8

MySQL Connector/Net 8.0.8 is also the seventh development release of MySQL Connector/Net to add support for the new X DevAPI, which enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

See the “Development Releases” tab to download MySQL Connector/Net 8.0.8.

What should we wait in MySQL 8.0?

Overview of upcoming "general" release of one of the most popular database
29 September 2017   981

MySQL, one of the most popular databases in the world, has recently released the MySQL 8.0 RC.

What's new in MySQL 8.0? 

So, main improvements and new features are:

  • First-class support for Unicode 9.0, straight out of the box.
    MySQL 8.0 no longer uses latin1 as the default encoding, to discourage new users from choosing a troublesome legacy option. The recommended default character set for MySQL 8.0 is now utf8mb4, which is intended to be faster than the now-deprecated utf8mb3 character set and also to support more flexible collations and case sensitivity.
     
  • Window functions and recursive SQL syntax, for queries that previously weren’t possible or would have been difficult to write.
    MySQL 8.0 adds window functions via the standard OVER SQL keyword, in much the same way it is implemented in competing products like PostgreSQL.
     
  • Expanded support for native JSON data and document-store functionality.
    MySQL 8.0 expands JSON support with better performance, functions to allow extracting ranges from a JSON query (such as a “top N”-type request), and new aggregation functions that let MySQL-native structured data and semistructured JSON data be merged in a query.

It's worth noting that MySQL is jumping several versions in its numbering (from 5.5), due to the fact that 6.0 being nixed and 7.0 being reserved for the clustering version of MySQL.

MySQL 8.0 release date

As we know, MySQL’s release policy is “a new [general] release every 18-24 months.” Last major release (MySQL 5.7) was at October 21, 2015, so we should wait for 8.0 version around October 2017.

Other features in MySQL 8.0

Other interesting changes planned for MySQL 8.0 are:

  • More options for how to handle locked rows, via the SKIP LOCKED and NOWAIT keywords. SKIP LOCKED allows locked rows to be skipped during an operation; NOWAIT throws an error immediately on encountering a locked row.
  • MySQL can automatically scale to the total amount of memory available, to make the best possible use of virtual machine deployments.
  • Indexes can be manually excluded from the query optimizer via the “invisible index” feature. Indexes marked as invisible are kept up to date with changes to tables, but aren’t used to optimize queries. One suggested use for this is to nondestructively determine if a particular index needs to be kept or no