Is there any documentation on how to use reducible-query?

@borkdude Not yet, sorry. It's on my list.

There are examples in the test suite https://wsnetworks.atlassian.net/browse/WS-9896

ok, because I think it replaces this right? https://stackoverflow.com/a/39775018/6264

And in the new performance tests https://github.com/clojure/java.jdbc/blob/master/src/perf/clojure/clojure/java/perf_jdbc.clj#L138

Yeah, several things have changed about that SO example: :fetch-size is passed through from query, you can set :auto-commit? false on anything that creates a connection (which could be query or with-db-connection etc).

And you can now reduce a reducible-query as a better way to deal with large result sets. Or any result sets 🙂

OK, I’d like to update my answer over there as soon as the docs come available. Thanks!

The problem with streaming result sets is that the settings you need are specific to each vendor's DB.

I see, so that’s why they become part of the query?

Well, some DBs need :auto-commit? false at the point that creates the connection, some don't. Some need a non-zero :fetch-size (on query or reducible-query or prepare-statement).

The point is to expose the various knobs that any DB needs -- but how you set those knobs depends on which DB you are using.

This was where I added :auto-commit? https://dev.clojure.org/jira/browse/JDBC-153 (and the ability to set a connection to readonly -- both options got ? for consistency)

Hugsql 0.4.8 is out! https://github.com/layerware/hugsql/releases/tag/0.4.8