Re: Advantages of PostgreSQL over MySQL 5.0

Hello,

I have with great interrest been following this thread. We have a
(small) flame war in house about this and I'm very happy about all the
arguments I have seen. I'm a long time user of PostgreSQL (which possibly
makes me a bit biased ;-) ) and I think it's great. I'm not a big database
expert, but I try to make things as good and standard as I can.

In this respect I have 3 questions:

1) I wonder that no one has mentioned anything about security issues in
those two. I know that I'm a novice and that I didn't use MySql very much,
but it seems to me that the PostgreSQL security is much better than MySql
!?

2) I don't know the latest SQL standard (I did say I'm a novice), but how
close to some standard is embedded SQL in C in PostgreSQL, Oracle, and
MySql ?

3) We are using mambo (the homepage management system), which is based on
MySql. I would love to make it use PostgreSQL instead (to ease
maintenance, backup, administration, etc.) Does anyone know where to get
help/info on this ?

Thanks for a good product and a good discusion,

Leif

On Wed, 22 Mar 2006, Jimbo1 wrote:

> Hello there,
>
> I'm a freelance Oracle Developer by trade (can almost hear the boos now
> ;o)), and am looking into developing my own Snowboarding-related
> website over the next few years. Anyway, I'm making some decisions now
> about the site architecture, and the database I'm going to need is
> obviously included. If my site works out, I'm expecting reasonably
> heavy traffic, so want a database that I'm confident can cope with it.
>
> It is out of the question for me to use Oracle, although I am a
> (biased) 'fan' of that RDBMS. I definitely need to go for a cheaper
> route, and to that end I'm looking at either MySQL or PostgreSQL.
>
> Regarding MySQL, I've been put off by Oracle's recent purchase of
> InnoDB and realise this could badly impact the latest version of the
> MySQL database. I can almost hear Larry Ellison's laughter from here
> (allegedly)! I've also been put off by the heavy marketing propaganda
> on the MySQL website.
>
> Recently, I've been taking a look at PostgreSQL, and am very impressed
> by what I've read, although I've not yet investigated the database
> first-hand. To cut to the chase, I would be interested in anybody's
> feedback on the advantages that PostgreSQL has over MySQL.
>
> Also, I've recently read the "Inside MySQL 5.0" (marketing propaganda)
> document, and it makes the following claim:
>
> "With MySQL, customers across all industries are finding they can
> easily handle nearly every type of database workload, with performance
> and scalability outpacing every other open source rival. As Los Alamos
> lab (who uses MySQL to manage their terabyte data warehouse) said, "We
> chose MySQL over PostgreSQL primarily because it scales better and has
> embedded replication.".".
>
> If any PostgreSQL devotees on this group can comment on the above and
> its accuracy/inaccuracy, I'd really appreciate it.
>
> Thanks in advance.
>
> James
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>