Blog: jooq (Lukas Eder)

357 blogs updated: 47 min. ago
How to Write a Simple, yet Extensible API
How to write a simple API is already an art on its own. I didn't have time to write a short letter, so I wrote a long one instead. Mark Twai...
06-06-2019 13:03:07 jooq (Lukas Eder) Advanced
Using IGNORE NULLS With SQL Window Functions to Fill Gaps
I found a very interesting SQL question on Twitter recently: Hi @sfonplsql we have some scenario, Let us 01Jan Mkt Value 100, 02Jan 120, nex...
24-04-2019 10:58:14 jooq (Lukas Eder) Advanced
Calling an Oracle Function with PL/SQL BOOLEAN Type from SQL
One of the most wanted features in the Oracle database is the BOOLEAN type. The SQL standard specified it a while ago, and RDBMS like Postgr...
16-04-2019 15:08:04 jooq (Lukas Eder) Advanced
The Difference Between SQL's JOIN .. ON Clause and the Where Clause
A question that is frequently occurring among my SQL training s participants is: What's the difference between putting a predicate in the JO...
09-04-2019 15:50:16 jooq (Lukas Eder) Advanced
The Cost of Useless Surrogate Keys in Relationship Tables
What's a good natural key? This is a very difficult question for most entities when you design your schema. In some rare cases, there seems ...
26-03-2019 12:43:44 jooq (Lukas Eder) Advanced
Calculating Weighted Averages When Joining Tables in SQL
I stumbled upon a very interesting jOOQ question on Stack Overflow that required the calculation of a weighted average. Why is that. Problem...
15-03-2019 12:15:01 jooq (Lukas Eder) Advanced
How to Statically Override the Default Settings in jOOQ
When configuring a jOOQ runtime Configuration, you may add an explicit Settings instance, which contains a set of useful flags that change j...
14-03-2019 15:40:41 jooq (Lukas Eder) Advanced
How to Calculate a Cumulative Percentage in SQL
A fun report to write is to calculate a cumulative percentage. For example, when querying the Sakila database, we might want to calculate th...
14-02-2019 17:44:48 jooq (Lukas Eder) Advanced
Lesser Known jOOλ Features: Useful Collectors
jOO is our second most popular library. It implements a set of useful extensions to the JDK's Stream API, which are useful especially when s...
11-02-2019 13:38:18 jooq (Lukas Eder) Advanced
How to Emulate PERCENTILE_DISC in MySQL and Other RDBMS
In my previous article, I showed what the very useful percentile functions (also known as inverse distribution functions) can be used for. U...
28-01-2019 11:38: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.