-
Software Development
PostgreSQL’s Best-Kept Secret, and how to Use it with jOOQ
PostgreSQL has a lot of secret data types. In recent times, PostgreSQL’s JSON and JSONB support was hyped as being…
Read More » -
Software Development
How SQL GROUP BY Should Have Been Designed – Like Neo4j’s Implicit GROUP BY
In the recent past, we’ve explained the syntactic implications of the SQL GROUP BY clause. If you haven’t already, you…
Read More » -
Software Development
This Common API Technique is Actually an Anti-Pattern
I admit, we’ve been lured into using this technique as well. It’s just so convenient, as it allows for avoiding…
Read More » -
Software Development
Do Not Think That One Second is Fast for Query Execution
I keep encountering situations where RDBMS users think that one second for query execution is anything near fast. Most recently,…
Read More » -
Enterprise Java
Let’s Review How to Insert Clob or Blob via JDBC
LOBs are a PITA in all databases, as well as in JDBC. Handling them correctly takes a couple of lines…
Read More » -
Software Development
Is Your Eclipse Running a Bit Slow? Just Use This Simple Trick!
You wouldn’t believe it until you try it yourself. I’ve been using the Eclipse Mars developer milestones lately, and I’ve…
Read More » -
Enterprise Java
How JPA 2.1 has become the new EJB 2.0
Beauty lies in the eye of the beholder. So does “ease”: Learn more about SQL Result Set Mappings and handle…
Read More » -
Enterprise Java
jOOQ Tuesdays: Vlad Mihalcea Gives Deep Insight into SQL and Hibernate
Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month…
Read More » -
Software Development
It’s the Little Things: The PL/SQL NULL Statement, and why Every Language Should have One
Syntax is one of those topics. One of those emotional topics that lead to very very very important discussions. I…
Read More »