The Stroz

Retrieving Reference Lists - Using the Oracle Cloud TypeScript SDK Part 7
Retrieving Reference Lists - Using the Oracle Cloud TypeScript SDK Part 7

This post is the last in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically retrieve reference data that may be needed to manage MySQL HeatWave instances using the SDK.

Apr 04, 2024
7 minutes
Updating a MySQL HeatWave Backup - Using the Oracle Cloud TypeScript SDK Part 6
Updating a MySQL HeatWave Backup - Using the Oracle Cloud TypeScript SDK Part 6

This post is the sixth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically update data of a backup of a MySQL HeatWave instance.

Apr 02, 2024
6 minutes
Creating a MySQL HeatWave Backup - Using the Oracle Cloud TypeScript SDK Part 5
Creating a MySQL HeatWave Backup - Using the Oracle Cloud TypeScript SDK Part 5

This post is the fifth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically create a backup of a MySQL HeatWave instance and create a ‘waiter’ to indicate when the backup is complete.

Mar 13, 2024
8 minutes
Listing MySQL HeatWave Backups - Using the Oracle Cloud TypeScript SDK Part 4
Listing MySQL HeatWave Backups - Using the Oracle Cloud TypeScript SDK Part 4

This post is the fourth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to retrieve a list of MySQL HeatWave backups for a given compartment and how to narrow that list down to show only backups for a specific instance.

Feb 26, 2024
6 minutes
Waiters - Using the Oracle Cloud TypeScript SDK Part 3
Waiters - Using the Oracle Cloud TypeScript SDK Part 3

This post is the third in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to use waiters to asynchronously handle when MySQL HeatWave instance reaches a given lifecycle state.

Feb 19, 2024
6 minutes
Managing MySQL HeatWave Instances - Using the Oracle Cloud TypeScript SDK Part 2
Managing MySQL HeatWave Instances - Using the Oracle Cloud TypeScript SDK Part 2

This post is the second in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to retrieve information about a single MySQL HeatWave instance and how we can start and stop the instance programmatically.

Feb 16, 2024
8 minutes
Listing MySQL HeatWave Instances - Using the Oracle Cloud TypeScript SDK Part 1
Listing MySQL HeatWave Instances - Using the Oracle Cloud TypeScript SDK Part 1

This post is the first in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to retrieve a list of MySQL HeatWave instances for a given compartment.

Feb 14, 2024
7 minutes
Testing MySQL Applications With Java and Testcontainers
Testing MySQL Applications With Java and Testcontainers

Over the years, I have become obsessed with writing code tests. One big pain point with writing tests is testing code that interacts with a database. In this post, we will talk about some of the difficulties encountered when writing tests for database interaction and how we can use Testcontainers to mitigate those issues.

Dec 17, 2023
13 minutes
Parameterizing MySQL Queries in Node
Parameterizing MySQL Queries in Node

There are very few absolutes in software development. One of these would be “NEVER trust user input”. You should never run a database query involving user input without validating, sanitizing, and parameterizing the user-provided values. If you neglect to handle user input correctly, specifically parameterizing the data, your application will be vulnerable to attack from nefarious people. In this post, we will discuss how to parameterize user input in a Node.js application and how to use the SQL Template Tag module to make the process easier.

Dec 12, 2023
10 minutes
Capturing GPS Data on a Raspberry Pi and Storing It as JSON
Capturing GPS Data on a Raspberry Pi and Storing It as JSON

In a previous post, I showed how you can install MySQL on a Raspberry Pi. In this post, I will show how to capture GPS data and store that data as JSON in MySQL Document Store.

Dec 09, 2023
13 minutes