my 2 cents
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Cutter (CF-Talk)
To: CF-Talk
Sent: Friday, February 06, 2004 6:56 AM
Subject: SOT: MySQL and CF
Let me preface this by saying that I don't fault anyone for their
opinions. They are their opinions and as such deserve respect as such.
When speaking of the below scenario I can see (especially considering
the slow pace of mySQL dev in the past [which is no longer the case])
why someone may have thought along these lines.
Recently I was looking at evaluating a CF RAD tool under development (no
details yet, but I'll let you know if and when I'm able). The tool
looked like it would do all the things I wanted, yet I came to find out
it didn't support mySQL.
When I asked about this I was told that support had not been included
because a) mySQL didn't support foreign keys, and b) because of this
lack of functionality (and others) it "wasn't a serious database player."
I will post part of my response to this at the end of this message, but
my question for the community is this, how many of us here use mySQL? Or
have used it in a site they've developed for a client? How many passed
up using mySQL because of similar perceptions as those state above?
I'm not trying to start a debate or a flame war here, I'm just trying to
gage the perceptions out there in my fellow development community. I
know that there are quite a few people here that develop third party
apps for CF developers and I think it would be beneficial (for us all)
to see what the percentages might me on this.
Here is a snippit of my response:
"MySQL supports foreign keys when the table is of the InnoDB type (MySQL
supports several different engines). Support for this has been around
since at least 4.0, though I think it may even go back as far as 3.23.
The Alpha build of 5.0 was released this last month. E-week reported in
testing that it was incredibly stable and that the new addition of
stored procedure support was a major plus. As I understand it views are
to be supported possibly as early as 5.1."
Cutter
P.S. Anyone who may be looking for some good beginner information on
MySQL should check out the excellent book "MySQL Tutorial" by Luke
Welling and Laura Thomson. Though it only covers 4.x, it is very easy to
read and understand and provides short targeted tutorials for getting
yourself up and going. I've been working with MySQL for about 3 years
now and I've come to find I've only been scratching the surface of what
it's capable of.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
