Why I like SQL

This is not a joke! I am serious, I like SQL for the following reasons:

  • SQL is declarative, which as a side effect means there are now corner cases hidden in if … then … else constructs. In practice this means, that once a SQL statement is working for a couple of cases, it is fairly limited.
  • SQL is standard. I worked a lot with Oracle, but when I have to use MySQL, MS SQL Server, DB2 or what ever I’ll be up to speed soon.
  • It is pretty powerful. You can do a lot of things with it. Way more than most people thing.
  • Well I think that’s about it.

Because on all other accounts I still hate the current state of SQL. And although I am deeply skeptical about all that NoSQL hype lately, I do hope one thing to come out of it: New ideas for a successor of SQL, with a stronger type system, with a powerful scoping a modularization features and a clean design.

Share:
  • DZone
  • Digg
  • del.icio.us
  • Reddit
  • Facebook
  • Twitter
This entry was written by Jens Schauder , posted on Sunday April 11 2010at 04:04 pm , filed under Softwaredevelopment and tagged . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

2 Responses to “Why I like SQL”

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>