Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: What programming language do you hate the most?

by Tux (Canon)
on Dec 02, 2017 at 08:59 UTC ( [id://1204706]=note: print w/replies, xml ) Need Help??


in reply to 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

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

      and rarely used as such.

      You should visit SQL forums more often. :P

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

Re^2: What programming language do you hate the most?
by jczeus (Monk) on Dec 11, 2017 at 12:23 UTC
    VARCHAR2 :-/

      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1204706]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2024-03-29 05:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found