PostgreSQL vs. MySQL: which is better for which use?

[ndee]

I only worked with MySQL so far but I'm interessted in PostgreSQL. Is PostgreSQL faster?

 

[SQL]

MySQL lacks a ton of features that PostgreSQL has...Foreign keys, triggers, stored procedures, etc. That is basically the argument that gets thrown around alot. As for speed, that is the one thing that MySQL always touts. But I've seen testimony that PostgreSQL is no slouch either.

Depends on the needs of your project.

 

[ndee]

Originally posted by: SQL
MySQL lacks a ton of features that PostgreSQL has...Foreign keys, triggers, stored procedures, etc. That is basically the argument that gets thrown around alot. As for speed, that is the one thing that MySQL always touts. But I've seen testimony that PostgreSQL is no slouch either.

Depends on the needs of your project.

Thanks SQL

 

[Apathetic]

The other biggie is full support for transactions. VERY important unless your DB will be read-only.


Dave