Feature comparison between Postgresql, Oracle and Mysql ?

Feature comparison between Postgresql, Oracle and Mysql ?

Post by Pena » Sat, 28 Sep 2002 18:51:08



Several years ago, someone did a feature-by-feature comparison of
postgresql, mysql and oracle and put the result on the Net.

That was several years ago.

I wonder if anyone has done such a thing for the current versions of
postgresql, mysql and oracle ?

If so, where ?

 
 
 

Feature comparison between Postgresql, Oracle and Mysql ?

Post by Jan Gelbric » Sat, 28 Sep 2002 20:57:58


Hi,



Quote:> 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 ?

Quote:

> 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 ...

Quote:

> 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

 
 
 

Feature comparison between Postgresql, Oracle and Mysql ?

Post by Daniel Morga » Sun, 29 Sep 2002 01:18:00



> Hi,



> > 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

 
 
 

1. Feature comparison between Postgresql, Oracle and Mysql ?

Several years ago, someone did a feature-by-feature comparison of
postgresql, mysql and oracle and put the result on the Net.

That was several years ago.

I wonder if anyone has done such a thing for the current versions of
postgresql, mysql and oracle ?

If so, where ?

2. Cursor & Store Procedure

3. Oracle vs PostgreSQL vs MySQL vs mSQL : COMPARISON

4. Fiscal Year Reporting

5. RFC: PostgreSQL and MySQL comparison.

6. VB + SQL

7. Help !! What's wrong with my SQL statement?

8. PostgreSQL in Comparison to mySQL

9. Features comparison chart - oracle, sybase,informix, sql server

10. Feature comparison between Oracle 8 and SQLServer 6.5

11. Features comparison chart - oracle, sybase,informix, sql server