Re: What programming language do you hate the most?

Other: SQL

My hate is that there are too many standards in SQL and there is no single standard that is supported by all mainstream databases, and they even differ per release.

Additionally, (mainstream) database get shipped where the default is to not respect the ANSI standard, because (they state) it (the standard) is slowing down (performance), so you have to set options to make it comply to the standard(s) so you can write portable (ahum) SQL.

BTW, IMHO there is no perfect database. They all suck in some way. Maybe a new poll: Which database sucks most (and why).

Enjoy, Have FUN! H.Merijn

Comment on Re: What programming language do you hate the most?

Replies are listed 'Best First'.
Re^2: What programming language do you hate the most? by LanX (Saint) on Dec 02, 2017 at 14:25 UTC
While I agree about the critic I don't think SQL belongs into this list of "programing languages". It's hardly Turing complete (see SO is-sql-or-even-tsql-turing-complete ) and rarely used as such. More an embedded external DSL for querying data. HTML, CSS and regexes are other examples of DSLs which are not really typical programming languages. Cheers Rolf _{(addicted to the Perl Programming Language and ☆☆☆☆ :) Wikisyntax for the Monastery}	[reply]
Re^3: What programming language do you hate the most? by chacham (Prior) on Dec 02, 2017 at 16:51 UTC
and rarely used as such. You should visit SQL forums more often. :P	[reply]
Re^4: What programming language do you hate the most? (SQL) by LanX (Saint) on Dec 02, 2017 at 16:54 UTC
You are welcome to point me to a GUI or CGI application implemented exclusively in SQL. ;) Cheers Rolf _{(addicted to the Perl Programming Language and ☆☆☆☆ :) Wikisyntax for the Monastery}	[reply]
Re^5: What programming language do you hate the most? (SQL) by chacham (Prior) on Dec 02, 2017 at 19:15 UTC
Re^2: What programming language do you hate the most? by karlgoethebier (Abbot) on Dec 04, 2017 at 17:58 UTC
"...new poll..Which database sucks most..." No new poll needed here: Oracle Sybase MySQL MSSQL Other Order doesn't really matter... ŤThe Crux of the Biscuit is the Apostropheť `perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfish")->decrypt_hex($ENV{KARL});'`Help	[reply] [d/l]
Re^2: What programming language do you hate the most? by jczeus (Monk) on Dec 11, 2017 at 12:23 UTC
VARCHAR2 :-/	[reply]
Re^3: What programming language do you hate the most? by chacham (Prior) on Dec 17, 2017 at 16:48 UTC
VARCHAR2 Fwiw, the Oracle documentation for VARCHAR2 states: The VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid possible changes in behavior, always use the VARCHAR2 datatype to store variable-length character strings. Oracle has a known issue where there is no distinction between NULL and a zero-length string. However, they called this VARCHAR2, as "one day" they will remove this distinction in VARCHAR. It's a stupid implementation on their part, but at least they flagged their own stupidity and have plans for a brighter future.	[reply]