10/3/2017 7:10:47 AM
Everything you need to know about MySQL 8.0
MySQL 8.0,Enterprise Database,MySQL Database
App Developer Magazine

Everything you need to know about MySQL 8.0

Christian Hargrave Christian Hargrave in Enterprise Tuesday, October 3, 2017

Database company, MySQL, has upgraded its offerings an a version 8.0 update.

The MySQL version 8.0 release candidate was announced in a recent blog post by MySQL highlighting all of the new features that are going to hit the books. First off, you may be asking yourself, “MySQL 8.0? Whatever happened to 6 and 7?” MySQL reports in the post that in order to avoid some confusion with previous alpha releases and MySQL Cluster, the company decided to skip 6 and 7 in favor for a new series of naming starting at 8.0. The theme for the new updates according to the database company is “making MYSQL better for modern apps.” And with UTF-8 encoding to come pre-packaged and ready to use out-of-the-box, it’s great to see MySQL getting some much needed upgrades.

Key new features in MySQL 8.0

Improved JSON Support:

- JSON Path expressions now support ranges.
- There are also some other optimization and performance improvements added in as well.

Document Store:

“The MySQL document store allows you to treat MySQL like a document database, with a set of NoSQL CRUD APIs to access your data. First introduced in MySQL 5.7, the document store now provides you with consistent reads-and-writes. This gives it a distinct advantage over other NoSQL databases, in that developers don’t need to give up transactional semantics. Data created in the Document Store can also be accessed via the regular MySQL SQL protocol.” describes MySQL in the blog article.

- Indexing capabilities for the new document store feature is also getting an improvement from previous 5.7 capabilities.
- Support for spatial indexing of GeoJSON data inside of a JSON document

CTEs and Window Functions:

- MySQL has implemented recursive queries or Common Table Expressions(CTEs) as well as Window Functions

Unicode 9.0:

- Unicode support has been updated to 9.0

Better Handling of Hot Rows:

- New Lock modifiers “SKIP,” “LOCKED,” and “NOWAIT” has been implemented.

Cloud Friendly:

“It is becoming more common for MySQL to be deployed in a virtual machine, where the amount of system resources can change as the system is scaled up or down. With the new innodb_dedicated_server option, it’s possible to auto-detect the system memory, and have MySQL adjust appropriately without having to edit configuration files.” says MySQL.

Get your Pi Day 2019 Shirt

Love Is Like Pi Never Ending T-Shirt Math Pi day Gift Shirt. Perfect Shirt to celebrate Pi Day 2019. Great gift whether you just love Math or you are a Math Student, Teacher or similar.

475 Tax Deductions for Businesses and Self-Employed Individuals

Are you paying more taxes than you have to as a developer or freelancer? The IRS is certainly not going to tell you about a deduction you failed to take, and your accountant is not likely to take the time to ask you about every deduction you’re entitled to. As former IRS Commissioner Mark Everson admitted, “If you don’t claim it, you don’t get it.

A hands-on guide to mastering mobile forensics for iOS and Android

Get hands-on experience in performing simple to complex mobile forensics techniques Retrieve and analyze data stored not only on mobile devices but also through the cloud and other connected mediums A practical guide to leveraging the power of mobile forensics on popular mobile platforms with lots of tips, tricks, and caveats.

Gps tracker for kids

The Chirp GPS app is a top-ranked location sharing app available for Apple and Android that is super easy to use, and most of all, it's reliable.

The Latest Nerd Ranch Guide (3rd Edition) to Android Programming

Write and run code every step of the way, using Android Studio to create apps that integrate with other apps, download and display pictures from the web, play sounds, and more. Each chapter and app has been designed and tested to provide the knowledge and experience you need to get started in Android development.