Survey Results

Scott Liddicoat16-Nov-09 10:45

Scott Liddicoat

16-Nov-09 10:45

T-SQL was listed as a language, so that's 2. I regularly use just C# and T-SQL as well.

Nemanja Trifunovic16-Nov-09 10:53

16-Nov-09 10:53

Rob Philpott wrote:
I would have thought most people would be the same. Are you sure you're not just showing off?

Depends on what you do, really. At my previous job I was regularly using:
C++ for server-side code
VBA for the MS Word client side (yes, our client app was MS Word Smile | :)

)
Javascript - for browser scripts

plus non-programming languages such as HTML, XML, SQL...

Occasionally, I was also using some C# for automated tests and reading some Python code.

Nowdays it is mostly C++ plus occasionally some Perl.

utf8-cpp

Nathan Wheeler16-Nov-09 11:03

Nathan Wheeler

16-Nov-09 11:03

Given that in the course of a normal week I use or have to work with C#, VB.net, JavaScript, T-SQL, PL-SQL for just web development I am not surprised to see 4 to 5 being the most popular.
In my case it is actually higher as I work with systems that are written in VBScript (as well as an derivative of ECMAScript) and even develop on 4D databases using its internal language.

As to SQL not counting, that is correct but the procedural based extensions do count. <attempts to dodge incoming flames> Big Grin | :-D

Member 443668016-Nov-09 12:44

Member 4436680

16-Nov-09 12:44

I want to know who uses 31 or more!

Mark D. Collins

Mycroft Holmes16-Nov-09 18:50

Mycroft Holmes

16-Nov-09 18:50

What's more there are 4 of these idiot voters so far

PIEBALDconsult16-Nov-09 14:34

16-Nov-09 14:34

SQL is a programming language. It may not be general-purpose or Turing complete, but, in my opinion, that doesn't matter.

Jörgen Sigvardsson16-Nov-09 20:36

Jörgen Sigvardsson

16-Nov-09 20:36

I beg to differ. I think a language must be Turing complete before it's promoted to a programming language. What's the point if there are things you just can't do with it...?

--
Kein Mitleid Für Die Mehrheit

Jim Crafton19-Nov-09 9:46

Jim Crafton

19-Nov-09 9:46

Jörgen Sigvardsson wrote:
here are things you just can't do with it...?

That's what BASIC is for...

(ducks for cover)

¡El diablo está en mis pantalones! ¡Mire, mire!
SELECT * FROM User WHERE Clue > 0
0 rows returned
Save an Orange - Use the VCF!
Personal 3D projects
Just Say No to Web 2 Point Blow

Nemanja Trifunovic17-Nov-09 4:39

17-Nov-09 4:39

PIEBALDconsult wrote:
SQL is a programming language

Ain't. It is a query language.

PIEBALDconsult wrote:
It may not be general-purpose or Turing complete, but, in my opinion, that doesn't matter.

It matters Smile | :)

utf8-cpp

PIEBALDconsult17-Nov-09 5:06

17-Nov-09 5:06

"Computer programs (also software programs, or just programs) are instructions for a computer." -- Wikipedia

That's not a very good definition (as I recall, my early teachers also included things like "step-by-step" etc.), but it gets the idea across.

SQL is a language for specifying instructions to a computer -- as far as I'm concerned, that makes it a programming language.

Nemanja Trifunovic17-Nov-09 6:28

17-Nov-09 6:28

PIEBALDconsult wrote:
That's not a very good definition

There we agree...

PIEBALDconsult wrote:
SQL is a language for specifying instructions to a computer -- as far as I'm concerned, that makes it a programming language.

HTML also specifies instructions to a computer - how to render a web page. Does it make it a programming language?

Or how about RTF - also a set of instructions for a computer, but I don't know anybody who would call it a programming language.

One way or another, there must be some well-defined line that divides programming languages from "the rest of the world", and that line is Turing completeness. Standard SQL is not Turing complete, therefore it is not a programming language. PL/SQL and T-SQL are Turing complete and they are programming languages.

