purchase. This especially as MySQL has evolved into a major player in the
Database market.
In my case, I originally had a copy of (name omitted) for eStore cart and it had
built in support for everyone EXCEPT MySQL. I was forced to hack the
application to create MySQL support and once that was done it worked pretty
well, that is until several Open Source eStore apps became available for the
Linux/MySQl platform.
Now, with the later releases of MySQL, it is again considered a major database
player, and we have also include support on our Windows servers as well.
In my opinion, PostGres is the best of all the open source databases, as being
scalable, fast, and stable, but few CF developers target that platform, while
the MySQL product is being increasingly requested by clients.Not everyone needs
Oracle functionality, including many that are using that platform, and most of
the pundits are now saying that MySQL is becoming a real competitor.
All this said, while our services include supporting the database product of the
client's choice, SQL2K if still by far the most requested.
======================================
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
======================================
Aspire to Inspire before you Retire or Expire!
----- Original Message -----
From: Cutter (CF-Talk)
To: CF-Talk
Sent: Friday, February 06, 2004 8: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]
