News for hackers. Stuff that matters.
Re:12 requests per second: A realistic look at Python web fr... by shock-value on Friday February 19, 2021 @01:51AM (#26190442)
Another great option in Java is jOOQ, which lets you write type-safe and potentially composable queries such as:

  context
    .update(User.USER)
    .set(User.USER.NAME, userName)
    .where(User.USER.ID.eq(userId))
    .execute()
Re:12 requests per second: A realistic look at Python web fr... by alex-lx on Friday February 19, 2021 @04:09AM (#26191085)
jOOQ and its DSL is good, however IMO it's more readable using raw SQL (by using `context.fetchInto` and its variants) than to using DSL when deal with complex query.
Re:12 requests per second: A realistic look at Python web fr... by jwdunne on Friday February 19, 2021 @04:41AM (#26191264)
I’ve noticed this in other contexts too.

For small queries with straight forward joins, a query builder is nice and readable.

But for larger, more complex queries, I found putting the query into its own file was best for readability.

Re:12 requests per second: A realistic look at Python web fr... by lukaseder on Friday February 19, 2021 @03:26PM (#26197637)
Why not just create views and query those with jOOQ, then?
Re:12 requests per second: A realistic look at Python web fr... by alex-lx on Friday February 19, 2021 @08:33PM (#26200529)
hi, @lukaseder, Thank you for creating jOOQ. I don't have much experience on views, and some called `Best Practice` forbid to use that because it's hard to maintain. What do you think about that.
Re:12 requests per second: A realistic look at Python web fr... by JulianWasTaken on Friday February 19, 2021 @05:30AM (#26191538)
In Python this would look like sqlalchemy's query layer (which is great).