I recently started reading the the book Programming Boot Sector Games. To write my own test programs i needed to setup the asm-lsp.

While I understand the switch of Dash’s business model from a perceptual license to a subscription model, my usage and needs do not justify a subscription. Annoyingly the app always updates to the latest subscription version. You can disable this behaviour by selecting tiny checkbox on the update dialog and then skipping the update on the old version.

While the official approach in Joplin is to lower case all tags to avoid collisions I kinda like to have my tags capitalized. To automatically update all tags in the Joplin database follow these steps:

I tried forever to get internet access in my LXC container to work. It turns out the iptables was configure badly. The following command will fix the issue:

Usually I use a GPS tracker on my phone when taking pictures so that I can sync up the GPS data later. Every so often I for get to start the tracker and need to manually set the GPS data by hand. The easiest way I found was by using the exiftool. This is a command line tool often considered the swiss army knife of EXIF data. Below is the command on how to set the GPS data on some files. I also added -overwrite_original parameter to not have the tool create a backup file. To actually get the GPS coordinate data you can choose yout favorite online tool.

Every once in a while I need to find and delete some rouge queries in MySQL. Here is how to show the list of queries for the current users: