Deleting all existing comment author urls in WordPress using mysql command

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

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

last updated in Categories Command Line Hacks, Howto, Python


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.

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

last updated in Categories Reviews


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.