Closed Thread Icon

Preserved Topic: PostgreSQL?? (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=21003" title="Pages that link to Preserved Topic: PostgreSQL?? (Page 1 of 1)" rel="nofollow" >Preserved Topic: PostgreSQL?? <span class="small">(Page 1 of 1)</span>\

 
butcher
Paranoid (IV) Inmate

From: New Jersey, USA
Insane since: Oct 2000

posted posted 12-02-2001 02:05

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-

mr.maX
Maniac (V) Mad Scientist

From: Belgrade, Serbia
Insane since: Sep 2000

posted posted 12-02-2001 10:51

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...


Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 12-02-2001 12:22

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...(

ian
Nervous Wreck (II) Inmate

From: Fresno, CA
Insane since: Jun 2001

posted posted 12-02-2001 20:33

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...

« BackwardsOnwards »

Show Forum Drop Down Menu