A map of all those new NoSQL, NewSQL, post-SQL, structured, unstructured database options that came out over the past year

So you want to go with the flow and implement your next application on top of some NoSQL, NotJustSQL, NewSQL, AlmostSQL, SQL++, NextGenSQL, and what not, just to be sure not to miss out on some of the latest developments in the data business? Here's a little map to guide you through the jungle of … Continue reading A map of all those new NoSQL, NewSQL, post-SQL, structured, unstructured database options that came out over the past year

Row value expressions and the BETWEEN predicate

Now this is a simple example of how SQL clause simulation can get nasty if you want to make use of some more advanced SQL clauses that aren't supported in all databases. Consider the following predicate and equivalent transformations thereof: The BETWEEN predicate The BETWEEN predicate is a convenient form of expressing the fact that … Continue reading Row value expressions and the BETWEEN predicate

Row value expressions and the NULL predicate

Row value expressions are something very powerful in SQL. They have been around since the early days of standard SQL, e.g. in SQL 1992, even if not all databases implement them correctly, still today. As always, the NULL predicate is one that is a bit tricky to understand, also in the context of row value … Continue reading Row value expressions and the NULL predicate

Big Fail. How to recognise bad software

There's some subtlety in how "bad software" can be recognised from error messages as these... ;-)

JDEclipse: A must-have Java Decompiler

I have recently discovered this new, must-have Eclipse plugin, which is very useful for those third-party libraries whose source-code you can't easily find or link into your Eclipse: JDEclipse. It doesn't only decompile byte code into Java code, it does so extremely well, keeping line numbers at the correct place, such that you can actually … Continue reading JDEclipse: A must-have Java Decompiler