Blog: jooq (Lukas Eder)

212 blogs updated: 30 min. ago
How to Calculate Multiple Aggregate Functions in a Single Query
At a customer site, I've recently encountered a report where a programmer needed to count quite a bit of stuff from a single table. The coun...
20-04-2017 16:46:01 jooq (Lukas Eder) Advanced
jOOQ Tuesdays: Richard North Makes Database Testing More Reproducible with Testcontainers
Welcome to the jOOQ Tuesdays series. In this series, we'll publish an article on the third Tuesday every other month where we interview some...
18-04-2017 14:08:09 jooq (Lukas Eder) Advanced
How to Fetch Multiple Oracle Execution Plans in One Nice Query
When looking at execution plans in Oracle, we'll have to do several steps to be able to call the DBMS_XPLAN package functions. In fact, we h...
31-03-2017 14:23:19 jooq (Lukas Eder) Advanced
SQL IN Predicate: With IN List or With Array? Which is Faster?
Hah! Got nerd-sniped again: A jOOQ user was wondering why jOOQ would generate an IN list for a predicate like this: Java SQL when in fact th...
30-03-2017 13:51:49 jooq (Lukas Eder) Advanced
How to Benchmark Alternative SQL Queries to Find the Fastest Query
Tuning SQL isn't always easy, and it takes a lot of practice to recognise how any given query can be optimised. One of the most important sl...
29-03-2017 15:56:43 jooq (Lukas Eder) Advanced
The Open-Closed Principle is Often Not What You Think it Is
jOOQ is a library that loves making everything internal final and package private. We have tons of classes like these: The class implements ...
20-03-2017 11:30:33 jooq (Lukas Eder) Advanced
Creating Tables Dum and Dee in PostgreSQL
I was nerd-sniped: @lukaseder @danieldietrich @odersky why can't I represent table dee and table dum in SQL then? _ Benji Weber (@benjiweber...
17-03-2017 17:41:48 jooq (Lukas Eder) Advanced
A Nice API Design Gem: Strategy Pattern With Lambdas
With Java 8 lambdas being available to us as a programming tool, there is a "new" and elegant way of constructing objects. I put "new" in qu...
17-03-2017 11:28:05 jooq (Lukas Eder) Advanced
Faster SQL Through Occasionally Choosing Natural Keys Over Surrogate Keys
There are many many opinions out there regarding the old surrogate key vs. natural key debate. Most of the times, surrogate keys (e.g. seque...
16-03-2017 16:47:49 jooq (Lukas Eder) Advanced
Many SQL Performance Problems Stem from "Unnecessary, Mandatory Work"
Probably the most impactful thing you could learn about when writing efficient SQL is indexing. A very close runner-up, however, is the fact...
08-03-2017 13:41:11 jooq (Lukas Eder) Advanced

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení | Top SQL Blogs | monitored using: sitemonitoring

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.