Lukas Eder
@lukaseder.bsky.social
Java Champion, creator of jOOQ, the best way to write SQL in Java.
Will mostly post about Java, SQL, jOOQ, programming humour, and write at https://blog.jooq.org
Will mostly post about Java, SQL, jOOQ, programming humour, and write at https://blog.jooq.org
Pinned
Due to the Liquibase license change to the FSL, I've deprecated the LiquibaseDatabase, which is used for jOOQ code generation:
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
Deprecate LiquibaseDatabase · Issue #19353 · jOOQ/jOOQ
The LiquibaseDatabase includes a liquibase dependency on version 4.x of Liquibase: https://www.jooq.org/doc/latest/manual/code-generation/codegen-meta-sources/codegen-liquibase/ This issue has show...
github.com
November 10, 2025 at 1:31 PM
Due to the Liquibase license change to the FSL, I've deprecated the LiquibaseDatabase, which is used for jOOQ code generation:
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
Some RDBMS have a weird understanding of case sensitivity in identifiers.
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
November 6, 2025 at 3:20 PM
Some RDBMS have a weird understanding of case sensitivity in identifiers.
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
Reposted by Lukas Eder
This is... something:
aws.amazon.com/de/blogs/big...
aws.amazon.com/de/blogs/big...
Amazon Redshift Python user-defined functions will reach end of support after June 30, 2026 | Amazon Web Services
The Amazon Redshift integration with AWS Lambda provides the capability to create Amazon Redshift Lambda user-defined functions (UDFs). Because Lambda UDFs provide these significant advantages in inte...
aws.amazon.com
October 30, 2025 at 1:16 PM
This is... something:
aws.amazon.com/de/blogs/big...
aws.amazon.com/de/blogs/big...
What do you folks think? Is this a good email footer?
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
October 29, 2025 at 12:53 PM
What do you folks think? Is this a good email footer?
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
What on earth is AWS Clean Rooms SQL??
docs.aws.amazon.com/clean-rooms/...
docs.aws.amazon.com/clean-rooms/...
Overview of SQL in AWS Clean Rooms - AWS Clean Rooms
Learn about the types of SQL functions you can use in AWS Clean Rooms.
docs.aws.amazon.com
October 29, 2025 at 8:49 AM
What on earth is AWS Clean Rooms SQL??
docs.aws.amazon.com/clean-rooms/...
docs.aws.amazon.com/clean-rooms/...
Recursive generics are so tricky to grasp because they rely on grasping recursive generics.
October 23, 2025 at 12:18 PM
Recursive generics are so tricky to grasp because they rely on grasping recursive generics.
Did we as an industry just collectively agree that "bouncy castle" is a very secure sounding term for a "security provider," yes?
downloads.bouncycastle.org/java/docs/bc...
downloads.bouncycastle.org/java/docs/bc...
BouncyCastleProvider (Bouncy Castle Library 1.81 API Specification)
downloads.bouncycastle.org
October 20, 2025 at 1:11 PM
Did we as an industry just collectively agree that "bouncy castle" is a very secure sounding term for a "security provider," yes?
downloads.bouncycastle.org/java/docs/bc...
downloads.bouncycastle.org/java/docs/bc...
So, we now have:
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
October 20, 2025 at 12:13 PM
So, we now have:
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
Reposted by Lukas Eder
Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
October 20, 2025 at 11:02 AM
Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
Well, that's something! The Derby Database is unsupported ("retired"). It has been around forever, I'm kinda feeling nostalgic about this...
issues.apache.org/jira/browse/...
issues.apache.org/jira/browse/...
[DERBY-7177] Retire Derby - ASF JIRA
issues.apache.org
October 16, 2025 at 8:52 AM
Well, that's something! The Derby Database is unsupported ("retired"). It has been around forever, I'm kinda feeling nostalgic about this...
issues.apache.org/jira/browse/...
issues.apache.org/jira/browse/...
Q: Does your RDBMS use zero-based or one-based indexing?
A: Yes
A: Yes
October 10, 2025 at 12:31 PM
Q: Does your RDBMS use zero-based or one-based indexing?
A: Yes
A: Yes
Reposted by Lukas Eder
Are you making any of these common #SQL mistakes?
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
10 Common Mistakes Java Developers Make when Writing SQL
This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java develop…
buff.ly
October 8, 2025 at 11:02 AM
Are you making any of these common #SQL mistakes?
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
Thanks to a sponsor, the upcoming jOOQ 3.21 will have support for the Google Spanner dialect! github.com/jOOQ/jOOQ/is...
Add support for Google Spanner · Issue #11454 · jOOQ/jOOQ
This SQL dialect might be worth exploring: https://cloud.google.com/spanner/docs/query-syntax Apparently, there's a local emulator which could be very useful for integration testing: https://cloud....
github.com
October 8, 2025 at 10:08 AM
Thanks to a sponsor, the upcoming jOOQ 3.21 will have support for the Google Spanner dialect! github.com/jOOQ/jOOQ/is...
This always struck me as one of the biggest cognitive dissonances in programming style guides
October 8, 2025 at 7:44 AM
This always struck me as one of the biggest cognitive dissonances in programming style guides
Found an actual German word de.wikipedia.org/wiki/Lieferk...
Lieferkettensorgfaltspflichtengesetz – Wikipedia
de.wikipedia.org
October 3, 2025 at 8:18 AM
Found an actual German word de.wikipedia.org/wiki/Lieferk...
Writing a CREATE TABLE statement in SQL be like
September 30, 2025 at 12:21 PM
Writing a CREATE TABLE statement in SQL be like
Whaat, a Java record component cannot be deprecated by Javadoc, only by annotation? That looks like a bug in javac to me, no? The JLS doesn't mention Javadoc explicitly: docs.oracle.com/javase/specs...
September 29, 2025 at 11:49 AM
Whaat, a Java record component cannot be deprecated by Javadoc, only by annotation? That looks like a bug in javac to me, no? The JLS doesn't mention Javadoc explicitly: docs.oracle.com/javase/specs...
Reposted by Lukas Eder
Back to SQL: How jOOQ puts you in the driver's seat with @martinelli.ch
www.youtube.com/watch?v=QZ8S...
www.youtube.com/watch?v=QZ8S...
Back to SQL: How jOOQ Puts You in the Driver’s Seat
YouTube video by CyberJAR
www.youtube.com
September 25, 2025 at 12:29 PM
Back to SQL: How jOOQ puts you in the driver's seat with @martinelli.ch
www.youtube.com/watch?v=QZ8S...
www.youtube.com/watch?v=QZ8S...
Every time I write new integration test for a jOOQ bug, I also write an integration test for an RDBMS bug
September 24, 2025 at 1:56 PM
Every time I write new integration test for a jOOQ bug, I also write an integration test for an RDBMS bug
Every. Time. Why. Does. It. Complain. 😬
Oooh, that's why. 😅
Oooh, that's why. 😅
September 24, 2025 at 7:29 AM
Every. Time. Why. Does. It. Complain. 😬
Oooh, that's why. 😅
Oooh, that's why. 😅
This sounds like my recent experience with OSGi tutorials
September 24, 2025 at 6:19 AM
This sounds like my recent experience with OSGi tutorials
"5 HoUrS oF TrIaL AnD ErRoR SaVeS YoU 10 MiNuTeS oF ReAdInG ThE DoCuMeNtAtIoN."
The documentation:
The documentation:
September 17, 2025 at 9:16 AM
"5 HoUrS oF TrIaL AnD ErRoR SaVeS YoU 10 MiNuTeS oF ReAdInG ThE DoCuMeNtAtIoN."
The documentation:
The documentation:
Debugging jOOQ bugs be like
September 16, 2025 at 1:13 PM
Debugging jOOQ bugs be like
PostgreSQL. Why do you betray me? Where are my nulls??
September 16, 2025 at 12:26 PM
PostgreSQL. Why do you betray me? Where are my nulls??