How to generate tags for any project for navigating in VIM?

$ ctags -R

How to install jdk 6 on Ubuntu 11.10

$ sudo add-apt-repository ppa:ferramroberto/java
$ sudo apt-get update
$ sudo apt-get install sun-java6-jdk sun-java6-plugin

PostgreSQL cheatsheet

sudo apt-get install postgresql
# Install a pgadmin gui
$ sudo apt-get install pgadmin3

# Set a password to "postgres" database
\password postgres

# Create database
$ sudo -u postgres createdb mydb


# Create yourself a superuser database account
$ sudo -u postgres createuser --superuser $USER
$ sudo -u postgres psql

# Next change your password
$ psql
\password $USER


# Create a db with the same name as your login name
createdb $USER

# To create additional databases:
create database somedbname;


# To restart the server
$ sudo /etc/init.d/postgresql restart

# To show created table
\d tablename

# To show all tables
\d

# Quit
\q

# Help
\h AND \?

# Import sql from file
\i filename

# Show query buffer
\p

# Show databases
\l

# Show db permissions
\z

Hot to install rescuetime Linux uploader in Ubuntu 11.10

1. Download rescuetime linux uploader from here

2. Extract archive and go to the location in terminal

Next:

$ python setup.py build

$ sudo python setup.py install

Next you should be able to start it with

$ rescuetime_linux_uploader

I prefer to add it to startup applications.