The Stroz

MySQL Document Store is a ‘NoSQL’ solution built on top of MySQL. Last month, I gave a talk at THAT Conference about using MySQL Document Store with Node.js. During that talk, one of the attendees asked if it was possible to see the underlying queries executed when we use the CRUD API in Document Store.

Feb 02, 2023
8 minutes

Database indexes are used to help query performance. Database indexes typically contain information about data in a specific column of the database table. With the introduction of functional indexes in MySQL 8.0.13, we can now create indexes based on the result of an expression or function.

Jan 12, 2023
3 minutes

Storing JSON in a relational database is something developers have done for quite some time. There are a variety of reasons why you would want to store JSON in a database table - user preferences and configuration data are two good examples. The JSON Data Type was introduced to MySQL in version 5.7.8. This data type allows us to store valid JSON in a database column and run queries based on the values in the JSON.

Jan 10, 2023
7 minutes

MySQL Shell is a powerful way to connect to and manage MySQL instances. Connections can even be made to servers that are behind an SSH connection. In this post, we will discuss how to extend and customize MySQL Shell so that it is easier to initiate those connections.

Oct 17, 2022
7 minutes

MySQL Document Store is a JSON document storage solution built on top of MySQL. One feature of MySQL Document Store that can help speed up searches is the ability to create indexes of data contained within our JSON documents. In this post, we will demonstrate creating an index and look at the changes made to our collection after we create the index.

Oct 07, 2022
6 minutes

MySQL Document Store is a “NoSQL” database built on top of MySQL.

Sep 22, 2022
9 minutes

As I mentioned in my last post, I am a big fan of MySQL Shell. Until recently, I have only used MySQL Shell to connect to a local instance of MySQL running on my development machine.

Sep 12, 2022
3 minutes

Yesterday, my colleague, Fred (AKA LeFred), shared a blog post that discusses setting up aliases that allow us to run MySQL Shell when we enter mysql at a command prompt.

Sep 09, 2022
2 minutes

First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can also be a little intimidating when you first start using them. This post is the second in a series where we will discuss window functions – including breaking down the syntax and using examples of different window functions. All the code examples in this post use the database table and data we created in Part 1.

Sep 08, 2022
8 minutes

I am excited to announce that I am speaking at All Things Open this year.

Sep 06, 2022
1 minute