I my self use MySQL but from the reading I've dun on this site as well as other sites it seems that most of you php gurus prefer PostgreSQL. I'm curious to know why.
I mainly prefer it for it's constraints, procedural language, and triggers.
Using foreign keys, you can delete a record in one table and postgres will delete any records in linked tables that reference that row.