Blog: jooq (Lukas Eder)

222 blogs updated: 15 min. ago show: latest top this week top this month search:

Use IN List Padding to Your JDBC Application to Avoid Cursor Cache Contention Problems A problem few developers are aware of is the possibility of running into "cursor cache contention" or "execution plan cache contention" prob... 13 22-04-2021 11:37:47 jooq (Lukas Eder) Advanced

Never Again Forget to Call .execute() in jOOQ jOOQ's DSL, like any fluent API, has one big caveat. It's very easy to forget to call .execute(). And when you do, chances are, you're going... 17 30-03-2021 17:50:10 jooq (Lukas Eder) Advanced

Calculating Pagination Metadata Without Extra Roundtrips in SQL When paginating results in SQL, we use standard SQL OFFSET .. FETCH or a vendor specific version of it, such as LIMIT .. OFFSET. For example... 17 11-03-2021 11:03:07 jooq (Lukas Eder) Advanced

Simulating Latency with SQL / JDBC I've run across a fun little trick to simulate latency in your development environments when testing some SQL queries. Possible use-cases in... 19 15-02-2021 10:54:00 jooq (Lukas Eder) Advanced

Translating Stored Procedures Between Dialects In the past years, we've invested a lot of effort into improving our procedural language capabilities in jOOQ. What started with a simple in... 4 10-02-2021 14:23:35 jooq (Lukas Eder) Advanced

Implementing a generic REDUCE aggregate function with SQL So, @rotnroll666 nerd sniped me again. Apparently, the Neo4j Cypher query language supports arbitrary reductions, just like any functional c... 15 08-02-2021 18:51:08 jooq (Lukas Eder) Advanced

jOOQ Internals: Pushing up SQL fragments Over the past 13 years, jOOQ has accrued quite some internal features, which you, the user, are not exposed to. One very interesting feature... 15 04-02-2021 14:49:15 jooq (Lukas Eder) Advanced

Automatically Transform Oracle Style Implicit Joins to ANSI JOIN using jOOQ While jOOQ is mostly being used as an internal SQL DSL for embedded, dynamic SQL in Java, where it offers the best solution on the market, j... 3 17-11-2020 21:21:51 jooq (Lukas Eder) Advanced

jOOQ 3.14 Released With SQL/XML and SQL/JSON Support jOOQ 3.14 has been released with support for SQL/XML, SQL/JSON, Kotlin code generation, embeddable types, and domain types, synthetic constr... 18 20-10-2020 14:29:19 jooq (Lukas Eder) Advanced

Using jOOQ 3.14 Synthetic Foreign Keys to Write Implicit Joins on Views jOOQ has supported one of JPQL's most cool features for a while now: implicit joins. Using jOOQ, you can navigate your to-one relationships ... 10 14-10-2020 02:09:27 jooq (Lukas Eder) Advanced

load next 10 items

© 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 https://www.yourkit.com/ Java Profiler