Blog: jooq (Lukas Eder)

222 blogs updated: 46 min. ago
How to Unit Test Your Annotation Processor using jOOR
Annotation processors can be useful as a hacky workaround to get some language feature into the Java language. The best example is Lombok, w...
07-12-2018 16:27:30 jooq (Lukas Eder) Advanced
How to Create a Good MCVE (Minimal Complete Verifiable Example)
Reporting a bug takes time, and trust me, every vendor appreciates your reporting of a bug! Your voice counts as many voices, for all the ot...
22-11-2018 18:33:56 jooq (Lukas Eder) Advanced
How to Aggregate an Archive Log's Deltas into a Snapshot with SQL
A customer of my popular SQL training (which you should book!) has recently challenged me to optimise a hierarchical query that merges an ar...
16-11-2018 15:38:17 jooq (Lukas Eder) Advanced
How to Use jOOQ's UpdatableRecord for CRUD to Apply a Delta
While jOOQ is not a full fledged ORM (as in an object graph persistence framework), there is still some convenience available to avoid hand-...
05-11-2018 11:51:40 jooq (Lukas Eder) Advanced
Imperative Loop or Functional Stream Pipeline? Beware of the Performance Impact!
I like weird, yet concise language constructs and API usages Because you're evil. Nicolai Parlog (@nipafx) October 25, 2018 Yes. I am guilty...
29-10-2018 12:06:47 jooq (Lukas Eder) Advanced
Writing Custom Aggregate Functions in SQL Just Like a Java 8 Stream Collector
All SQL databases support the standard aggregate functions COUNT(), SUM(), AVG(), MIN(), MAX(). Some databases support other aggregate funct...
09-10-2018 14:59:16 jooq (Lukas Eder) Advanced
How to Use SQL UPDATE .. RETURNING to Run DML More Efficiently
At a customer site, I recently refactored a "slow-by-slow" PL/SQL loop and turned that into an efficient set based UPDATE statement saving m...
26-09-2018 15:52:48 jooq (Lukas Eder) Advanced
How to Write a Multiplication Aggregate Function in SQL
Everyone knows the SQL SUM() aggregate function (and many people also know its window function variant). When querying the Sakila database, ...
21-09-2018 10:34:19 jooq (Lukas Eder) Advanced
How to Reduce Syntactic Overhead Using the SQL WINDOW Clause
SQL is a verbose language, and one of the most verbose features are window functions. In a stack overflow question that I've encountered rec...
20-09-2018 14:48:36 jooq (Lukas Eder) Advanced
Beware of Hidden PL/SQL to SQL Context Switches
I recently stumbled upon a curious query on a customer's productive Oracle database: Two things caught my attention: The query was executed ...
07-09-2018 16:05:45 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.