Need help with Linux + webserver + database decision

[rycamor]

As someone with a good knowledge of HTML, DHTML, Javascript (with a knack for scripting languages in general), who has used ASP and MSSQL in the past, now learning Apache, I am trying to decide which of the many Linux + webserver + database options would make the most sense. I am not just looking for 'easy', I want power, stability, scalability extensibility, etc... but I wonder which of the following would make the most sense given my present knowlege:<br>
<br>
- PHP + MySQL + Apache<br>
- Java Servlets + MySQL + Apache<br>
- Zope + MySQL<br>
- Zeus + (you name it)SQL<br>
- Roxen + MySQL<br>
- Any of the above with PostgreSQL, or other SQL suggestions?<br>
<br>
All help much appreciated<br>
<br>

 

[Damon]

I can't say that I have tried all of your combinations, but I do run PHP3 + MySQL 2.22 + Apache 1.3.6.<br>
In my opinion, this is an excellent combination for a number of reasons.<br>
1) MySQL is a very fast SQL server. (I shudder when I have to access our MS-SQL server)<br>
2) PHP3 has a very large library of C like functions, including some classes support, and integrates well with MySQL. One nice feature that is in development for PHP3 is the Zend compiler. This will allow for your php3 scripts to be compiled to a bytecode format, much like Java does, both increasing the speed of serving pages, and allowing developers to distribute compiled code. <br>
3) Apache is extensible through module programming. This allows you to customize the webserver to do almost anything you want. For us, this is a user authentication module we added that takes user information from, and logs to, the MySQL database.<br>
<br>
We run all o/s'es here, and the fastest and most stable for this configuration is FreeBSD 3.2.<br>

http://www.apache.org<br>

http://www.php3.org<br>

http://www.mysql.com

or

http://www.tcx.se<br>

http://www.freebsd.org<br>

 

[rycamor]

BTW, thanks. I tested PHP, MySQL, and Apache on Linux, but I finally had to try FreeBSD 3.2. While being harder to set up, it is definitely responding well on my test server (P100 with 32MB RAM).<br>
<br>
I also found a great tool for managing online databases: phpMyAdmin, which is a set of PHP scripts to let you manage your databases from a browser. (

http://www.phpwizard.net/phpMyAdmin/)

 

[slok]

I go for Apache with Java servlets... <br>
database will varies depends on project implementation..<br>
<br>
I will also throw in TCL/TK and Perl...<br>
<br>
These are in fact what I consider as CORE skills...<br>
<br>
I see Java and TCL as a necessity in my case cos<br>
building dynamic websites is not my main choice of<br>
projects... I'm looking at EAI...<br>
<br>
but if u are into websties and less EAI or<br>
less software engineering intensive projects..<br>
<br>
PHP.. gives good performance and ease of use combination<br>
<br>
Zope , Midgard (

http://www.midgard-project.org),

Locomotive<br>
and Enhydra are worth looking at...<br>
<br>
Zope and Enhydra in my opinion seems promising..

 

[cds]

need to check with tech@kisuu.com<br>
has the answeres but may charge for the service.<br>
<br>

 

[RustyNail]

check out the

http://www.postgresql.org

site!