Blog: jooq (Lukas Eder) |
|
210 blogs
updated: 729 min. ago
|
||
|
I was asked a very interesting question on Twitter just now: @lukaseder quick q: in pg can I have a composite foreign key where one value is...
|
||
|
There are a few ways to compare two similar tables in SQL. Assuming PostgreSQL syntax, we might have this schema: It is now possible to use ...
|
||
|
I just fixed a bug. The fix required me to initialise an Object[] array with the init values for each type, instead of just null, i.e. false...
|
||
|
SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR...
|
||
|
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...
|
||
|
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...
|
||
|
When using jOOQ to create dynamic SQL statements (one of jOOQ's core value propositions), it is often necessary to add query elements condit...
|
||
|
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...
|
||
|
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...
|
||
|
It appears that our recent beginner SQL articles explaining SQL syntax were quite popular. These include: A Beginner's Guide to the True Ord...
|
||