Posted by John Murtari on 09/28/05 20:16

smorrey@gmail.com writes:

> I've been thinking on this long and hard, and I can't seem to come up
> with an answer on it.
>
> Why is it almost always assumed the MySQL will be the server for nearly
> any PHP app?
>
> Why is it MySQL and not PostGRES or SQLite?
>
> At this point the only reason I can think of is that MySQL has a much
> more friendly name. But is that really it?
>
> Is there some winning advantage that MySQL has over PostGRES that makes
> it the de-facto standard in the PHP world?
>
> Just curious, because I've been playing with PostGRES for about a month
> now and it seems to scale MUCH better than MySQL, what with
> clustering,transactions and all that jazz.
>
> Thoughts?
>

Actually, I think the clear reason was that MySQL had much
better performance than Postgres when involved in primarily read
operations from a database (which is a lot of web apps). Because
it was not as full featured as postgres (that is changing now), it
just ran faster with less overhead.

Admin also seems easier, MySQL for simple MyISAM tables just
stores DB's as a collection of simple files. It really does make
it easy for admin to shuffle things around if you have to (of course
that is lost if you opt for transaction and Innodb tables).

I'm sure someone will correct me, but I think the big
reason was admin simplicity and performance (usually a winning
combination!).
--
John
___________________________________________________________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/

[Back to original message]