You are here: Re: PHP MySQL WHY? « PHP Programming Language « IT news, forums, messages
Re: PHP MySQL WHY?

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/

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация