Re: Feature comparison between Postgresql, Oracle and Mysql ?

Jan Gelbrich wrote:

> Hi,
>
> "Penang" <penang(at)catholic(dot)org> schrieb im Newsbeitrag
> news:2c89dd3e(dot)0209270151(dot)13e510d2(at)posting(dot)google(dot)com(dot)(dot)(dot)
> > Several years ago, someone did a feature-by-feature comparison of
> > postgresql, mysql and oracle and put the result on the Net.
>
> please, could You say if the URL is still alive and post it here ?
>
> >
> > That was several years ago.
> >
> > I wonder if anyone has done such a thing for the current versions of
> > postgresql, mysql and oracle ?
>
> ... comparing Biplanes with Triple7 ...
>
> >
> > If so, where ?
>
> ... I and some other people asked similar questions (Oracle vs. DB2) in this
> NG some time ago ...
> ... there was no reasonable answer. In this NG most are in favor of Oracle,
> of course.
>
> IMHO it just depends on Your targets for the database - and on Your pocket.
> MySQL is free and one of the *fastest* DBs. Oracle is one of the *safest*.
> Oracle and DB2 can store *Terabytes* of data - I doupt this for MySQL.
> PostgreSQL is coming closer to Oracle - Postgres´ P/SQL is almost identical
> with Oracles´ PL/SQL.
> Not sure how much data space PostgreSQL can store.
>
> This is just some overview.
>
> Maybe some others have more insight into it.
>
> Cheers
>
> Jan

The problem with such comparisons is that they are, by and large, marketing
fluff and little more.

For example ... how long would it take to make a comparison between Oracle's
security model and that of any other product? Are there equivalents to included
and excluded nodes? To profiles? To inheritable roles? To fine grained access?
To LDAP? To OS authentication?

There is a lot more to an RDBMS than just bytes and benchmarks unless the most
important thing you are storing is your mother's recipe for chocolate chip
cookies.

Daniel Morgan