Author: Josh Sherman
-
How to Delete from a Table with Foreign Key Constraints in MySQL
I hate foreign keys. They are rarely implemented properly, often times failing to implement cascading deletes and updates. Sure, the concept is sound, and relationships are the first letter in RDBMS, I personally avoid using foreign keys as I find the potential for orphaned data to be way more manageable. While I don’t use foreign…
-
Quick Guide to Boss Materials in Diablo IV
Updated for Season 6 and Vessel of Hatred Similar to my quick guide to mythic uniques (which aged like milk when they made things purple) I have memory problems when it comes to which bosses need which materials, and how many. Sure, I could look at the items to see where they are supposed to…
-
Targeting the Home Page with Google Tag Manager
Recently I was adding a code snippet to a website, with the explicit requirement to not include the code on the home page. This was being done via Google Tag Manager, and we already had some triggers in place to target the home page, great! Until I went to test, and it turns out the…
-
VPS Showdown – September 2024 – DigitalOcean vs. Linode vs. Vultr
Labor Day weekend, and I’m trying to drum up the inspiration to run some VPS benchmarks. I’m sticking to the theme of comparing like processors, of the AMD variety. I spun up 3 (or 4, more on that later) instances with each provider, all running Ubuntu 24.04 LTS. The results have been averaged, when applicable.…
-
Transferring Steam Game Save Data Isn’t Worth the Headache
My blog tends to be a collection of solutions for problems that I have faced. Today I had set out to write about transferring Steam game save data. I recently upgraded from my Steam Deck LCD to a Steam Deck OLED. Most games use Steam Cloud to sync the save data. I found that I…
-
How to Automatically Delete Old S3 Files Using Lifecycle Rules
Amazon Web Services block storage is still one of my go to backup solutions. My backups tend to be pretty small, so the cost is negligible. Over time though, the pennies start to add up. Once the cost gets to a couple of bucks, I go in and purge backups and the cycle begins anew.…
-
How to determine Intel CPU generation on Linux
Late to the party, I recently heard about the voltage issues that are plaguing 13th and 14th generation Intel processors. While I don’t have many systems with Intel processors, I was still concerned, especially since my home server has started to behave a bit more erratic in the past few months. Fortunately, it seems that…
-
VPS Showdown – August 2024 – DigitalOcean vs. Linode vs. Vultr
Gonna cut to the case this month, as I’m in the middle of mixing and mastering the final track of our upcoming EP. I’ve spun up 3 instances with DigitalOcean, Linode, and Vultr. Each one is in or around the New York / Newark area. They are all running some sort of AMD processor, hence…
-
Convert string to number with JavaScript
Been working through swapping a MySQL library recently to prepare for a major database upgrade. The old library would return the results from function like AVG and SUM as a number. The new library, not so much. MySQL natively returns those values as strings, which I can applaud the library for respecting. Coming from a…
-
How to Make Your WordPress RSS Feed Show Full Articles Instantly
Finally getting around to resurrecting my newsletter, I wanted to update my RSS feed to include the full text of my articles, so that the entire post will be included in the email. Fortunately, WordPress has an option for this, and it doesn’t even require a plugin to pull it off. Enable full text in…