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 [...]
About two weeks ago at work we discussed different strategies on testing databases. Although there are ways to do it, they are all more or less painful. And finally we all parted in agreeing: (SQL) databases suck, SQL sucks and testing databases and SQL sucks as well. We are only testing this crap because the [...]
Everybody who understands the working of a Turing machine and that of SQL understands, that SQL probably isn’t Turing complete, i.e. you can’t use it to build a Turing machine. Yet I’m going to show that you actually can implement a Turing Engine using Oracle SQL. So for those among you who haven’t studied informatics: [...]
