[TCLUG] moving away from oracle

Thu Apr 17 10:02:56 CDT 2003

It seems to me MySQL really shines as a dbms to backend your website if you
have very modest needs or maybe load out of Oracle or SQL Server into this
for use on the web to get around the internet connector fee of the
commercial dbms's.  MySQL was designed to be fast first anything else takes
a back seat to speed.  

-----Original Message-----
From: Glenn McDavid [mailto:gmcdavid at attbi.com]
Sent: Thursday, April 17, 2003 9:42 AM
To: tclug-list at mn-linux.org
Subject: RE: [TCLUG] moving away from oracle

On Thu, 17 Apr 2003 RWare at INTERPLASTIC.com wrote:

> Does MySQL have stored procs and sub queries yet?  Row level locking?
Last
> time I looked it didn't.  Postgres was miles ahead of it before as far as
> features and atomicity which Phil G writes a fair amount about.

I think this is decisive, if you actually have an existing body of PL-SQL
code to migrate.  Last I looked MySQL was lacking a lot of SQL features
that have been around a long time--stuff that I was using 10 years ago.
You are likely to find MySQL very frustrating in this situation, and
at best you will end up with a lot of kludgy code.  I don't know much
about PostGres, but the last time I checked it was a much more complete
SQL implementation.

Glenn McDavid
gmcdavid at attbi.com
gmcdavid at winternet.com
http://www.winternet.com/~gmcdavid/

_______________________________________________
TCLUG Mailing List - Minneapolis/St. Paul, Minnesota
http://www.mn-linux.org tclug-list at mn-linux.org
https://mailman.real-time.com/mailman/listinfo/tclug-list