Blog: jooq (Lukas Eder)


221 blogs updated: 44 min. ago
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, ...
6
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...
0
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 ...
3
07-09-2018 16:05:45 jooq (Lukas Eder) Advanced
Find the Next Non-NULL Row in a Series With SQL
I've stumbled across this fun SQL question on reddit, recently. The question was looking at a time series of data points where some events h...
3
03-09-2018 14:10:57 jooq (Lukas Eder) Advanced
A Frequent Question: Does jOOQ Have a First Level Cache?
One of the more frequent questions people have when switching from JPA to jOOQ is how to migrate from using JPA's first level cache? Speakin...
4
29-08-2018 09:55:40 jooq (Lukas Eder) Advanced
Replacing JPA's First Level Cache with jOOQ
One of the more frequent questions people have when switching from JPA to jOOQ is how to migrate from using JPA's first level cache? Speakin...
9
28-08-2018 16:40:53 jooq (Lukas Eder) Advanced
How to Write Multiset Conditions With Oracle VARRAY Types
Oracle is one of the few databases that implements the SQL standard ORDBMS extensions, which essentially allow for nested collections. Other...
6
15-08-2018 12:22:22 jooq (Lukas Eder) Advanced
How SQL DISTINCT and ORDER BY are Related
One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query. The Basics Running some queri...
4
13-07-2018 17:47:04 jooq (Lukas Eder) Advanced
PostgreSQL 11's Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses
Exciting discovery when playing around with PostgreSQL 11! New SQL standard window function clauses have been supported. If you want to play...
6
05-07-2018 17:55:59 jooq (Lukas Eder) Advanced
Using UNPIVOT to Traverse a Configuration Table's Rows and Columns
Imagine you have a configuration table like the following: It specifies a set of rules that Can be enabled / disabled Can be given a priorit...
3
27-06-2018 17:22:46 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.