chrome 2DFRuxe6qV 540x304 - How to install Gridsome on cPanel shared hosting

How to install Gridsome on cPanel shared hosting

Gridsome is a Vue.js static site generaqtor that requires yarn, nodejs and NPM in order to generate website files. I recommend using two separate devices, one on which you develop the site and another where it will bi published. But, if you for some...

what is php 3 1 540x304 - Tip: Storing MD5 Values (and other string/binary representations)

Tip: Storing MD5 Values (and other string/binary representations)

A common occurrence I have noticed in MySQL apps is that MD5 values are stored as 32 byte values rather than 16. Just to ‘rehash’, an MD5 value is a 16 byte hexadecimal value, typically used as a unique fixed-length signature of a...

what is nginx 540x304 - NGINX Configuration for Sendy

NGINX Configuration for Sendy

Having recently migrated from Apache 2 to NGINX (with PHP-FPM) for a site that included Sendy, I thought it would be worth posting the configuration required in order for it to work. Sendy natively has an .htaccess file and some simple rules in...

Google SEO 1 540x304 - Numbering Google Search Results

Numbering Google Search Results

Sometimes it’s convenient when looking at Google search results, to know the position in the ranking order for a particular URL or domain. You can use this link as a bookmarklet, and click on the bookmarklet while viewing Google search...

Cover Image by MilesAndryPrower on DeviantArt

Delete a bunch of rows from MySQL database without table locking

Running a DELETE FROM table query in a database with millions of records would lock the table and cause the website to halt. This is where LIMIT clause comes in handy. The following query will only delete the first 1000 rows that match: DELETE FROM...

git 540x304 - Delete Git Branches

Delete Git Branches

Below are some steps to clean branches from the git repository to remove the clutter. Delete a Local branch To delete the local branch in Git using the command, we can use one of the followings: # git branch -d branch_name # git branch -D...

what is cpanel 540x304 - cPanel Email Migration

cPanel Email Migration

The mail for an individual cPanel account is stored in /home/$username/mail/$domain/$mailbox/, while metadata for the account (mailbox passwords and quotas) is stored in /home/$username/etc/$domain/. For migrating a full domain to another...