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.

Revive an old laptop with Chrome OS

If you have been using computers for a few decades, there is a good chance that you too have a few old desktop and laptop computers collecting dust in your house. They are too old to use and have little value, so selling them is not a worthwile endevour. You can't even give them to family members as even they find them lacking in power. Have you tried to use a 10 year old laptop with Windows 10? Not fun... Wouldn't it be nice if you could magically make the old hardware more powerful?