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.

Prettify Ubuntu 20.04

The Unity desktop was quite a big step forward in usability and design back when it came out (at least in my opinion), but by the end of the decade, the reskinned Gnome 3 environment became quite dated compared to the competitors. There are things in both macOS (window decorations) and Windows 10 that I like way more, but I also want to keep Ubuntu for the speed and stability.

Using your Android phone as a webcam for Ubuntu 20.04 with DroidCam

During the current pandemic, the home office suddenly became the preferred mode of work. This, of course, caused a huge increase in webcam prices and shortages in supply. I ran into the same problem and my laptop camera was no viable alternative either with its subpar quality. Luckily, there is a way to use my better-than-average phone camera for conference calls with the desktop computer running Ubuntu.

Creating an installer for Windows from your JAR file to easily distribute your Java project

Your first Java project finally runs from the command line and you want to share it with your friends to show the spectacular progress you made. All you need to do is to create a compressed jar file and send it to them, right? Not quite as in case they have no Java Runtime Environment (JRE) installed or have a different version from the one you used, all they will get is a criptic error message.