The latest from the MySQL community

In my last three posts, I discussed searching JSON array data, filtering JSON array data, and using the global Intl object when creating MySQL stored functions. These examples were relatively simple functions and, essentially, one-liners. In this post, I will create another stored function with more complex business logic. The Business Rules Let’s assume we have a requirement to return a given number of […]

The latest Episode of MySQL Shorts is now available! Check out Episode 62 on the MySQL YouTube Channel to learn how to create a stored function using JavaScript in MySQL HeatWave and MySQL Enterprise.

Episode #62 of MySQL Shorts in now available!

Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]

Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […]

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to the global Intl object in a MySQl stored function.

MySQL Server 8.4.0 LTS and 8.0.37 are now available for download and in the MySQL HeatWave Database Service. These are the latest General Availability (GA) releases as of April 30, 2024. New release model, first LTS Release In the summer of 2023, MySQL announced plans move to a new LTS and Innovation release model planning […]

MySQL Server 8.4.0 LTS and 8.0.37 are now available for download and in the MySQL HeatWave Service. These are the latest General Availability (GA) releases as of April 30, 2024.

MySQL Enterprise and MySQL HeatWave now support writing stored functions and procedures using JavaScript. In this post we show how to tap into the power of JavaScript to filter an array of objects based on the value of one of the properties of the object.

This story starts with a pull request for go-mysql to allow setting the collation in auth handshake that I was reviewing. The reason why the author wanted to do this is to speedup the connection setup as he has a latency sensitive application and a lot of connection setups and tear downs.

While looking at this I noticed that the collation would be stored in a single byte. However the list of supported collations shows collations with an ID that’s more than 255.

mysql> SELECT MIN(ID),MAX(ID) FROM information_schema.collations;
+---------+---------+
| MIN(ID) | MAX(ID) |
+---------+---------+
|       1 |     323 |
+---------+---------+
1 row in set (0.00 sec)

The …