Related Content
Resource Groups in MySQL 8 Resource Groups, a new feature in MySQL 8 for resource management, are used to define a group for a certain type of threads, and to allocate the resources that threads in a particular group may consume. This results in prioritizing the different groups of threads. |
||
Window Functions in MySQL 8 Window functions are a new feature in MySQL 8. While most functions operate only on the data pertaining to a single row of data, Window functions operate over a “window” of data when performing a SQL query, and also for each query row. |
||
Creating a New User in MySQL 8 In MySql 8, you may create a user that requires multiple authentication methods, uses a random password, with comments and attributes annotated with the user, and configured failed logins. |
||
Common Table Expressions in MySQL 8 Common Table Expressions (CTEs) are a new feature in MySQL 8.0 to simplify SQL code related to result sets generated by subqueries, offering a better alternative to derived tables. |
||
The New Data Dictionary in MySQL 8.0 The data dictionary tables do incur some operational and upgrade differences, but the benefits outweigh the overhead. |
||
MySQL 8.0.x Offers New JSON Features MySQL database supports a native JSON data type in addition to several JSON related SQL/JSON functions. In this article, we will discuss some of the new JSON features in MySQL 8.x. |
||
Sealed Classes in Java 17 Sealed classes are classes that permit only specific classes to extend them, as a result limiting extensibility. Sealed classes provide several benefits such as: additional modularization, could be used to develop internal classes, could be used to develop proprietary software. |
||
New JVM Features in JDK 11 Java SE 11 is a recent LTS (Long Term Support) version of Java. Java 11 has introduced several other (non-language features), some of which we’ll discuss in this article. |