Hacker News Reader

Cheers mate! That createQuery() call looks to be exactly what I need (query safety on a low level JDBC stream object).

A second shoutout for JDBI. I don't attempt to use it for anything fancy, but it hides a lot of the JDBI boilerplate in a very sane way.

We use JDBI @Truecaller together with Metrics library. Not only it is clean and tidy, it also gives you immediate profiling around your database calls. This is priceless in a big service oriented environment. With it, you can exactly see the rate of happening (mean/last 1/5/15 minutes average) and latency (mean/avg/std-dev/75/95/98/99/99,9percentiles) for each database query. I wouldn't want to go back to manual logging and optimization hell. JDBI+Metrics opens a totally new dimension to your monitoring/profiling/optimization!

Checkout Dalesbred, http://dalesbred.evident.fi/

It's our in-house jdbc library, and has IDEA plugin. We use it in many small projects, and in one major.

This might be of interest to you:

https://github.com/gilesjb/copalis.sql