Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^3: poll ideas quest 2017 [The most hated language]

by chacham (Prior)
on Nov 11, 2017 at 19:15 UTC ( #1203190=note: print w/replies, xml ) Need Help??


in reply to Re^2: poll ideas quest 2017 [The most hated language]
in thread poll ideas quest 2017

SQL

Hate SQL?! Surely you jest. SQL is one of the few small and beautiful languages. Misunderstood by many because it is set based instead of linear, though. Which is perhaps why most programmers should not just assume they can write good SQL, because they are thinking abut it the wrong way.

  • Comment on Re^3: poll ideas quest 2017 [The most hated language]

Replies are listed 'Best First'.
Re^4: poll ideas quest 2017 [The most hated language]
by Tux (Abbot) on Nov 12, 2017 at 10:19 UTC

    That is not my hate. 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) is is slowing down, so you have to set options to make it comply to the standard so you can write portable (ahum) SQL.


    Enjoy, Have FUN! H.Merijn

      Ah, i see. That's because the SQL Standard stinks. Methinks some people on the standards committee have never actually used the language.

      Anyway, the ANSI 99 standard is pretty well supported, and can do just about anything, though perhaps not in the fastest method.

      Ultimately, the best methods are specific to the RDBMS, do to what they were aiming for.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2020-12-04 13:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (58 votes). Check out past polls.

    Notices?