Kotlin + jOOQ

[@toefel18]

Fantastic talk, what a library!

[@PairingWithDuncan]

I hope Lukas can help me compare jOOQ and Exposed.

[@HantsyBai]

JOOQ is so cool, we are using Spring Boot/R2dbc/Kotlin Coroutines/jOOQ in the current project, works well till now.

[@boygood4830]

we love DSL😉

[@MsDuketown]

did you add Ghidra? And I'd assume it's easy to hook up some workflows from Github, Azure & Amazon AWS?

[@motalibmiah8616]

Fantastic, we can do whatever we want. very flexible

[@JS-fd5oh]

FROM must be the first statement. Same must have been done in SQL from the beginning. Then writing select would be much easier once you've specified the source. Unfortunately, it's upside down even in jooq that I have to write select first.

[@lukas_eder]

That has been a short sighted claim of many competing APIs that support simple SELECT, FROM, WHERE, perhaps JOIN, but none of the really sophisticated, advanced SQL features. It's really hard to "fix" this today now that SQL has evolved so much based on the old "flawed" syntax, and it's by far not the only, or most important flaw. For example, even if you invert the lexical order of operations, you'd still have all the weird intertwined logical order of operations of window functions, aggregate functions, group by, distinct/order by and other gimmicks. So, either, do something like Slick in Scala and *completely* re-invent the query language, or mimick SQL *1:1* like jOOQ to increase effectiveness of SQL power users. jOOQ is for the latter audience.

[@MsDuketown]

​@@lukas_eder With "flawed" syntax you mean unsafe syntax? So the supposed "fix" was a feature. And I don't see any direct relation to requirement-free GNU FriBidi library, which doesn't provide syntax but implements the Unicode Bidirectional Algorithm. So ofc, everything is inter-twined; it's compiled. It allows for GNU/Linux "distro-disco" features at config time. As for re-inventint query language? There is only one sane approach: FROM must be the first statement. Then writing a SELECT statement only requires specifying the source, just like JOOQ only needs a DataSource.

[@jorgeluisricraalcantara809]

I love kotlin

[@shivamsingh1221]

Great video. Can you share the code please? I would like to understand the code better.

[@lukas_eder]

The demo code is here: github.com/jOOQ/demo. It currently works with a 3.17.0-SNAPSHOT version of jOOQ, which you'll have to build first (this will be simpler, in the future). Alternatively, you can work with examples here: github.com/jOOQ/jOOQ/tree/main/jOOQ-examples

[@hareepjoshi]

Everyone learned a thing or two, including Anton 😂

[@AntonArhipov]

I learn a thing or two on every stream!

[@hareepjoshi]

@@AntonArhipov cheers to that. Just pulling your leg.