SQL
-
Software Development
A Better Query Language than SQL
Leland Richardson, Founder of Tech.Pro has recently published a very interesting article about BQL, his visions of a better query…
Read More » -
Software Development
Please, Run That Calculation in Your RDBMS
There’s one thing that you can do terribly wrong when working with RDBMS. And that thing is not running your…
Read More » -
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 »
