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:
[ Parent
| on HN ]
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).