MySQL or postgreSQL which is the best?

MySQL or postgreSQL which is the best?

[lisa leblanc]

I have to choose between these databases and I do not know which is the 
best. What do you think?
Lisa





_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

Re: MySQL or postgreSQL which is the best?

[earl]

Some say that if it's just a small scale database
then MySQL is the way to go but if you're planning
to put up a large database then postgreSQL is the answer.

----- Original Message ----- 
From: "lisa leblanc" <pinguinlinux@hotmail.com>
To: <linux-admin@vger.kernel.org>
Sent: Tuesday, December 10, 2002 10:00 PM
Subject: MySQL or postgreSQL which is the best?


> I have to choose between these databases and I do not know which is the 
> best. What do you think?
> Lisa
> 
> 
> 
> 
> 
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
> 
> -
> To unsubscribe from this list: send the line "unsubscribe linux-admin" in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at  http://vger.kernel.org/majordomo-info.html
> 

Re: MySQL or postgreSQL which is the best?

[Michael French]

    Depends on what you want to do.  Are you look to do something with
mostly reads and few writes, an even mix, or mostly writes?  For speed, you
can't beat MySQL so if you are going to be doing mostly reads (like a web
site), it works great.  For an application with a fair bit of writes, I
would go with Postgres just because it has some more advances features and
tends to scale better.  I know that Postgres just released a new version 7.3
(http://www.us.postgresql.org/) recently that is supposed to be pretty
slick.  MySQL has also fully integrated the InnoDB code which adds truly
ACID compliant transactions to MySQL as well as some other features.  They
are getting pretty close in features, but I would still seperate them by
speed and scalability.  I don't have a great deal of experience with either,
but at my last job we used MySQL to run our entire web site (a newspaper)
and never had any problems with it, even without the new feature set.  It
was mostly reads though, but very fast.  I put a couple of links in below.
First one is a comparison chart from a year ago.  Probably changed a little
bit, but will give you a good idea.  Second one is a Slashdot discussion on
the topic, see what others had to say.  Last is the link to MySQL's site for
the new 4.0 version and descriptions of the new features in the different
flavors.

http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html
http://slashdot.org/articles/02/09/23/1652243.shtml?tid=136

Cheers,

Michael French

----- Original Message -----
From: "lisa leblanc" <pinguinlinux@hotmail.com>
To: <linux-admin@vger.kernel.org>
Sent: Tuesday, December 10, 2002 10:00 PM
Subject: MySQL or postgreSQL which is the best?


> I have to choose between these databases and I do not know which is the
> best. What do you think?
> Lisa
>
>
>
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> -
> To unsubscribe from this list: send the line "unsubscribe linux-admin" in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at  http://vger.kernel.org/majordomo-info.html
>