There's always the "in between" solution of PostgreSQL
(http://www.postgresql.org).
Hwrd
-----Original Message-----
From: Mike Sheldon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 1:29 AM
To: [EMAIL PROTECTED]
Subject: RE: Does CF have native support for MySQL on Linux?
The two databases are not comparable. MySQL is a fast, simple database for
those occasions where "down and dirty" is good enough. (Most cases, really)
Oracle is a monolithic product with two tons of functionality and all the
complexity that goes with it, and then some. Personally, I wouldn't use
Oracle for any but the largest, most complex projects (E-comm doesn't even
come close).
The question is, does MySQL have the functionality you need? It doesn't do
triggers, stored procedures, transactions or sub-selects. But, it is
screaming fast, lightweight and easy to deal with.
If MySQL doesn't cut it, then I'd look at PostgreSQL or Sybase. Both are
easier to manage than Oracle, and have all the functionality you will need.
Sybase has an advantage for MS SQL users, since the SQL syntax is nearly
identical. PostgreSQL has the advantage of price, it's free.
CF Linux Enterprise does have native Sybase and Oracle support. CF Linux Pro
does not have native database drivers. Truthfully, I would not spend the
extra money just for the native drivers. The only way I'd spend the money on
Enterprise is if I needed ClusterCats. (The Linux Enterprise version does
not have advanced security.)
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 17:16
To: [EMAIL PROTECTED]
Subject: RE: Does CF have native support for MySQL on Linux?
Is that as stable and effective as the native support built into CF or is
it better to use Oracle 8i?
At 05:14 PM 4/11/2000 -0700, you wrote:
>No, it uses an ODBC driver from Merant
>
>Michael J. Sheldon
>Internet Applications Developer
>Phone: 480.699.1084
>http://www.desertraven.com/
>PGP Key Available on Request
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
