3 ms·
> Do you hand-roll your own caching mechanism when just writing plain SQL? Using something like jOOQ has meant I rarely need any caching, unlike Hibernate wher
by matwood 10y ago
> Do you hand-roll your own caching mechanism when just writing plain SQL?
Using something like jOOQ has meant I rarely need any caching, unlike Hibernate where caching almost seems required.
- mindcrime 10y agoInteresting. I've never used jOOQ, but I'll give it a look. Hibernate has worked well for me, but I'm not dogmatic about it. Always interested to try new tools.
- matwood 10y agoI've been writing SQL for almost 20 years, so the pain for me is the grunt mapping of data to and from. jOOQ does much of the grunt work of mapping, and lets me write typed SQL that it smartly translates to queries. More advanced features like various types of fetch make my job even easier. https://www.jooq.org/doc/3.9/manual-single-page/#arrays-maps-and-lists https://www.jooq.org/doc/3.9/manual-single-page/#arrays-maps...