Re: MySQL or Oracle

From: Leandro Guimarães Faria Corsetti Dutra <lgcdutra_at_terra.com.br>
Date: Fri, 08 Nov 2002 12:07:44 +0100
Message-ID: <aqg5u1$9jrg7$1@ID-148886.news.dfncis.de>

Jayne Heger wrote:

> I am just wondering what you all think of these 2 databases. In terms
> of their ability to support the relational model.

Being SQL, none of them support the relational model, but a very defective bags-based approximation.

> I am asking as I have used Oracle SQL*, but am going to be trying out
> MySQL phpMyAdmin soon.

Depending on how you used Oracle features, you might feel at a loss. MySQL isn't even SQL-89 Entry Level compliant.

You might want to consider other free SQL DBMS like PostgreSQL, or even a true relational system like Alphora Dataphor, even if it is not free.

Among the free systems, PostgreSQL is the one with the best relational pedigree, being a SQL corruption of old champion Ingres QUEL.

-- 
  _
/ \ Leandro Guimarães Faria Corsetti Dutra        +41 (21) 216 15 93
\ / http://homepage.mac.com./leandrod/        fax +41 (21) 216 19 04
  X  http://tutoriald.sourceforge.net./      Orange Communications CH
/ \ Campanha fita ASCII, contra correio HTML      +41 (21) 644 23 01

Received on Fri Nov 08 2002 - 05:07:44 CST