Setting up the ultimate automated home media center

Having a home media center is really handy. It can do a ton of things besides just storing and playing your movies and TV series. You can also use them as network-accessible storage or an automated backup system or can even set them up as emulators to play vintage arcade games. The really amazing thing is that you can automate some tasks that you didn't even know wanted to be automated. In this article, we will explore one such automated workflow.

How to free up disk space on Ubuntu when your root partition is almost full

Generally, it is a good idea to have a separate root and home partition, so when you decide to try a new Linux distribution or do a clean install, you can reformat the root partition without losing your personal data. With this method a few years back 8 GB was more than enough for the root partition, but now with the advent of Snap, Flatpak and other alternatives, even a 20 GB root partition can run out of space in a few months. Let's see how to clean up space on a modern Ubuntu-based distribution like Zorin OS or Mint...

11 things to do after installing Zorin OS 16

extremely clean, modern-looking Linux distribution based on Ubuntu. With the 4 different desktop layouts (with 4 more in the Pro version) it will be a familiar experience no matter if your last computer had Windows 7-10-11, macOS, ChromeOS. Version 16 based on Ubuntu 20.04.3 LTS just arrived a few weeks ago and you should really give it a try... and if you do, read on for some tips on how to make an awesome distro even better.

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.