Re: MySQL versus Oracle

On Fri, May 31, 2002 at 08:40:51AM -0800, Gogala, Mladen wrote:
> I read few articles in Linux magazine and had it installed on
> my box for a while and here are my impressions:
>
> a) It's blindingly fast as a single user database, faster then oracle.
> b) 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).

It has all those (some under different names) and more.

> c) It's small. You can have both software and a small database within 150M
> d) 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.

There's a mysqlhotcopy script (I wrote myself) and there's now a BACKUP command in SQL.

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

There is a Perl DBI driver for MySQL and yes, it supports transactions (MySQL supports multiple table types, some of which support transactions).

MySQL is a fast moving target. August 2001 is a long time ago in it's history.

For example, the InnoDB table type now supports foreign keys.

Tim.

>
> > -----Original Message-----
> > From: Joe Testa [mailto:jtesta_at_dmc-it.com]
> > Sent: Friday, May 31, 2002 10:39 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: MySQL versus Oracle
> >
> >
> > Anyone on the list done a comparison(or worked with both) MySQL and
> > Oracle and can give me the good/bad points of My SQL?
> >
> > Doing interviewer thing and someone has My SQL who would like to move
> > into the oracle world and i know nothing about mySQL and am
> > wondering if
> > the transition from one to the other is easily done.
> >
> > thanks, joe
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Joe Testa
> > INET: jtesta_at_dmc-it.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: Gogala, Mladen
> INET: MGogala_at_oxhp.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: Tim Bunce
  INET: Tim.Bunce_at_pobox.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).