Re: PG vs MySQL - Mailing list pgsql-general

Marc,
I guess we both agree that postgress is in no way as popular with web
hosting companies as MySql (even though you know of 3 such providers
which most likely at the same time also offer MySQL), and I believe with
good reasons as it is more complex than MySQL and most of the
administrators and support stuff are not no dbas either.

I am in no way lobbying for MySQL as I also like to work with Postgres
and have used it for a few years now. It not only saved me and my
clients a lot of money by opting for Postgres instead of Sybase or
Oracle but it is also fun to work with it.

The argument for one or the other probably has been discussed here for
the past 5 years and most likely both dbs will at one point cover the
same functionality or really become specialized for a particular market
segment.

Uwe in a mail mentioned his so called "fake type of hybrid license like
MySQL". I wonder if postgres isn't following the same (natural) path (of
the money).

A



Marc G. Fournier wrote:

>On Mon, 29 Mar 2004, Alex wrote:
>
>
>
>>Frank,
>>pls. apologize. Maybe my description was not so clear. What I was
>>referring to was the fact that under MySQL you have more freedom to give
>>individual users of a shared server rights to create and manage their
>>databases In addition all databases are kept in separate directories
>>unlike postgres.
>>
>>
>
>Huh?  Each database under PostgreSQL is kept under a seperate directory on
>the server ... always has been that way ..
>
>As to the ability to create/manage their own databases .. pls elaborate on
>what issues you've had with this under PostgreSQL, as its a simple ALTER
>command to provide a user with both CREATE USER and/or CREATE DATABASE
>permisisons ...
>
>
>
>>MySQL is still the default database offered by any web hosting company
>>
>>
>
>No it isn't ... I can name three companies that offer PostgreSQL as a
>primary database, and at least one of them only has MySQL as a means to do
>migrations ... and those are just the ones that I know personally ...
>
>
>
>>and if Postgres wants to become the designated db engine for these
>>services or become the worlds no.1 open source db then i think lots of
>>things need to be done. Take for example the admin interface (MySQL
>>Administrator) for MySQL which is done very professionally or the ease
>>
>>
>
>Please provide some examples .. I know any attempt I've made to do
>adminstrative stuff under MySQL has ended in a headache, but I've been
>using PostgreSQL for almost a decade now, so I find PostgreSQL the easier
>of the two ...
>
>
>----
>Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
>Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>
>
>
>