View Single Post
12-18-2008, 09:53 PM
#20
echoSwe is offline echoSwe
Status: Member
Join date: Jul 2005
Location:
Expertise:
Software:
 
Posts: 185
iTrader: 0 / 0%
 

echoSwe is on a distinguished road

  Old

Originally Posted by Village Idiot View Post
Isn't someone a little grumpy today?
Yes, in fact, I have to do C++ on linux in the kate editor because eclipse gets out of memory exceptions when trying to compile C++ code.


Also, the following are not programming languages:
PHP (scripting language)
ASP (scripting language)
Javascript (scripting language)
Yes they are. Haven't you tried PHP on the CLR for example? Can access any other class in the framework. ASP's VBScript is a programming language. Javascript is a fullfledged programming language as well. http://www.aptana.com/jaxer (one example of it)


HTML (markup language)
CSS (style data)
SQL (application with an advanced querying language).
Never said these were programming languages.


Yelling at us for SQL not being a programming language is like yelling at someone for referring to a sedan as a car. SQL is for all intents and purposes, a programming language.
MySQL isn't. It's an application. Is Visual Studio a programming language? Or PostgreSQL? Recursion panic! I said SQL was a data manipulation language. SQL in a database is also a data specification language and then with stored procedures and flow control constructs it becomes a programming language, as you say.


Another thing, t-SQL can only in theory be applied to all SQL databases, in practice they must be converted (I had to convert about 200 at work some time ago from MySQL to SQL, don't try and tell me that they are compatible).
Yes, there are dialects, but what's your point? I never said they weren't programming languages as much as I never said they were.

SELECT * FROM users;
if users is a table,
works on both PostgreSQL, MySQL and MS SQL as far as I'm concerned. That MySQL has - INNER JOIN t USING `attribute`, while MS SQL would require you to do an explicit - ON t.attribute = t1.attribute doesn't really matter much in my opinion, when we are talking about learning SQL, since MySQL also supports the ON notation which how you learn it initially anyway (unless you talk about theta or equivalence joins an relational algebra, in which case you need the two tuples to be union compatible and then you can simply do a NATURAL JOIN (postgresql can do that)).

As far as I'm concerned, an operating system is a big program. It's run with the same fetch-execute cycle as any other program, besides that the CPU has hooks for virtual memory, interrupts and traps which not normal programs in user space have access to, but only because of the layered security model in operating systems (which if you take an operating system like singularity, doesn't exist, instead they have software isolated processes). Care to tell me why it's not?