Blog: jooq (Lukas Eder)

205 blogs updated: 57 min. ago
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
Impress Your Coworkers With the Incredible NATURAL FULL OUTER JOIN!
There are already only very few real-world use-cases for FULL [ OUTER ] JOIN, but maybe, you have run into this beast in the past. But when ...
07-03-2017 14:30:04 jooq (Lukas Eder) Advanced
jOOQ Tuesdays: Brett Wooldridge Shows What it Takes to Write the Fastest Java Connection Pool
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...
21-02-2017 13:40:21 jooq (Lukas Eder) Advanced
Should I Implement the Arcane Iterator.remove() Method? Yes You (Probably) Should
An interesting question was asked on reddit's /r/java recently: Should Iterators be used to modify a custom Collection? Paraphrasing the que...
17-02-2017 12:30:31 jooq (Lukas Eder) Advanced
Beautiful SQL: Lateral Unnesting of Array Columns
Sometimes, SQL can just be so beautiful. One of the less mainstream features in SQL is the array type (or nested collections). In fact, it's...
10-02-2017 14:51:41 jooq (Lukas Eder) Advanced
How to Fetch Oracle 12c Implicit Cursors with JDBC and jOOQ
Earlier this week, I've blogged about how to execute SQL batches with JDBC and jOOQ. This was useful for the MySQL, SQL Server, and Sybase u...
08-02-2017 15:42:36 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.