SQL – the horror

Yes, SQL is a horror, especially when not done right. It is really easy to let queries go out of hand, and just write lines and lines of code just to craft a single SQL query. You cannot debug them. You cannot easily maintain them. You cannot easily tune them. Then why do people write them in the first place?

To the other end of the spectrum are people who completely avoid writing queries that access more than one table at a time. These are the guys leaning towards no-sql, non-rdbms solutions, developers who prefer to do the joins in their application code instead of writing a few lines of sql. ‘That’s right, we don’t need no stinkin’ SQL!’

That’s why I decided to start this blog, to get people appreciate the art of query writing once once more. Hopefully, I can manage to convince a few of you at least, to dabble into writing beautiful sql queries again.

Leave a Reply

Your email address will not be published. Required fields are marked *

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax