Author: Josh Sherman
-
Schedule queries with MySQL
While researching the most performant way to delete a high volume of rows in MySQL, I happened upon some syntax that I had never heard of before. This syntax allows you to run a query on a schedule, without the need of any external code. As a rule of thumb,…
-
Removing unneeded Firefox ESR language packs on Debian
I went to run an apt upgrade today and came to realize that I had over 60 language packs for Firefox ESR installed. Seems somewhere along the way I accidentally installed these language packs, or perhaps installed the meta package firefox-esr-l10n-all that pulls in every single language pack that’s available….
-
Fastify not working in Docker
I’ve been using Express since it’s inception and while I’ve never really had any issues with it, I’m also always up for messing around with something new. That something new (to me at least) is Fastify. A recent project of mine included building an extremely lightweight API to power some…
-
EmuDeck not working after renaming micro SD card
Recently, while cleaning up the SD card I use on my Steam Deck, I decided that the name “UNTITLED” wasn’t good enough, and that I would rename it to something more descriptive. What I didn’t anticipate is that all of my EmuDeck / Emulation Station games would cease to function….
-
Horizontal and vertical alignment with Scriptable
While I am a huge fan of widgets on iOS, most apps miss the mark in terms of what they offer via their widgets. Because I’m not one to settle, I have been on a quest to build my own widgets so that I can get exactly what I desire….
-
Wait for open port before running command
There comes a time in every software engineer’s life, when they need to run a command, but only after a port has been opened by a completely separate process. Sure, you could sit around and wait for the port to open up before running your command, but what’s the fun…
-
Enabling and disabling unattended upgrades on Debian and Ubuntu
The unattended-upgrades package on Debian is absolutely fantastic. It takes cares of the stable packages that can be installed safely automatically, leaving you with fewer manual upgrades that you have to deal with yourself. Sadly though, I ran into an issue recently where the unattended-upgrades script was running in the…
-
git error: path is unmerged
While attempting to update my dotfiles locally on my MacBook Pro, I ran into a bit of a dilemma with one of my files that I had edited but never committed. Not a big deal, I can just run git stash and apply the changes again later. No such luck…
-
Key is stored in legacy trusted.gpg keyring
One of the more noticeable things to come out of me switching from Arch Linux back over to Debian, is that I’m rarely running into any issues. Because I’m not running into any weirdness, it’s been at a detriment to my blog, as my time on Arch was a constant…
-
2.4 GHz devices with Eero Mesh Wi-Fi
I’m a big fan of our Eero Mesh Wi-Fi 6 setup, even with the subscription service that will probably eventually lead to replacing it with something that doesn’t have an up sell like that. It’s been one of the best setups we’ve had, handling both multiple story and single story…