Blog: jooq (Lukas Eder)


334 blogs updated: 4 min. ago
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...
4
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...
6
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...
4
28-01-2019 11:38:11 jooq (Lukas Eder) Advanced
Calculate Percentiles to Learn About Data Set Skew in SQL
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...
0
22-01-2019 21:14:11 jooq (Lukas Eder) Advanced
Calculate Percentiles to Learn About Data Set Skew
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...
6
22-01-2019 14:18:31 jooq (Lukas Eder) Advanced
How to Work Around ORA-38104: Columns referenced in the ON Clause cannot be updated
Standard SQL is a beautiful language. Vendor specific implementations, however, have their warts. In Oracle, for example, it's not possible ...
0
07-01-2019 14:58:46 jooq (Lukas Eder) Advanced
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...
3
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...
6
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...
4
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-...
8
05-11-2018 11:51:40 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.