Fix Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

Nov 22, 20211 min read

Most likely it's because your system shutdown unexpectedly Try postgres -D /usr/local/var/postgres You might see FATAL: lock file "postmaster.pid" already exists HINT: Is another postmaster (PID 449) running in data directory "/usr/local/var/postg...

Downgrade MariaDB using Brew

Sep 8, 20211 min read

After installing MariaDB 10.6+ I started getting errors such as: ERROR 4047 (HY000) at line 10: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE. I needed to go back to the previous version but it was not easier to do so ...

Downgrade MariaDB using Brew

Fix PyLint error, unable to import frappe in VS Code

Jul 30, 20211 min read

Error unable to import frappe in VScode Assuming that your project root directory is inside /apps/ and that's also where frappe app is located. create a .env file in your project root directory and then add PYTHONPATH=../frappe # your unresolved mo...

Fix PyLint error, unable to import frappe in VS Code

Secure Ubuntu server for non-root user using only SSH keys

Jul 20, 20211 min read

Here are the set of commands that you need to run as root on a new digital ocean droplet (assuming you have already setup root to have ssh access). This will setup mynewuser with passwordless sudo rights and the ability to ssh into the machine withou...

Secure Ubuntu server for non-root user using only SSH keys

Fix git not updating remote from remote on fetch

Jul 20, 20211 min read

You have cloned a repo maybe using shallow clone with git clone --depth <depth> <repo> implies --single-branch, But strangely when you are trying to fetch from remote, it's not working. To fix a local repo that's not fetching try: or git config rem...

Fix git not updating remote from remote on fetch

Get Country Flag using ISO Country Code

Jan 28, 20211 min read

Wouldn’t it be nice to be able to easily convert a regular ISO 3166-1 alpha-2 country code to its respective Unicode emoji flag? Here we go... 'GB'.toUpperCase().replace(/./g, (char) => String.fromCodePoint(char.charCodeAt(0) + 127397)); This will tu...

Get Country Flag using ISO Country Code