12 replies
From a pure cost standpoint, youre best going with open source....Linux OS, MySQL database, a Java application server like Tomcat, and Apache for your presentation layer.
The problem is that open source, while incredibly cost-effective....may cost you in terms of ease of installation and maintenance. Although Linux is definitely getting easier to install and maintain, it's definitely not as "user friendly" as Windows yet, especially if you are using strange hardware. Java is a wonderful, portable language.....but setting up and maintaining a J2EE environment is a lot of work and can quickly get out of control if you're not careful. MySQL is definitely cheaper than SQL Server and Oracle, but it lacks some of the advanced database features of those products.
I've been growing linux/mysql/apache setups on my windowsill. Dirt cheap, minimal maintenance, hugely reliable. Scalability achieved by just throwing another server into the setup and organising data so you have few if any cross database joins.
I found it very easy without any MySQL or Linux experience.
Of course that means no activeX or .net, but in my opinion that's a blessing. Used PHp and Perl to create pages. Knock them up in your favourite tool on a windows system (not FrontPage) and ftp them up to the server. Dreamweaver scores high, it costs a bit but the productivity enhancements should offset the cost easily. I use notepad and a Magazine copy of HotMeTaL Pro but the guys I work for squeeze their money real tight before they let go of it.
If you need Microsoft tech you are looking at windows though, you can still have a linux database. Indeed if you are planning on a good bit of traffic and some extensive database work, putting your database server on a separate machine is probably a necessity anyway.
If you use PostGreSQL, I'd be interested to know how you get on, I'm in full persuasion mode trying to get my firm to have a go at it at the moment.
Best O' luck.
by jaqui
is an enterprise class sql server, comapres very well with oracle and sybase in capabilities.
not as fast as mysql, but more secure in design.
it uses about 90% of the sql language.
( I haven't seen a single sql db engine that has 100% )
also, as it's under the bsd license, not the gnu-gpl, your company can market any apps created with it with no concerns over licensing issues.
by jdmercha
I'd need to consider more factors before deciding.
First off - Where does my expertise lie? Personally I know the MS products best. But am I alone or do I have another person with me that might know other products better? What are my personel resources?
Secondly - Can I leverage existing open source code? Do I have to develop my applications entirely from scratch, or is there existing code out there that I can borrow and modify? My platform choice may be swayed by the code I find.
Thirdly - How robust does the application need to be? How many users do I expect to attach to the database? How many hits do I expect on my website. If I'm not expecting many, I might go witih Linux/MySQL. If I expect more users I might then go with MS. But if I expect a ton of users I'd look at Unix/Oracle.
Fourth - What do I have for financing? Where can I adjust my finaces? What do I need most. another developer or more powerful hardware. I have to find the right balance. But financing comes last. If I can't do it right with the finaces I have, then I have to look for more money somewhere.
by jaqui
any full linux distro.
with apache webserver, postgresql, php.
or, for extra app security, xhtml calling a compiled c, c++ cgi for the processing.
then site variables and db data and app variables don't all get publicly exposed.
postgresql has better security features than mysql.
and all the software is free.
by dbest1
a standard distro install & google. Barely had to learn anything more than enabling PHP in apache and loading the packages to access mysql. Course my site is inside a DMZ, so I didn't have to put a great deal of effort into it.
Are you going to be able to do everything web wise as a static page or with server side scripting.
None of that 'orrible activeX stuff ?
by jdmercha
by jaqui
to start off, postgresql and mysql are almost identicle in usage with php.
( postgresqlconnect instead of mysqlconnect )
for configuring a linux box, I would recommend using either red hat or mandrake, as both are easier to install than debian, and if you choose php, apache, and either db engine, then they will be configured to run together automatically.
for ease of use mandrake is slightly better.
for corporate recognition rad hat is better.
( more hosting companies offer red hat servers than any other linux server )
madrake's control panel has full configuration wizards for all servers, allowing setting of domain name etc from a gui.
if you install webmin, then you can run it and actually administer a linux system over an https connection, full configuration tools, everything.
by fultonwilcox
Any technology that might be capable of turning a desktop in to an enterprise database will run an enterprise database very very well.
.Net, well it's an improvement on COM obviously. But it's means you have to use ms, you probably will buy in to the 'trusted' computing model. I'm very suspicious of running alien code on my systems, so I see little point in recomending a technology solution I find at best dubious.
No particular arguments against .NET inside a DMZ, or for server side productivity, nor for access as a desktop, but for an enterprise web/db server, total non-starter as far as I'm concerned.
It was why I asked the question, if the fella's already constrained by using ms technologies, then that will obviously have an impact on the design choices.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending