Troubleshooters.Com and Code Corner Present

Postgres Power

Steve Litt is the author of Troubleshooting Techniques of the Successful Technologist, Rapid Learning: Secret Weapon of the Successful Technologist, and Samba Unleashed.

PosgreSQL is the full featured database management system (DBMS) that ships with Linux. Features include unique fields, primary keys, null/not-null keys, check constraints (to implement business logic), and foreign keys, triggers and stored procedures.

The PostgreSQL Professional Database: Covers installation, setup, and use of Postgres, well up to the intermediate level.

Part II: PHP Tutorial: This PHP tutorial uses PostgreSQL as a database. Everything from from hello world web app to a fully functional data aware web app, and phplib installation.

Simple Postgres/Perl app: A simple web app using Perl and DBI::DBD. The article was written in 1998, so the Postgres setup is outdated. Use the The PostgreSQL Professional Database: article for postgres setup, and rely on the Simple Postgres/Perl app article for the web app.