Blog: jooq (Lukas Eder)

210 blogs updated: 20 min. ago
Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ
SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR...
05-05-2020 18:55:07 jooq (Lukas Eder) Advanced
The Many Flavours of the Arcane SQL MERGE Statement
The SQL MERGE statement is a device whose mystery is only exceeded by its power. A simple example shows its full power according to standard...
10-04-2020 11:40:54 jooq (Lukas Eder) Advanced
What's a "String" in the jOOQ API?
One of jOOQ's biggest strength is the fact that it is a type safe SQL API. "Type safe", in this context, means that every object that you pu...
03-04-2020 11:38:52 jooq (Lukas Eder) Advanced
Create Empty Optional SQL Clauses with jOOQ
When using jOOQ to create dynamic SQL statements (one of jOOQ's core value propositions), it is often necessary to add query elements condit...
06-03-2020 13:03:02 jooq (Lukas Eder) Advanced
Using Java 13+ Text Blocks for Plain SQL with jOOQ
Most jOOQ users use the jOOQ DSL API, which provides compile time type safety and an easy way to write dynamic SQL. But occasionally, this D...
05-03-2020 14:56:13 jooq (Lukas Eder) Advanced
Never Concatenate Strings With jOOQ
jOOQ supports a vast amount of SQL syntax out of the box. As such, most users will not think of resorting to string concatenation like in th...
04-03-2020 17:23:47 jooq (Lukas Eder) Advanced
Better Understand SQL by Adding Optional Parentheses
It appears that our recent beginner SQL articles explaining SQL syntax were quite popular. These include: A Beginner's Guide to the True Ord...
03-03-2020 16:03:42 jooq (Lukas Eder) Advanced
SQL DISTINCT is not a function
A very common misconception I often encounter with SQL users is the idea that DISTINCT is something like a function, and that it can take pa...
02-03-2020 09:56:28 jooq (Lukas Eder) Advanced
Use the jOOQ-Refaster Module for Automatic Migration off of Deprecated jOOQ API
Starting with jOOQ 3.13, we're offering a new module called jOOQ Refaster, which provides refaster templates for automatic API migration. Wh...
25-02-2020 13:27:30 jooq (Lukas Eder) Advanced
jOOQ 3.13 Released with More API and Tooling for DDL Management
jOOQ 3.13 has been released with CockroachDB support, much more API and tooling for DDL management, and SQL:2011 temporal table support Star...
14-02-2020 18:31:56 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.