DB

MySQL vs PostgreSQL

The default myISAM DB in MySQL doesn't support DB constraints. If you want constraints in your DB, you have to switch to InnoDB. Hence my vote goes to PostgreSQL.

Installing PostgreSQL

#apt-get install postgres

#chmod 666 /dev/null

#su - postgres

$echo > postgresql.conf

$mkdir data

$chmod 700 data

$export PATH=$PATH:/usr/lib/postgresql/8.3/bin

$initdb -D data

$postmaster -D data &

A common mistake is to forget the -i option to allow the postmaster to accept TCP/IP connections.