PHP MySQL WHY?

[smorrey]

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,tran sactions and all that jazz.

Thoughts?

[Erwin Moller]

sm*****@gmail.c om wrote:

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,tran sactions and all that jazz.

Thoughts?

Hi,

My thoughts?
Go Postgresql!
http://www.postgresql.org/
But you found that website already I guess. :-)

All Postgresql-functions in PHP work perfectly.
I'll never switch db as long as Postgresql is around.
It scales better, has LOADS more functionality, and is superrobust.
;-)

Regards,
Erwin Moller

[smorrey]

Actually I pretty much feel the same... My question I'm asking though
is why MySQL? I just get the feeling that with it's prevailance that I
must be missing something here, other than of course it seems to be the
defacto standard.

[windandwaves]

sm*****@gmail.c om wrote:

Actually I pretty much feel the same... My question I'm asking though
is why MySQL? I just get the feeling that with it's prevailance that
I must be missing something here, other than of course it seems to be
the defacto standard.

I think it is a chicken and egg situation with ISPs. They offered it,
because it was popular and it was popular because ISP offered it.

Well, that is my theory anyway. Everyone tells me that Postsomething is the
best DB out there. Hopefully MySQL will come to the play.

Cheers

Nicolaas

[Erwin Moller]

sm*****@gmail.c om wrote:

Actually I pretty much feel the same... My question I'm asking though
is why MySQL? I just get the feeling that with it's prevailance that I
must be missing something here, other than of course it seems to be the
defacto standard.

Hi,

Well, it has probably everything to do with the fact that mySQL was working
on M$ machines, and Postgresql was not.
So everybody coming from M$ world picked mySQL, and even if they used it on
a webserver that runs GNU/Linux, they wanted mySQL because they knew it
already.

But Postgresql has been ported to M$ as well now, and works good I heard.
(I didn't try the M$-Postgresql thought myself...)

About a week ago I discovered that MySQL doesn't support FK constraints, and
I asked a similar question in this ng: "Why is mySQL so popular? It doesn't
even support basic stuff like FK???"

One of the answers I received said that it is possible with mySQL, in
certain setups: INNO-DB-tables.

Anyway: mySQL is popular because it was running everywhere and was open
sourced. Postgresql didn't run everywhere. (I always wondered why anybody
would bother to run a webserver under W$, but that is beside the point
here.)

Regards,
Erwin Moller

[Colin McKinnon]

sm*****@gmail.c om wrote:

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?

I've been using MySQL for some time - it works. I don't have enough
experience with Postgres to criticise it - indeed it is offered as GPL
without restrictions (a lot of people ignore the exceptions in the MySQL
license) which to my mind would make it more approriate. I will say that
MySQL has been the most reliable DBMS I've used, and easiest to manage
(compared with Oracle, MS-SQLserver, Progress and Pencil). (I'm not wanting
to start a flame war here - this is my experience - not necessarily yours).

Is there an equivalent to phpMySQLAdmin for Postgres?

SQLite does not scale well.

C.

[Erwin Moller]

Colin McKinnon wrote:

sm*****@gmail.c om wrote:

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?

I've been using MySQL for some time - it works. I don't have enough
experience with Postgres to criticise it - indeed it is offered as GPL
without restrictions (a lot of people ignore the exceptions in the MySQL
license) which to my mind would make it more approriate. I will say that
MySQL has been the most reliable DBMS I've used, and easiest to manage
(compared with Oracle, MS-SQLserver, Progress and Pencil). (I'm not
wanting to start a flame war here - this is my experience - not
necessarily yours).

Is there an equivalent to phpMySQLAdmin for Postgres?

SQLite does not scale well.

C.

Hi,

I cannot restain myself, sorry.
But mySQL is the best db you ever saw?
Do you think it is better than Oracle?
Or MS SQLServer (one of the few good products BOUGHT by M$) ?
I really cannot agree.

I worked a lot with MS SQL Server. Only hit on 1 bug. Worked like a charm,
and the adminpanel is great.
Postgresql: My personal favorite: GPL, featurerich, robust, well documented.
Oracle: I worked (a little) with Oracle, which is intimidating to say the
least, but it is rocksteady, and very featurerich. You just need a
course/good book before you can start with Oracle without screwing things
up. :P

The only thing that speaks for MySQL is that is small, simple, and easy to
set up.
THAT is worth something, but really: It is not a very sophisticated DB.
And their licence is a little unclear to me. Not GPL.
No flame, or insult intented!
I just had to say this. ;-)

Regards,
Erwin Moller

[smorrey]

Yes there is a phpMySQLAdmin fo PostGres
It's called phppgadmin (not an typo, but it is a bit of a bitch to
type).

[Gary L. Burnore]

On Mon, 26 Sep 2005 12:20:14 +0200, Erwin Moller
<si************ *************** *************** @spamyourself.c om> wrote:

Colin McKinnon wrote:

sm*****@gmail.c om wrote:

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?

I've been using MySQL for some time - it works. I don't have enough
experience with Postgres to criticise it - indeed it is offered as GPL
without restrictions (a lot of people ignore the exceptions in the MySQL
license) which to my mind would make it more approriate. I will say that
MySQL has been the most reliable DBMS I've used, and easiest to manage
(compared with Oracle, MS-SQLserver, Progress and Pencil). (I'm not
wanting to start a flame war here - this is my experience - not
necessarily yours).

Is there an equivalent to phpMySQLAdmin for Postgres?

SQLite does not scale well.

C.

Hi,

I cannot restain myself, sorry.
But mySQL is the best db you ever saw?

Perhaps he meant best FREE db he ever saw? MySql works well for most
web apps. It's fast. It's free. Postgres is ok too. Lots of
postgres bigots out there. But if you're going to build an app based
on a free database, you'll choose the one that more people know about
and use. That'd be MySql right now.
Do you think it is better than Oracle?
Informix was better than oracle until IBM bought it to bury it.
Oracle has a better market share. That's why people use it.
Or MS SQLServer (one of the few good products BOUGHT by M$) ?

GOOD? Fool.

--
gburnore@databa six dot com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³ÝÛº ݳ޳ºÝ³Ý³Þ³ºÝ³Ý ÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³ÝÛº ݳ޳ºÝ³Ý³Þ³ºÝ³Ý ÝÛ³
DataBasix | ÝÛ³ºÝ³Þ³ºÝ³³ÝÛº ݳ޳ºÝ³Ý³Þ³ºÝ³Ý ÝÛ³
| ÝÛ³ 3 4 1 4 2 ݳ޳ 6 9 0 6 9 ÝÛ³
Black Helicopter Repair Svcs Division | Official Proof of Purchase
=============== =============== =============== =============== ===============
Want one? GET one! http://signup.databasix.com
=============== =============== =============== =============== ===============

[Gary L. Burnore]

On 26 Sep 2005 01:07:00 -0700, sm*****@gmail.c om wrote:

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.

Facinating.
--
gburnore@databa six dot com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³ÝÛº ݳ޳ºÝ³Ý³Þ³ºÝ³Ý ÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³ÝÛº ݳ޳ºÝ³Ý³Þ³ºÝ³Ý ÝÛ³
DataBasix | ÝÛ³ºÝ³Þ³ºÝ³³ÝÛº ݳ޳ºÝ³Ý³Þ³ºÝ³Ý ÝÛ³
| ÝÛ³ 3 4 1 4 2 ݳ޳ 6 9 0 6 9 ÝÛ³
Black Helicopter Repair Svcs Division | Official Proof of Purchase
=============== =============== =============== =============== ===============
Want one? GET one! http://signup.databasix.com
=============== =============== =============== =============== ===============