Plus, on a side note, Slashdot also invested a lot of money into custom mods
on MySQL also.
----- Original Message -----
From: "Lawrence" <lkrubner@g...>
To: "professional php" <pro_php@p...>
Sent: Tuesday, April 09, 2002 1:23 PM
Subject: [pro_php] RE: Need DB reviewed (postgresql vs mysql)


> From: "Juliet May" <jmay@s...>
> > Does anyone else have any thoughts on postgresql vs mysql. I read an
article
> > comparing the two and it does seem that I will need some of the
> > functionality that postgresql has that mysql doesn't have yet. But I
don't
> > know enough about database programing or administration to know how
critical
> > these differences will be for me
>
> If your site is small and your information non-critical, then use MySQL.
If your site is large or
> your information is critical, then use PostgreSQL. MySQL is optimized for
speed, though, as Tim
> Perdue's article on PHPBuilder points out, MySQL dies under much lighter
loads than PostgreSQL. Of
> course, the same article points out that MySQL can withstand several hits
a second, it doesn't die
> till you hit a higher load, so you'd have to have a very busy web site
before PostgreSQL became the
> clear preference over MySQL. The other issue is data corruption.
PostgreSQL has more protection
> against certain kinds of data corruption. If you're running a business,
and you have to use Open
> Source software for some reason, then you definitely want to keep your
accounts in PostgreSQL. It
> would be madness to keep important financial information in MySQL. But if
you're running a magazine
> website, or a community website, or an online forum, then MySQL is fine.
>
> Tim Perdue's article suggested that MySQL had the advantage with many
sustained reads. That
> describes the average web site. But if you have workers interacting with
the database, employees of
> your company perhaps, or members of an online community, then PostgreSQL
might have an advantage
> with many writes. But PostgreSQL's advantages mostly appear at very high
volumnes.
>
> Personally, I think PostgreSQL is the better database for nearly
everything. MySQL's showcase web
> sites include Slashdot, and anyone who visits Slashdot much is aware of
how fragile and slow the
> setup is. It would probably run better on PostgreSQL/PHP instead of
MySQL/Mod_Perl . But for small
> sites, MySQL works fine, and the PHP community has more experience with it
than it has with
> PostgreSQL.
>
>
>
>
>