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