Deleting all existing comment author urls in WordPress using mysql command

in Categories Command Line Hacks, Howto, Programming, Web Developer last updated December 23, 2017

I have like over 50k+ comments posted on this site. A commenter is allowed to leave their website or Github/Twitter URL in the comment section. Unfortunately, many websites are dead creating a mess. Many are just spam and nothing else. This is not good for anyone. Here is a quick way to delete all existing comment author URLs in WordPress using mysql command line option.

Book review: Mastering Vim Quickly From WTF to OMG in no time

in Categories Reviews last updated November 18, 2017


The vim editor is a free and open source text editor. It is a clone of vi text editor. Vim is extremely popular among the Linux, macOS and Unix-like system users. Vim has many commands. It comes with a pretty extensive built-in manual too. One might get lost in the built-in manual. Let us see if “Mastering Vim Quickly From WTF to OMG in no time” can help a new or experienced vim user to increase productivity.

Improve your bash/sh shell script with ShellCheck lint script analysis tool

in Categories Command Line Hacks, Howto, Programming last updated November 9, 2017

ShellCheck is a static analysis tool for shell scripts. One can use it to finds bugs in your shell scripts. It is written in Haskell. You can find warnings and suggestions for bash/sh shell scripts with this tool. Let us see how to install and use ShellCheck on a Linux or Unix-like system to enhance your shell scripts, avoid errors and productivity.