Which language is best for writting CGI?

Would anyone tell me which language is convenience and good for writing CGI in UNIX?  Perl5 or Mini-SQL(Lite) or...
Also which language is good for this in NT server?
Please give me more details.
Thanks.
 
KennonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MasseyMCommented:
If you are using an NT server, you can use VB CGI. It is very fast and works well in the NT environment.  But, I reocmmend using ASP if you can in the NT environment.  It is quick and was designed to be easily implemented with thte IIS server.
0
KennonAuthor Commented:
How about in UNIX?
I want to get more information about this in UNIX server than in NT.
0
phutsonCommented:
With as much documention as there is out there and as much free code (not to mention the support here) I would use perl with mSQL.
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

jhanceCommented:
The "best" is hard to define.  So much depends on what you are trying to accomplish.

Here is my assessment:

First, the FASTEST way to accomplish any of this on NT Server with IIS is not with cgi but with ISAPI.  This pretty much requires either VC++ or VB but for high performance, you need it.

CGI, obviously can be done using any language that runs on NT Server, This includes PERL, C++, VB, Java, etc.  Perl is best for "quick & dirty" jobs although many huge web sites have been done with it.  It's biggest advantages are ease of programming and portability.  It's biggest drawback is performance and use of server resources.

VB and Java suffer from most of the same drawbacks as PERL.  Both are big and relatively slow although VB is getting better.

VC++ is probably the fastest method for cgi programs but at a cost of more difficult development.


0
KennonAuthor Commented:
phutson, can u tell me more about getting the information of Perl msql and where can i find the free code?
0
phutsonCommented:
the instructions for getting perl can be gotten at perl.org can be aquired from
http://www.perl.com/pace/pub/perldocs/latest.html
perl is usually available on your host (I have yet to find one that doesn't have it)
mSQL can be found at
http://www.Hughes.com.au/

0
hitzeuCommented:
You can use any programming language that can write / read from STDIN. Why not use Unix/Linux with the Korn-Shell. If you want to access databases, you should use C(++)
0
greenhazeCommented:
One cool solution out there is Apache with PHP. It has built in APIs for most databases including MYSQL, mSQL, and Oracle. Unlike standalone CGI scripts, PHP can create persistent database connections, so pages load *much* faster.

PHP has syntax very much like Perl, with a few C and Java features thrown in. Also, the pages can be embedded with HTML
much like ASP.

Perl is the amazing, but it is interpretted and thus slower than
compiled programs such as C or C++. Tcl and shell scripts (such as Korn, Bash, etc) are acceptable too, but like Perl they
are interpretted.

So, go with PHP! It's easy to install and easier still to use!

http://www.php.net

It's free too!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Scripting Languages

From novice to tech pro — start learning today.