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)
