Tag Archives: application

Useful way to practice SQL queries online in a web browser.

http://demo.phpmyadmin.net/STABLE/?pma_username=root. This is an online PHPMyAdmin installation that allows you to create databases and practice the administration of the PHPMyAdmin online for free. if you want to practice MySQL queries and do not want the hassle of installing a huge package like SQL server 2012 or MySQl; then this is perfect. MySQL underpins nearly all online websites so practicing and understanding how to create a simple database and tables is very useful. This will help you. Especially if you are on a `net cafè computer and it does not allow you to install any SQL software. The SQL DROP TABLE query is disabled; so you can not go on a deleting spree. But the ability to practice SQL on any computer connected to the Internet is a bonus. So give this a try and see if you like PHPMyAdmin or not.

The PHPMyAdmin screen.

The PHPMyAdmin screen.

The Gdevilspie utility.

How to open a window in the centre of the screen on Linux Mint 14.

If you want to be able to start a window in the centre of the screen without using Compiz, then the Gdevilspie utility will perform this task admirably. Firstly install this application using the command below. You do not need any extra PPA`s if you are installing this on Linux Mint 14.

john@adeptus-mechanicus ~ $ sudo apt-get install gdevilspie 
[sudo] password for john:
The Gdevilspie utility.

The Gdevilspie utility. ready to go.

After installation, go to Menu > Accessories > gDevilspie and start the application up. Then tick the “Start devilspie daemon automatically at login” box and then click start to start the Gdevilspie deamon. Click the Add button and name a new rule. Under the Matching tab, tick ‘application_name’ and type “Mozilla Firefox”, for example, in the ‘matches’ box. Under the Actions tab, tick ‘center’. Click the Save button, then your new rule will be in effect.

The Gdevilspie rules editor.

The Gdevilspie rules editor.

This will create a new rule that will make sure your Firefox window will always be in the middle of the screen when it is started up. The screenshot below shows how to define the rule that centers the window.

Centering the window.

Centering the window.

More information about this application:  https://apps.ubuntu.com/cat/applications/gdevilspie/.

Getting the clock speed of your machine using the dmidecode command.

Getting the clock speed of your machine using the dmidecode command for Linux.

This command-line example shows that we are using the dmidecode command to get the current clock speed for our machine. This also shows some creative use of the sed command to parse the output and change the “Current Speed” text string to “Clock Speed” just for fun.

root@deusexmachina:/home/neo# dmidecode | grep -m1 "Current Speed" | sed s"/Current Speed/Clock Speed/gi";

This is another way to retrieve this information, using cat to read the /proc/cpuinfo file.

root@deusexmachina:/home/neo# cat /proc/cpuinfo |grep -m1 "@"
model name	: Intel(R) Core(TM) i3 CPU         530  @ 2.93GHz

This command will show the maximum amount of Random Access Memory supported by your computers motherboard.

root@deusexmachina:/home/neo# dmidecode | grep -m1 "Maximum Capacity" | sed s"/Maximum Capacity/Total RAM Capacity/gi";
Total RAM Capacity: 32 GB