First off....thanks everyone for your opinions...glad to hear them So far I'm not sold on MySQL simply because of what it lacks and MyPHPAdmin is junk IMHO (only security I could get workng was wide open to the planet or locked down so tight nobody could access...no even admin).
I'd like to hear more about MSDE...what exactly is it? what is missng from full blown MS SQL Server? what kind of interface (i.e. like Enterprise Manager)? I'd also like to hear more about Postgre(s)? It sounds as though it has the features MySQL is missing? Does it have a better/easier interface (more like Enterprise Manager)? What OS does it work on? Thanks again folks...great info 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: "John Paul Ashenfelter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 4:23 PM Subject: Re: MS SQL Server vs. MySQL > Actually, if you've outgrown Access and can't afford MS-SQL, MSDE is > probably a better answer since it saves you converting SQL twice -- once to > MySQL and once to MS-SQL down the road. > > Better plan is to code for the db you plan to use -- MSDE from the beginning > if you're heading for MS-SQL, MySQL if you want MySQL, etc. Database > conversion is a pain. > > Regards, > > John Paul Ashenfelter > CTO/Transitionpoint > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Massimo Foti" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, August 21, 2003 5:51 PM > Subject: Re: MS SQL Server vs. MySQL > > > > "Matt Robertson" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > Now if it's missing all that then what is it....Access on > > > > steroids?? ;-) > > > > > > Yes, precisely. All the basics and none of the fancy stuff, plus speed. > > > > Speed when you read data, on insert it can slow down quite a lot. I don't > > know about version 4.x, but older versions used to lock on write at the > > table level; totally insane in my opinion. > > > > It can also slow down developing since it doesn't enforce referential > > integrity and you have to do it on the application (same for cascading > > delete) > > > > > > > If you've outgrown Access and your budget is not ready for the MSSQL hit > > > then mySQL is a viable alternative. > > > > I really think that in this scenario Postgres is a much better > alternative, > > but maybe it's just me... > > > > ---------------------------- > > Massimo Foti > > Certified Dreamweaver MX Developer > > Certified Advanced ColdFusion MX Developer > > http://www.massimocorner.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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
