SQL
-
Software Development
SQL Trick: row_number() is to SELECT what dense_rank() is to SELECT DISTINCT
The SQL:2003 standard ranking functions are awesome companions and useful tools every now and then. The ones that are supported in…
Read More » -
Software Development
The 10 Most Popular DB Engines (SQL and NoSQL)
How to objectively measure the popularity of a DB engine? Good question! And there’s an Austrian company (Solid IT) who…
Read More » -
Software Development
The Premature Return to SQL
In online communities, the NoSQL topic (much like the ORM topic) is a guarantee to stir emotions. Many emotions are…
Read More » -
Software Development
10 More Common Mistakes Java Developers Make when Writing SQL
I was positively surprised to see how popular my recent listing about 10 Common Mistakes Java Developers Make when Writing SQL was, both…
Read More » -
Software Development
10 Common Mistakes Java Developers Make when Writing SQL
Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively) Dogma (some…
Read More » -
Groovy
Logging Hibernate SQL
There are two well-known ways to log Hibernate SQL in Grails; one is to add logSql = true in DataSource.groovy…
Read More » -
Software Development
SQL tooling, the ranking
When you need to get up and running quickly with your database, the tooling becomes very important. When developing jOOQ…
Read More » -
Core Java
Arcane magic with the SQL:2003 MERGE statement
Every now and then, we feel awkward about having to distinguish INSERT from UPDATE for any of the following reasons:…
Read More » -
Core Java
GROUP BY ROLLUP / CUBE
Every now and then, you come across a requirement that will bring you to your SQL limits. Many of us…
Read More »
