Preserved Topic: PostgreSQL?? (Page 1 of 1)

I have just recently been reading a little discussion on another board about which DB is better, MySQL or PostgreSQL. The comments seemed to lean towards PostgreSQL (since version 7).

I did a search here and found only one brief mention of PostgreSQL, so I was wondering what most of you guys thought about it, and whether it is worth a better look and learning how to use with PHP.

Thanks

-Butcher-

Which database you are going to use depends on many different things. Here are just a few:

• For simple things using PostgreSQL would be overkill.
• Most web hosts have MySQL installed, you won't find many web hosts with PostgreSQL installed.
• MySQL is used more than PostgreSQL and therefore you'll find a lot of ready made applications with support for MySQL.
• Although some people say that PostgreSQL is better for big applications (i.e. a lot of data, a lot of persistent connections, etc.), MySQL can cope with all that and as a proof, just take a look at SlashDot, FreshMeat & Kuro5hin web sites, which have tons of visitors each day and all of them run MySQL.

There are a lot more differences, but as I like to say, use whatever gets the job done...

the web is a truly small place....
or maybe the kruro5hin crowd has grown so big, I run into them all the time! (and it sucks that it's down right now...(

I agree with Max for the most part.

Though, PostgreSQL does have its place. Especially in Mission-Critical situations.

Though, for all the situations in which you would want to use a database, MySQL is a no brainer pick over postgreSQL.

When you begin getting into transactions and rollback functionality, that's probably the time you want to start exploring PostgreSQL...