Lukas Eder

@lukaseder
1.1K Followers
10 Following
281 Posts

Java Champion, creator of https://jooq.org, the best way to write SQL in Java.

Will mostly tweet about Java, SQL, jOOQ, programming humour, and write at https://blog.jooq.org

Won't check Mastodon regularly, so best get in touch elsewhere!

Java
SQL
jOOQ
@rotnroll666 @duckdb @hannes Connection::prepareStatement, now that's a call I haven't seen in a while!
@rotnroll666 I have enough "told you so" at home already. No need for "told you so" at work 🤌
@rotnroll666 They don't work, because if you follow them, you'll write your own sucky SQL builder for the dynamic SQL, and it will suck so bad that the next developer will rip it out and replace it with jOOQ, 3 years later.

In case it's not clear where it works best: Whenever you need client side type safety, improved mapping, dialect agnosticity, dynamic SQL (and chances are, you'll write a lot of this, once you embrace jOOQ).

But again, jOOQ doesn't care if you're querying tables or complex views! Use those, too!

I keep seeing "hot" takes that instead of using jOOQ's DSL, people should just use native SQL.

That's just a silly false dichotomy. jOOQ *encourages* you to create views, stored procedures, plain SQL templates, etc.

Use the DSL where it works best for you *in addition* to native SQL!

It is not forbidden to put a UNIQUE constraint on a FOREIGN KEY if you're modelling a 0-1 relationship, i.e. if there's at most 1 child per parent.
@javahippie Yeah, huh, would you look at that

New episode: "jOOQ"

Michael and Nikolay are joined by @lukaseder, the creator of jOOQ, to discuss what it is, some nice developer experience features it has, and some fun things he's come across from a Postgres perspective.

🎧 https://postgres.fm/episodes/jooq

📺 https://youtu.be/73TmQjdvptg

Postgres FM | jOOQ

Michael and Nikolay are joined by Lukas Eder, the creator of jOOQ, to discuss what it is, some nice developer experience features it has, and some fun things he's come across from a Postgres perspe...

Postgres FM
The real reason why it's called "reactive" programming
When you discover a bug while investing a bug:
https://www.youtube.com/watch?v=AbSehcT19u0
Hal fixing a light bulb (from Malcolm in the Middle S03E06 - Health Scare)

I think this is pretty familiar for most of us.To everyone who watches this: please check out this youtube creator called nartharie . He has created some of ...

YouTube