SQL

Using jOOQ With Spring: Sorting and Pagination

JOOQ is a library which helps us to get in control of our SQL. It can generate code from our database and help us to build typesafe database queries by using its fluent API. The earlier parts of this tutorial have taught us how we can configure the application context of our application, generate code […] Read more

Using jOOQ With Spring: CRUD

jOOQ is a library which helps us to get back in control of our SQL. It can generate code from our database and help us to build typesafe database queries by using its fluent API. The earlier parts of my jOOQ tutorial have taught us how we can configure the application context of our example […] Read more

Using jOOQ With Spring: Code Generation

As we might remember from the first part of this tutorial, jOOQ states that jOOQ generates Java code from your database and lets you build typesafe SQL queries through its fluent API. The first part of this tutorial describes how we can configure the application context of a Spring powered application which uses jOOQ, but […] Read more

Using jOOQ With Spring: Configuration

I have had my share of performance problems caused by ORMs. Although I have to admit that most of these problems were really caused by yours truly, I have started to think that using ORMs in read-only operations is not worth it. I started to look for alternative ways to implement these operations. That is […] Read more

Book Review: SQL Performance Explained

SQL Performance explained by Markus Winand is a book which has a very bold tagline. This tagline is: Everything developers need to know about SQL performance The book has 192 pages and it covers all major SQL databases (MySQL, Oracle, PostgreSQL, and SQL server). To make matters a little bit more interesting, it concentrates on […] Read more