The Stroz

More JavaScript in MySQL
More JavaScript in MySQL

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.

May 14, 2024
6 minutes
Using the Global `Intl` JavaScript Object in MySQL
Using the Global `Intl` JavaScript Object in MySQL

As I mentioned in some previous posts, MySQ: HeatWave and MySQL Enterprise support writing stored functions using JavaScript. When I started playing around with this feature, I wanted to know how much support there was for global JavaScript objects. There is a lot of support for these, and in this post, we will talk about using the global Intl object.

May 09, 2024
5 minutes
Using JavaScript to Search JSON Arrays in MySQL
Using JavaScript to Search JSON Arrays in MySQL

A few months ago, it was announced that MySQL now supports writing stored functions and stored procedures using JavaScript. This post will discuss a case in which JavaScript searches values in an array. Please note that this functionality is only available in MySQL Enterprise Edition or MySQL HeatWave.

May 02, 2024
5 minutes
Filtering JSON Arrays with JavaScript in MySQL
Filtering JSON Arrays with JavaScript in MySQL

In my last post, I discussed using JavaScript to write MySQL stored functions that could search the values in a JSON array to determine if any of the elements matched a given value. In this demonstration, I will show how you can use JavaScript to filter the elements of an array and only return elements that match a value.

May 02, 2024
4 minutes
Viewing MySQL Document Store Queries in HeatWave Using Database Management
Viewing MySQL Document Store Queries in HeatWave Using Database Management

In a post from last year, I talked about how we can view the SQL queries that are run whenever we use the MySQL Document Store API to return JSON documents. If you did not know, when using the Document Store API, the commands are translated into SQL and executed against the database. Sometimes, it is helpful to view the queries to understand how the data is retrieved or manipulated. Now that Database Management in Oracle Cloud Infrastructure is available for MySQL HeatWave instances, I discovered a slightly easier method for viewing these queries.

Apr 30, 2024
4 minutes
Creating a MySQL HeatWave Replication Channel with the OCI CLI
Creating a MySQL HeatWave Replication Channel with the OCI CLI

This is the sixth (and final) post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a MySQL HeatWave inbound replication channel.

Apr 26, 2024
6 minutes
Creating a MySQL HeatWave Configuration with the OCI CLI
Creating a MySQL HeatWave Configuration with the OCI CLI

This is the fifth post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a configuration for MySQL HeatWave instances and how to create a new instance using this configuration.

Apr 18, 2024
12 minutes
Creating a MySQL HeatWave Read Replica with the OCI CLI
Creating a MySQL HeatWave Read Replica with the OCI CLI

This is the fourth post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. This post will discuss how to create a read replica of a MySQL HeatWave instance.

Apr 16, 2024
5 minutes
Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI
Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI

This is the third post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. In this post, we will discuss how to create a backup of a MySQL HeatWave instance and create a new MySQL HeatWave instance from that backup.

Apr 12, 2024
6 minutes
Listing and Updating MySQL HeatWave Instances with the OCI CLI
Listing and Updating MySQL HeatWave Instances with the OCI CLI

This is the second post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. In this post we will discuss how to list MySQL HeatWaves instances in a compartment and how to update some of the information pertaining to the instance.

Apr 10, 2024
10 minutes