recommend PostgreSQL when a client needs stored procs udfs etc.
---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts
Doug White wrote:
> IMHO any software publisher that does not support MySQL is not worthy of
> 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]
