|
What's more there are 4 of these idiot voters so far
|
|
|
|
|
SQL is a programming language. It may not be general-purpose or Turing complete, but, in my opinion, that doesn't matter.
|
|
|
|
|
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
|
|
|
|
|
Jörgen Sigvardsson wrote: here are things you just can't do with it...?
That's what BASIC is for...
(ducks for cover)
|
|
|
|
|
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
|
|
|
|
|
"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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
Only select is a query.
Insert, update, delete, create, drop, truncate, alter, etc. are not queries; they are program statements.
|
|
|
|
|
OK, to end this (very interesting ) 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.
|
|
|
|
|
Well then that changes my answer to 2 if you leave out scripting languages like sh.
John
|
|
|
|
|
What? No. I didn't say that scripting languages aren't programming languages.
|
|
|
|
|
I should have clicked the link before answering..
C++
SQL
sh
bash
awk
sed
John
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
- 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
|
|
|
|
|
Intel x86 & x64 assembler
C++
C#
JavaScript
PHP
Less frequently, Visual Basic
|
|
|
|
|
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
|
|
|
|
|
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)
|
|
|
|
|
C++, PLC programming (IECxxxx), ISO/DIN code for our CNC machines, ABB robots rapid language, KRL Kuka robot language.
Some times PHP and some times SQL...and some others but not usually...
Those are the most common I use...
|
|
|
|
|
You must not do web development. 4-5 is pretty common. In a .NET shop, there are often both C# and VB.NET programs floating around that most people have to touch on a monthly basis, now automatically, that's 2 there. Then, if you do any web development, you're certainly going to use JavaScript, so that's 3. And, most programs use a database, so you're likely going to write or edit stored procedures. Though SQL <i>queries</i> are not written in a <i>programming</i> language, when you write a stored procedure, it has all the logic control that dictates what a programming language is, so that makes 4.
Since most developers these days are web developers (at least, part time), that puts at least 3 programming languages up there right away. And, as the primary coding language (C# in your and my cases), it's not uncommon for a shop to have 2 or three. My place of work had VB6, VBScript, C#, and VB.Net when I started there 4.5 years ago. We've all but scrapped the VB6 and VBScript, so that gets us down to 2 primary languages, but there's a new initiative where we're experimenting with Python, Ruby, Ruby on Rails (are those separate languages?), and a few others. So, very quickly, our language count is going to jump up.
The ones who are "bragging" are the ones who are counting languages that are <i>not</i> <i><b>programming</b></i> languages, like plain old SQL, HTML, XML, XHTML, and maybe even counting <i>concepts</i> like ASP.NET, Ajax and such as "programming languages".
But, 4-5, most definitely would be common.
Hey! There's a BUG on this entry form! I copied my text to notepad, then pasted it back, and all angled brackets are converted on insert to ampersand + "gt" or "lt" plus semi-colin. I didn't notice this until /after/ I'd posted. Ugh!
modified on Sunday, November 22, 2009 11:55 AM
|
|
|
|
|
yeah.. it's an official language now.
|
|
|
|
|
|
I use C# and SQL nearly every day. Plus I don't think a month goes by that I don't do something with at least one other language; C, Perl, BASIC, DCL -- often in response to a post here on CP.
Were there a Go compiler for Windows I would have dabbled in that last week.
|
|
|
|
|