What language and what type of database do you use the most?

A survey...

[sidyadav]

So, Which one?
Out of the languages:
ASP? ASP.NET? PHP? CGI/PERL? PYTHON? JAVA? VB Script? CFML? C++? XML? Or are you the old HTML guy?
Databases:
MYSQL? MS SQL? Oracle? PostGRE SQL? MS ACCESS? Or are you the old flat files guy?

My choice would be PHP and HTML for the language and MYSQL and/or flat files for databases. Most PHP developers prefer it.

Sid

[edited by: sidyadav at 4:25 am (utc) on Nov. 14, 2003]

[moltar]

Perl + MySQL 4eva :D

[jatar_k]

Most PHP developers prefer it.

prefer what?

9-5
PHP & ORACLE

contracts
PHP & MySQL/flatfile

[sidyadav]

Well, its so funny, theres a PHP Scripts directory with 5,842 listings in it, and I think I've never seen a script with PHP and Oracle, 90% I would say is PHP and MYSQL 10% I'd say is PostGRE SQL.

Sid

[Krapulator]

Perhaps because MySql is free?

[jatar_k]

It would be counter productive to offer free scripts for PHP & ORACLE since our license costs us a pretty penny.

The folk who use ORACLE don't look for free scripts to hack on, they hire a team of programmers. ;)

[moltar]

Most of the PHP + Oracle does not go public. It's custom made for a client.

[sidyadav]

But still, I know a lot of people that use PHP and CGI/PERL, any dude out there using something like PYTHON or Java?

Sid

[victor]

something like Python

I've never looked back since I started using Rebol for all my CGIs and backroom non-CGIs stuff.

If you haven't come across it before, it is well worth a look at.

[pete_m]

For clients: Depends - mostly asp.net (vb.net) and SQL Server, sometimes asp.old and SQL Server, occasionally php and MySQL

For myself: php and MySQL

The big reason I use MySQL is because it's free (beer and speech), rather than the featureset :)
It's crying out for stored procedures and views - roll on version 5!

[sidyadav]

same here,
and I also like them because they are easy to learn and have more fuctions, but not as many as CGI I reckon, but enough for me.

So let me get this straight,
there is no one here who uses CFML or PYTHON is there?

I think Google uses Python, not too sure...

Sid

[Nick_W]

PHP + MySQL

Easy peasey lemon squeezy.

Nick

[Zaphod Beeblebrox]

ASP + Access

[NameNick]

PHP + MySQL/Flat File over here

NN

[jamesa]

Another PHP/MySQL'er here.

[Sanenet]

One vote for CF + SQL Server!

[sidyadav]

Ok, so take out ColdFusion (CFML) from the 'Most Annonymous Web Language (MAWL)' list

Anyone PYHON or JAVA?

Sid

[killroy]

HTAG + ydbEngine

Although once I started writing directories with some volume in traffic I wrote a backend handler for MySQL, making my trusty old ydbEngine more of a middle-end caching system.

One disadvantage of writign your own scripting environment is that you lack resources to full test it. But considering how buggy such well developed systems as windows, PHP or MySQL are, I'm pretty proud that my scripting environment only crashes once avery few weeks ;)

SN

PS: Trust me, there is nothing like having full control by writing your own compiler. Once there you'll never go back.

[seindal]

I use perl, mod_perl, HTML::Mason and MySQL whenever I can get away with it.

HTML::Mason in particular is great.

[txbakers]

I use ASP with JavaScript (some vb) and mySQL

[bbrooks]

Perl w/ MySQL for UNIX server side. Occasionally Perl w/ DBI:ODBC to access Microsoft Access DB on local PC side.

[MonkeyBoyUK]

PHP & MYsql

For intranet stuff i use ASP.net and SQL2000, quick and dirty :)

[ppg]

Java/jsp & MySQL.

added - just getting into php though (so I can have someone to talk to...)

[bluedevil]

LAMP always!
(Linux/Apache/MySQL/PHP)

[plumsauce]

c/isapi/iis and MS SQL via dblib

or

jscript and MS SQL

[jatar_k]

LAMP always!

if i look at our whole system it looks more like

SFLAPOM
(Solaris/FreeBSD/Linux/Apache/PHP/Oracle/MySQL)

say that 3 times fast ;)

[shasan]

LAMPer here as well. Some Perl, mostly PHP.

[sidyadav]

If you ask me, on my Home PC, I've got WAMP installed, which is for debugging scripts etc, and on my real site, I've got a LAMP. Most people do that.

Sid

[lorax]

PHP/MySQL are the current tools of choice.

I use to work with CFML - dumped that a few years ago.

Have been playing more and more with the ancillary technologies that strengthen the core script/db infrastructure like SOAP.

[edited by: lorax at 5:01 pm (utc) on Nov. 17, 2003]

[Rossv1]

Cold Fusion and Access or MySQL