Halfway there, still too far away (Weight loss journey 2021)

Back in February this year, I stepped on the scale and realized that I'm heavier than ever. I decided to make a plan to lose weight and to stick to it. To help with accountability I wrote a blog post to publicly announce this and even posted an update later on. It worked amazingly for two and a half months, but after going down from 108kg to almost 96kg something happened that stopped my progress...

Software selection for Linux in Q2 2021

With the release of Ubuntu 21.04, official support for fractional scaling was announced. I decided to do a fresh install on my desktop system to check out solely this feature. To speed up the post-install configuration phase and to score an easy blog post, I made a list of the software I use every day.

List all enabled products with no images in Magento 2 with this SQL query

Sometimes when you are working on a webstore, your client might ask you totally reasonable questions like how many products have no images uploaded. To answer this question is not so easy when there are 3000+ products in said shop. As the admin interface doesn't provide an easy way to check for thumbnail-less products, I had to turn to some SQL magic to answer the question.

Enabling Numlock and tap to click on the login screen of Zorin OS (and Ubuntu)

I don't have too many pet peeves, but a disabled Numlock is annoying as hell, especially if you type numbers a lot. It is also infuriating if you physically have to click the trackpad instead of just tapping lightly once you got used to this feature in Windows. When I used a Macbook Pro for a few months this has baffled me but I didn't realize you can enable tap to click in system preferences.

Force Janitor to work with your upgraded Kodi installation

Janitor is an addon for Kodi that will automatically scan your library for watched movies, TV show episodes and music videos based on criteria such as age, rating or free disk space. I set it up to delete what we already saw after 2 days except if it is in a protected folder. It is a great tool to free up disk space on your device, but if you upgrade to a version of Kodi that is not supported, it will be disabled and you will have to delete stuff manually again.