I'm looking forward to such a discussion of MySQL, but I must say I don't see how admin tools will solve the lack of views, SPs, relational/FK support, and row locking issues Michael had mentioned. Perhaps you're instead addressing any assertion one may have that it lacks any admin tools out of the box? That's certainly useful. If so, no need to respond.
Actually, I've gone ahead and done some digging since that last note. There's a site devoted to the DBMS at www.mysql.com, and there's news there that the new 4.0 release addresses the row locking (http://www.mysql.com/products/mysql-4.0/index.html). Also, as for Views and SP's, they're supposedly coming in 4.1: Views: http://www.mysql.com/doc/A/N/ANSI_diff_Views.html SPs: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html As for FK's, it's there as of 3.23.44 according to http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html Looks like MySQL is shaping up to be a pretty cool alternative. Has anyone used it as an alternative? /charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Erik Fenkell Sent: Friday, February 08, 2002 4:14 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] "big picture" question Just a quick note on MYSQL. Administration tools, such as webmin or phpMyAdmin to name a few, provide the user with many tools to easily achieve desired results and provide superior administration ability. Erik -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of charlie arehart Sent: Friday, February 08, 2002 3:46 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] "big picture" question Michael, I'm sure Graham (and perhaps others) appreciated that complete answer. Frankly, I'd like to hear more from others on your points about MySQL at the bottom of your note: P.S. MySQL is a nice database, but it can't even compare with Access (or SQL Server) feature wise 1. No views <YUCK> 2. No relations/FK support <ARGH> 3. No stored procedures <sigh> 4. and more... (row locking is one I think) I've seen so many recent books and press about MySQL that I'm surprised to hear it has such limitations. Does anyone know if those have or will be overcome by subsequent releases? Also, Graham, you've been on the list a while so maybe I'm not telling you something you didn't know, but your original posting asked a lot of questions. Probably too many to expect a reasonable answer on a list like this. It's been my observation that on most lists like this, when you ask that much of people, you rarely get the response you'd expect. People are reading these amid doing other work. To get even as much as Michael offered seems a rarity. Just something to think about. /charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael She Sent: Thursday, February 07, 2002 11:04 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] "big picture" question Before you can answer what language to use, you have to choose which OS platform. Linux is FREE, but support is not. Hence you may need to pay a lot of money for a good admin. Windows is easy to administer than linux (relatively) but you'll incur higher start-up costs. I'm sure you can also find a decent Windows admin for a lower price than a Linux one. After you decide on the platform you can decide on the language: If the organization is non-profit PHP is definately a possiblity - however, I found that PHP is still a bit rough. I found that some functions are still too raw (ie URL redirection, and session management). Also with PHP you need to account for some security issues not present in ASP and CF. If you can't decide on what platform... ColdFusion is a good programming language. ColdFusion will run on a variety of platforms such as Linux, Windows and Coblat Servers!. That way you can easily port your application from one platform to the next : ) (This is gonna take some flak, but) ASP is a good compromise since it is "bundled" with Windows. Also, .NET looks really tempting with it's feature set. Another advantage of Windows is that you can go ASP, .NET, CFML, PHP, PERL or even Java. Another possibly solution could be a Sun Cobalt server? They're not too expensive, easy to maintain, and you can get a lot of software for it (PHP, ColdFusion, Java, etc): http://www.cobalt.com/splash1.html *I would avoid Lotus notes if possible*. In the future should they wish to deviate from Notes, it's all but impossible. There are some Lotus->ODBC bridges, but they cost money and to do a conversion will take a lot of time, money, and expertise. Development costs should be about the same for all languages (excluding licenses). .NET and Java will cost the most (being the most complex languages). An ASP programmer maybe a bit cheaper than a ColdFusion programmer since ASP more prevelant. Basically it's a tough choice: 1. Save Money - Go with Linux but you'll need to find a good administrator 2. For Easier Maintenace I would suggest Windows since it's easier to maintain than Linux (debatable... but probably true) - but you'll pay $$$ for it. 3. Go with a Cobalt Server - Cheap Low Cost Solution all in a box - it maybe limiting in the future. How about getting shared/paid hosting? That will only cost the organization $30 - $100+ per month depending on the requirements? P.S. MySQL is a nice database, but it can't even compare with Access (or SQL Server) feature wise 1. No views <YUCK> 2. No relations/FK support <ARGH> 3. No stored procedures <sigh> 4. and more... (row locking is one I think) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charlie arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Erik Fenkell" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charlie arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
