SQL
-
Enterprise Java
Java 8 Friday Goodies: SQL ResultSet Streams
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Software Development
JOOQ Facts: SQL functions made easy
The JDBC API has always been cumbersome and error-prone and I’ve never been too fond of using it. The first…
Read More » -
Core Java
Java 8 Friday Goodies: Lambdas and SQL
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Software Development
You’re Very Likely to Have Gotten SQL Date Time Arithmetic Wrong!
You’re very likely to have gotten SQL date time arithmetic wrong. And why is that? Google it! You’ll quickly find…
Read More » -
Enterprise Java
Hibernate Facts: How to “assert” the SQL statement count
Introduction Hibernate simplifies CRUD operations, especially when dealing with entity graphs. But any abstraction has its price and Hibernate is…
Read More » -
Software Development
The SQL Language’s Most Missing Feature
SQL is also awesome in many ways. We can write out the most complex truths and facts and have the…
Read More » -
Software Development
Lesser-Known SQL Features: DEFAULT VALUES
A lesser-known SQL feature is the DEFAULT keyword, which can be used in INSERT and UPDATE statements. Consider the following…
Read More » -
Software Development
Counting Distinct Records in SQL
The SQL language and its depths… Some of you readers might be aware of MySQL’s capability of counting distinct records…
Read More » -
Software Development
Add LATERAL Joins or CROSS APPLY to Your SQL Tool Chain
The T-SQL dialect has known the powerful CROSS APPLY and OUTER APPLY JOIN syntaxes for ages. The SQL:1999 standard had…
Read More »