I use MySQL for all my development, and I love it. It doesn't have some of the features that SQL Server or Oracle has, but it's certainly up to the task of most applications. It's blazing fast, it can handle huge databases, it's free, and the support is very good, because it's use is so widespread.
It's not an absolute SQL Server or Oracle replacement, but aside from some design issues on projects I've taken over, I've yet to run into a problem using it that I couldn't solve. The solution might mean breaking a subselect into two queries, or having to leave what would be STORED PROCs in the application code (in a stand-alone file, of course), but nothing that justifies the thousands and thousands of dollars that SQL Server or Oracle would cost. For users, SAP has partnered with MySQL, and Yahoo! Finance uses MySQL. There are many others, and while it might not be feature rich enough for every application, but it's definitely not just for mom & pop either. My $0.02, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 10:12 AM > To: CF-Talk > Subject: MS SQL Server vs. MySQL > > > Hey All, > > I'm not all that familiar with MySQL, but from what I hear it's > not as good > as MS SQL Server (which I use along with Oracle). > > I've tried using MyPHPAdmin to administer MySQL before and all I > can say is > it sucked eggs...security was confusing as all hell. > > The MySQL.com website says that upcoming features for version 5 include: > -views > -stored procedures > -triggers > -sub-queries > > Now if it's missing all that then what is it....Access on steroids?? ;-) > > Opinions please > > TIA > > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
