Just to add some more mud to the water here, I am a user of SQL2000 server, as well as a user of MySQL, which will run just fine on either the Linux or Windows server family.
MySQL does not have all the functionality of SQL2000, however, much of that added functionality is rarely used for the average application, especially web applications. Also, there is am impending release of MySQL, that according to recent beta results, brings it well in line with the functionality of SQL2000, with such items as multiple primary keys, complex stored procedures, etc. The trade magazines that I receive, are publishing articles about how "mainstream" MySQL is becoming, and that Oracle and Microsoft are really taking notice. As far as web applications are concerned, the extensive use of stored procedures, can be a real PITA to get working the way you wish them, however on the other hand for internal applications, Stored procedures are very commonplace. My clients that use either database product, with a CF front end, seem to be quite happy with the performance. The generated server logs, seem to bear out the good performance of both. One trip-up some CF developers run in to is that when adding a record to any database must also add a record to the primary key field, because by its very definition, a Primary key will not allow duplicate records, which means that you cannot append a blank field. If an enterprise is really concerned about software pricing, I suggest they look into Microsoft's Action Pack subscriptions. Perhaps your applications can live within their licensing restrictions. ====================================== Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 ====================================== If you are not satisfied with my service, my job isn't done! ----- Original Message ----- From: "Ben Doom" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Saturday, June 07, 2003 11:18 AM Subject: RE: import | Actually, I was asking Jochem. | | >From your frustration with this, I could guess how you feel about MySQL. | :-) | | AFA MS SQL goes, I've learned this about MS: Their consumer products suck. | Their server products are OK. Their development products are pretty good. | I remember back in college, when I had to program in C to run on a Mac. | Everyone developed in MS Visual C++, then recompiled on Code Warrior for Mac | before turning it in. | | We've found MS SQL to be a pretty studly product with lots of useful | doohickies. There are a few things I would like to see different, but | what's perfect? Of course, the downside to it is the price tag. :-) | | | -- Ben Doom | Programmer & General Lackey | Moonbow Software, Inc | | : -----Original Message----- | : From: Dana Tierney [mailto:[EMAIL PROTECTED] | : Sent: Saturday, June 07, 2003 12:14 PM | : To: CF-Community | : Subject: Re: import | : | : | : I am not sure if you are asking me or Jochem (talk about a range of | : technical expertise! :) ) but my uninformed opinion is that the | : documentation for both is pretty murky. The new host has a nice front end | : for mysql which is why I went with that rather than SQL. Also, I dislike | : relying on m$ and if I really need to I can move mysql to my own computer | : and use it there, whereas I simply cannot afford SQL server. There is also | : a pretty helpful mysql user community (#mysql on efnet) even if some tend | : to play the geekier than thou game. I am not aware of anything similar for | : SQL server although that could merely be that I am not aware of it. | : | : Dana | : | : Ben Doom writes: | : | : > What do you prefer? | : > | : > We use MS SQL 2K here, but are looking into using MySQL for intranet | : > rollouts, so I'm curious as to your opinion. | : > | : > | : > -- Ben Doom | : > Programmer & General Lackey | : > Moonbow Software, Inc | : > | : > : -----Original Message----- | : > : From: Jochem van Dieten [mailto:[EMAIL PROTECTED] | : > : Sent: Friday, June 06, 2003 8:30 PM | : > : To: CF-Community | : > : Subject: import | : > : | : > : | : > : Dana Tierney wrote: | : > : > | : > : >And PS, Jochem, thank you for the mysql manual reference, I never | : > : >would | : > : >have found it because I was looking under "import" not "load" | : > : | : > : Just read it front to back. Even though I very much dislike | : > : MySQL, I have read large parts of the documentation because I | : > : anticipate that somebody will force me to use it in the future. | : > : (I ended up hating MySQL even more.) | : > : | : > : Jochem | : > : | : > | : | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