utf8-cpp

PIEBALDconsult17-Nov-09 7:15

17-Nov-09 7:15

Documents written in HTML, XML, RTF, etc. are data, not programs.

Nemanja Trifunovic wrote:
that line is Turing completeness

I just don't see it that way nor any reason to define it like that.

Nemanja Trifunovic wrote:
PL/SQL and T-SQL are Turing complete

Then you may assume that when I say "SQL" I am referring to the SQL-92-compliant parts of PL/SQL and T-SQL. Big Grin | :-D

Nemanja Trifunovic17-Nov-09 7:39

17-Nov-09 7:39

PIEBALDconsult wrote:
Documents written in HTML, XML, RTF, etc. are data, not programs.

And SQL queries are queries, not programs Smile | :)

Besides, there are programming languages where code is data and vice-versa[^].

utf8-cpp

PIEBALDconsult17-Nov-09 8:26

17-Nov-09 8:26

Only select is a query.

Insert, update, delete, create, drop, truncate, alter, etc. are not queries; they are program statements.

Nemanja Trifunovic17-Nov-09 8:51

17-Nov-09 8:51

OK, to end this (very interesting Smile | :)

) discussion, I suggest you take a look at the SQL Standard[^]. You'll notice that SQL is called "Database Language SQL" and if you scroll down to chapter 4.20, you'll see how SQL interfaces with "standard programming languages". I guess you can make a case that SQL can still be called a "non-standard programming language" but the SQL standard itself never does that.

utf8-cpp

John M. Drescher21-Nov-09 18:44

John M. Drescher

21-Nov-09 18:44

Well then that changes my answer to 2 if you leave out scripting languages like sh.

John

PIEBALDconsult22-Nov-09 3:47

22-Nov-09 3:47

What? No. I didn't say that scripting languages aren't programming languages.

John M. Drescher22-Nov-09 4:27

John M. Drescher

22-Nov-09 4:27

I should have clicked the link before answering..

C++
SQL
sh
bash
awk
sed

John

jefflewis16-Nov-09 19:45

jefflewis

16-Nov-09 19:45

It's easy!

1. c++ - app dev
2. perl - scripts

web dev:
3. php
4. sql
5. javascript

doesn't include c#, java, asp used on occasion.

such fun - I'm glad to have autocomplete.

cheers

Old Nic16-Nov-09 20:51

Old Nic

16-Nov-09 20:51

In my case the 4-5 is largely for legacy app support.

Also, not everyone has a language as flexible as C# that you can use in the web, console, windows and mobile space.

Ed.Poore17-Nov-09 1:14

Ed.Poore

17-Nov-09 1:14

C#
C++
C
PHP
Python
JavaScript

Oops, that's more than 5...

I doubt it. If it isn't intuitive then we need to fix it. - Chris Maunder

jarvisa17-Nov-09 1:47

jarvisa

17-Nov-09 1:47

Intel x86 & x64 assembler
C++
C#
JavaScript
PHP
Less frequently, Visual Basic

John M. Drescher21-Nov-09 18:45

John M. Drescher

21-Nov-09 18:45

jarvisa wrote:
Intel x86 & x64 assembler

Do you really use these anymore? I have not written a single line of .asm in almost 10 years and I do image processing with 25MB to 2 GB sized images.

John

Homncruse17-Nov-09 7:08

Homncruse

17-Nov-09 7:08

I voted 4-5, but as I read the rest of the comments on here, I realized I forgot some. Of course, I wear many hats at work - I'm an embedded developer on ARM and x86 processors, I'm the "web guy" for internal tools (and regularly assist the "web/IT guy" for customer-facing tools), and I'm also the internal PC tools guy, which means the following:

Embedded:
C
C++

Web:
PHP
Javascript

PC Tools:
C#
Perl
VB6 (legacy apps)