I'm contemplating about what has happened in the ISO / IEC SQL standard during the last 15 years. We've had quite a few new features added to our beloved SQL language. Check this out: With the ISO/IEC SQL:1999 standard, we could take advantage of grouping sets and (recursive) common table expressions. With the ISO/IEC SQL:2003 standard, we’ve … Continue reading Popular ORMs Don’t do SQL
Month: November 2013
Oracle GlassFish, or Why You Should Think About Open Source Again
Oracle's recent announcement about the discontinuation of commercial services for JEE's reference implementation GlassFish has caused many reactions in the community involved with JEE. The reactions reach from: Markus Eisele's rather pessimistic outlook on JEE's future in general Adam Bien's constructive (or cynical? With Adam Bien, you can never be sure) suggestions of moving GlassFish … Continue reading Oracle GlassFish, or Why You Should Think About Open Source Again
ID Lists Aren’t the Best Solution for the N+1 Problem
In their eternal attempts to circumvent the N+1 problem, Hibernate users often resort to IN predicates with ID lists. In this post, we'll see how those users might just be replacing a horrible thing with a bad one, which is better but not yet good. Here's why: The N+1 Problem The N+1 problem is a … Continue reading ID Lists Aren’t the Best Solution for the N+1 Problem
Using SQL Injection Vulnerabilities to Dump Your Database
The threat caused by SQL injection is heavily underestimated even by many senior developers and software architects. Most people are unaware of the fact that an entire server can be at risk by a single vulnerability even in the remotest piece of logic. This article will give a frightening insight into the potential severity of … Continue reading Using SQL Injection Vulnerabilities to Dump Your Database
Probably the Coolest SQL Feature: Window Functions
Once you get a hang of the very peculiar syntax, SQL is a highly expressive and rich language offering incredible features at a declarative level. One of the coolest features are window functions, whose coolness is in no proportion to their incredibly low popularity. The low popularity can only be due to developers being oblivious … Continue reading Probably the Coolest SQL Feature: Window Functions
Top 10 Lists of Common Java Mistakes (That Makes Top 100!)
Top 10 lists are very popular, fun, and informative to read. But there are so many of them! How to choose the right one? Here's a meta top 10 list helping you find the top 10 top 10 lists. On a more geeky note: SELECT TOP 10 mistake FROM source1 UNION ALL SELECT TOP 10 … Continue reading Top 10 Lists of Common Java Mistakes (That Makes Top 100!)