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.

Monitor Linux CPU temperature, frequency, power in a graphical way

in Categories Command Line Hacks, Howto, Python last updated December 9, 2017


S-tui is a free and open source terminal UI for monitoring your computer. s-tui allows to monitor CPU temperature, frequency, power and utilization in a graphical way from the terminal. It is written in Python and need root permission to use the s-tui. It is useful for:

  1. Watch your CPU temperature/utilization/frequency/power
  2. See performance dips caused by thermal throttling
  3. No need to use X-server. Perfect for headless usage including Raspberry PI

Let us see how to install and use s-tui on a Linux based system.

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

in Categories Command Line Hacks, Howto, Programming last updated January 28, 2018

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.

How to colorizing cat command output or files using ccat app on Linux or Unix system

in Categories Command Line Hacks, Howto last updated August 30, 2017

The cat command (short for concatenate) is one of the most frequently used flexible commands on Linux, Apple MacOS X, *BSD (FreeBSD / OpenBSD / NetBSD), Unix-like operating systems. It is useful to display text files on screen, copy text files, combine text files, create new text files and more. If you cat command with colours, try ccat app.