I'm in the midst of planning a large DB-driven site, and I've come up against the ever-intriguing Referential Integrity question. Now I'm trying to decide whether I should ditch MySQL for PostgreSQL ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...