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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
