Use ResultQuery.collect() to Implement Powerful Mappings

In our opinion, any Iterable<T> should offer a <R> collect(Collector<T, ?, R>) method to allow for transforming the the content to something else using standard JDK collectors, jOOλ collectors from org.jooq.lambda.Agg or your own. When using jOOQ, you don't have to wait for the JDK to finally add these useful utilities to the Iterable API. … Continue reading Use ResultQuery.collect() to Implement Powerful Mappings

How to Get an RDBMS Server Version with SQL

Do you need to know what RDBMS Server version you're on, and you only have SQL at your disposal? No problem. Most RDBMS provide you with that information in some form of meta data table. Here's how: -- CockroachDB select version(); -- Db2 select service_level from table (sysproc.env_get_inst_info()) t -- Derby select getdatabaseproductversion() from (values … Continue reading How to Get an RDBMS Server Version with SQL