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.
Many people close to me (and quite a few who are not that close) know that before I started my career as a developer I worked as a paramedic for almost 15 years. When my family and I left New Jersey in 2004, it was the first time in almost 20 years (dating back to when I was 16) that I did not have a job in the medical profession. I often get asked how I made the switch from being a paramedic to being a developer (a story I will share here at some time) as they seem to be drastically different careers. However, over the years, I have discovered that a lot of the skills I used as a paramedic I still use almost every day.
This is the first in a series of posts that will help ease the transition to TDD and how we can make sure we write tests that actually verify the code we write is correct.
I would like to welcome you to my little slice of the Interwebs.