Ben McKay

build great things…

  • Your System Isn’t Slow – Your Bottleneck is not Optimized

    I’ve been working on a fairly large ETL project with around 300B rows in a table and roughly 6TB of compressed data. I built the system using Laravel and came across some interesting technical challenges that I haven’t faced before. Honestly, I didn’t plan to write this, but after chatting with Ruben over at Spatie,…

  • MySQL Unique Index with NULL values

    I was working on a project recently that had to import multiple CSV files into a MySQL database. I was using Laravel and the Laravel-Excel package to try and accomplish this. I built the project out and realized that I was having some duplicate values show up even though I built a unique index based…

  • Use Multiple Versions of Node with Homebrew

    “It works on my machine”. I hate these words, but before I hear “containerization” I just want to keep things simple. Homebrew is great and simple. To start, we want to know what versions are on our system with Homebrew. The ones with green check marks will tell you what you have installed. I was…

As a software developer specializing in business systems, I play a crucial role in streamlining organizational processes.

By automating routine tasks, integrating disparate systems, and optimizing workflows, I help reduce operational costs and improve overall performance.

My work involves close collaboration with stakeholders to understand their business needs, translating these into robust, scalable software that drives success in a competitive market.

I will always be building something