The Stroz

Installing MySQL Innovation Release on a Raspberry Pi
Installing MySQL Innovation Release on a Raspberry Pi

A while back, I wondered if it was possible to run MySQL on a Raspberry Pi. Not only is it possible, but it is not as complicated as I expected. Read on to find out how.

Dec 07, 2023
6 minutes
Applying Database Migrations in MySQL HeatWave With GitHub Actions
Applying Database Migrations in MySQL HeatWave With GitHub Actions

In a previous post, I talked about how we can leverage GitHub Actions to automate running tests whenever a commit is made to a specific branch of a GitHub repository. In this post, we will discuss one way we can harness GitHub Actions to apply database migration scripts to a MySQL HeatWave Database Service instance running in Oracle Cloud Infrastructure (OCI).

Dec 03, 2023
7 minutes
Running MySQL Tests With GitHub Actions
Running MySQL Tests With GitHub Actions

Recently, I have been talking about how to write and run tests for Node.js code that interacts with a MySQL database. These posts have included details on how to use third-party libraries such as Testcontainers to run the tests in a clean database and Knex to manage database changes. Today, I will discuss how to automate running these tests using GitHub Actions when code is pushed to a repository.

Oct 04, 2023
9 minutes
Integrating DB Migrations Into Your MySQL Tests
Integrating DB Migrations Into Your MySQL Tests

In previous posts, I discussed how we can use Testcontainers to more easily test code that interacts with a MySQL Database and code that interacts with MySQL Document Store. In yet another post, I demonstrated how to manage database migrations using Knex. This post will show how we can leverage Knex to incorporate database migrations into our testing workflow.

Sep 21, 2023
15 minutes
A Tool For Poor Typists - SendKeys
A Tool For Poor Typists - SendKeys

Ask anyone who has had a conversation with me over IM or email, and they will tell you I am a horrible typist. I was never a great typist, but was much better in high school. After graduating, it would be about 13 years before I would need to type again. So, it was like learning all over again.

Sep 04, 2023
5 minutes
The Undefined Show - Coming Soon
The Undefined Show - Coming Soon

I would like each and every one of you to join me and my good friends, Todd Sharp and Ray Camden, when we launch our new live stream, The Undefined Show, on September 11, 2023 at 8:00 PM Eastern. We will discuss a broad range of topics, primarily related to tech, coding, developer relations, and anything else that comes to mind.

Sep 01, 2023
1 minute
Managing MySQL Database Changes with Knex
Managing MySQL Database Changes with Knex

As all developers know, one of the most critical parts of any project is tracking database changes (or migrations). These changes will likely need to be applied in a particular order, and they need to be applied to every environment in the development workflow. We should also be able to roll back these changes should things not go as expected. Knex (pronounced like konnex) can help us manage these migrations, roll back changes, and assist in applying them to different environments.

Aug 31, 2023
12 minutes
Writing Tests For MySQL Document Store Apps with Node
Writing Tests For MySQL Document Store Apps with Node

In a previous post, I talked about how we can use Testcontainers to help make it easier to write tests for Node applications that interact with a MySQL database. In this post, we are going to discuss how we can write tests for Node applications that interact with MySQL Document Store - again using the MySQL Module for Testcontainers.

Aug 23, 2023
14 minutes
Testing MySQL Applications With Node.js and Testcontainers
Testing MySQL Applications With Node.js 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 are going to talk about some of the difficulties that may be encountered when writing tests for database interaction and how we can use Testcontainers to mitigate those issues.

Aug 11, 2023
16 minutes
Moving MySQL Databases from Azure to OCI Using MySQL Shell
Moving MySQL Databases from Azure to OCI Using MySQL Shell

In a recent post I talked about how we can move data from MySQL running in AWS to a MySQL HeatWave Database instance running in Oracle Cloud Infrastructure (OCI) with just two commands using MySQL Shell. In this post, I will show how we can use a similar process to move data from Microsoft Azure to OCI.

Jun 30, 2023
6 minutes