Postgres
From Docunext Technology Wiki
Postgres is a relational database management system. It is ACID compliant and has support for foreign keys.
It is popular with accounting packages such as LedgerSMB, TinyERP, and SQL Ledger.
I'm not too familiar with Postgres, as I've had a lot more experience with MySQL. One thing I like about Postgres is that it is totally open source, whereas MySQL is dual licensed, and the InnoDB backend which supports foreign keys is owned by Oracle.
Contents |
Installing Postgres on Ubuntu / Debian
apt-get install postgresql apt-get install phpPgAdmin
I followed two more steps - I read the postgresql + phppgadmin DEBIAN.Readme docs and added password capability to the postgres server, then disabled the extra security setting in phppgadmin config.inc.php file as described in the phppgadmin docs.
Other postgres .deb packages:
Examples
CREATE TABLE wwwneofilmzcom_config ( conf_name varchar(255) NOT NULL default '', conf_value text, PRIMARY KEY (conf_name) );