RE: MySQL versus Oracle

MySQL is ANSI 88 compliant, so they claim. As far as ANSI 92, they mislead by saying they "Follow ANSI SQL 92 requirements"

Jon

-----Original Message-----
Sent: Friday, May 31, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

> It uses more or less standard SQL

It's still far from ANSI compliant. The biggest criticism/complaint from the user community is the lack of subqueries (or "subselects" in MySQL jargon). They say it's the highest priority enhancement. They said it would be implemented in version 3.5X. Then they said it would be in 4.0 which is not ready for production until this fall and will be almost a year behind schedule. Now they're saying it will be in 4.1 which at this rate will be the end of next year. Meanwhile, their manual states that they plan to be ANSI92 and ANSI99 compliant but they don't give any dates. But it's the fastest growing database so someday they may be standards compliant.

-----Original Message-----
Sent: Friday, May 31, 2002 10:41 AM
To: Multiple recipients of list ORACLE-L

I read few articles in Linux magazine and had it installed on my box for a while and here are my impressions:

1. It's blindingly fast as a single user database, faster then oracle.
2. It uses more or less standard SQL minus all the unnecessary functions like substr, decode, nvl and alike which nobody ever uses anyway (evil grin).
3. It's small. You can have both software and a small database within 150M
4. I didn't learn how to do recovery. It doesn't have hot backups. You have to shut it down to make a sensible backup.
5. It's easy to configure and doesn't have too many things to set up.

Allegedly, the present version (I did my dirty work back in August 2001) can use Perl as a scripting language, I don't know whether DBI/DBD is needed for that and it can cope with committs and rollbacks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Baker
  INET: jcb_at_netsec.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).