Tag Archives: jOOQ

Transform Your SQL Data into Charts Using jOOQ and JavaFX


In the recent past, we’ve shown how Java 8 and functional programming will bring a new perspective to Java developers when it comes to functional data transformation of SQL data using jOOQ and Java 8 lambdas and Streams. Today, we take this a step further and transform the data into JavaFX XYChart.Series to produce nice-looking […]

http://blog.jooq.org/2015/01/08/transform-your-sql-data-into-charts-using-jooq-and-javafx/

Integrating jOOQ with Grails Featuring the UWS-jOOQ Plugin


Introduction Grails is a web framework aimed to boost development productivity. One of the main features is domain centric database schema generation. Applications built with Grails are able to update existing schema just before they start. To do this, Grails is using built-in domain mappers or migrations in more advanced cases. The goal of the […]

http://blog.jooq.org/2015/03/10/integrating-jooq-with-grails-featuring-the-uws-jooq-plugin/

How to translate SQL GROUP BY and aggregations to Java 8


via How to translate SQL GROUP BY and aggregations to Java 8 – JAXenter.

This post was originally published over at jooq.org, a blog focusing on all things open source, Java and software development from the perspective of jOOQ.

I couldn’t resist. I have read this question by Hugo Prudente on Stack Overflow. And I knew there had to be a better way than what the JDK has to offer.

The Java Legacy is constantly growing


via The Java Legacy is constantly growing – JAXenter.

This post was originally published over at jooq.org, a blog focusing on all things open source, Java and software development from the perspective of jOOQ.

Hack up a Simple JDBC ResultSet Cache Using jOOQ’s MockDataProvider


via Hack up a Simple JDBC ResultSet Cache Using jOOQ’s MockDataProvider | Java, SQL and jOOQ..

Some queries shouldn’t hit the database all the time. When you query for master data (such as system settings, languages, translations, etc.), for instance, you may want to avoid sending the same silly query (and the results) over the wire all the time. For example:

JOOQ vs. Slick – Pros and Cons of Each Approach


via jOOQ vs. Slick – Pros and Cons of Each Approach | Java, SQL and jOOQ.

Every framework introduces a new compromise. A compromise that is introduced because the framework makes some assumptions about how you’d like to interact with your software infrastructure.

An example of where this compromise has struck users recently is the discussion “Are Slick queries generally isomorphic to the SQL queries?“. And, of course, the answer is: No. What appears to be a simple Slick query:

The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions


Sometimes when aggregating data with SQL, we’d love to add some additional filters. For instance, consider the following world bank data: GDP per capita (current US$) 2009 2010 2011 2012 CA 40,764 47,465 51,791 52,409 DE 40,270 40,408 44,355 42,598 FR 40,488 39,448 42,578 39,759 GB 35,455 36,573 38,927 38,649 IT 35,724 34,673 36,988 33,814 […]