SQL
-
Software Development
Why Staying in Control of Your SQL is so Important
Lots of blog posts and research papers are written about the topics of scaling up and scaling out. This interesting…
Read More » -
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 »