Blog: jooq (Lukas Eder) |
|
283 blogs
updated: 36 min. ago
|
||
|
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...
|
||
|
A question that is frequently occurring among my SQL training s participants is: What's the difference between putting a predicate in the JO...
|
||
|
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 ...
|
||
|
I stumbled upon a very interesting jOOQ question on Stack Overflow that required the calculation of a weighted average. Why is that. Problem...
|
||
|
When configuring a jOOQ runtime Configuration, you may add an explicit Settings instance, which contains a set of useful flags that change j...
|
||
|
A fun report to write is to calculate a cumulative percentage. For example, when querying the Sakila database, we might want to calculate th...
|
||
|
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...
|
||
|
In my previous article, I showed what the very useful percentile functions (also known as inverse distribution functions) can be used for. U...
|
||
|
B-Tree indexes are perfect when your data is uniformly distributed. They are not really useful, when you have skewed data. I'll explain late...
|
||
|
B-Tree indexes are perfect when your data is uniformly distributed. They are not really useful, when you have skewed data. I'll explain late...
|
||