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

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.

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.

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.

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

I am speaking at the International JavaScript Conference at the end of this month in Brooklyn, NY.

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 first in a series where we will discuss window functions – including breaking down the syntax and using examples of different window functions.

If it seems like this space was neglected for a while, well…that is because it was.

This is the second part of a series of posts that will help us write better tests…and this one should seem kind of obvious - making sure we test every logical condition in our code.

This is the first part in a series of posts that will help us write better tests…and this is a big one for me - the use of static data in our tests. Keep in mind that while the sample code below is written in JavaScript, the concept would be the same in any language.