Vojtech's IT Blog

My macOS slowed down a lot recently, so I inspected all the running processes with the htop terminal command and I saw that 40-50% of CPU (on all cores) is eaten by mdworker processes.

Are you behind a company network (or VPN) that restricts access to Slack? Or does the company force you to install a custom root certificate in order for you to log into a certain Slack team using SSO? Here's a solution for you..

My girfriend's Macbook Air (2012) got very slow lately. Slow to the extend that it's not useful anymore. It just makes you crazy. The mouse cursor does not move smoothly - the latency is up to 1s - and it's almost impossible to navigate in the UI and click on anything. The whole OS experience is so bad, that my girlfriend prefers using Android mobile rather then dealing with Mac, even when she needs to reply on long messages. I need to fix this.

Git clone someone's Github Pull Request locally

SELECT * FROM table WHERE (col->>'field') IS NOT NULL;

The following script will help you change the owner of all tables and sequences in your Postgres database using the official postgres Docker image. It generates SQL with ALTER statements in the first postgres Docker container based on your DB tables and sequences and pipes the generated SQL to the second Docker container, where the modifications are run. export user="your_new_owner" export dbname="your_db_name" cat <