Blog: jooq (Lukas Eder)

240 blogs updated: 122 min. ago
The Performance Impact of SQL's FILTER Clause
I've found an interesting question on Twitter, recently. Is there any performance impact of using FILTER in SQL (PostgreSQL, specifically), ...
06-02-2023 10:38:51 jooq (Lukas Eder) Advanced
Emulating Window Functions in MySQL 5.7
One of MySQL 8's biggest improvements is the support of window functions. As I always said in conferences, there's SQL before window functio...
20-01-2023 12:13:32 jooq (Lukas Eder) Advanced
Why You Should Execute jOOQ Queries With jOOQ
Previously on this blog, I've written a post explaining why you should use jOOQ's code generator, despite the possibility of using jOOQ with...
18-01-2023 13:40:41 jooq (Lukas Eder) Advanced
jOOQ's R2DBC LoggingConnection to log all SQL statements
jOOQ already has a LoggingConnection (see also the manual), which acts as a JDBC proxy Connection to log all SQL statements that are execute...
17-01-2023 12:39:05 jooq (Lukas Eder) Advanced
When to Use jOOQ and When to Use Native SQL
A frequently encountered doubt people have when using jOOQ is to decide when a "complex" query should be written using jOOQ API vs. when it ...
08-12-2022 15:27:25 jooq (Lukas Eder) Advanced
LATERAL is Your Friend to Create Local Column Variables in SQL
The standard SQL WITH clause has been tremendously helpful in structuring SQL queries. Instead of nesting everything in unreadable derived t...
04-11-2022 10:24:08 jooq (Lukas Eder) Advanced
Calling Procedures with Default Parameters using JDBC or jOOQ
Using jOOQ's code generator to call stored procedures is a popular reason to use jOOQ. For example, when you have a procedure like the follo...
21-10-2022 17:50:10 jooq (Lukas Eder) Advanced
Using jOOQ's Implicit Join From Within the JOIN .. ON Clause
Starting with jOOQ 3.11, type safe implicit JOIN have been made available, and they've been enhanced to be supported also in DML statements ...
13-09-2022 10:51:01 jooq (Lukas Eder) Advanced
A Brief Overview over the Most Common jOOQ Types
For new users working with jOOQ for the first time, the number of types in the jOOQ API can be overwhelming. The SQL language doesn't have m...
06-09-2022 15:30:39 jooq (Lukas Eder) Advanced
How to Plot an ASCII Bar Chart with SQL
No need for expensive Tableau subscriptions. Ditch Microsoft Excel. Just use native PostgreSQL to quickly visualise your data! Here's an ide...
01-09-2022 11:39:32 jooq (Lukas Eder) Advanced

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.

Made better & faster using Java Profiler