is clojure.java.jdbc tied to any specific org.postgres jdbc version?

is it safe to use the latest postgres jdbc version?

@djtango it is tested against whatever version is in the project's deps.edn file but should work with any recent version.

(I'm not at my desk right now to look up what version that is)

That's no problem have just jumped into the repo and found the deps.edn - thank you!

We just realised that our existing postgres jdbc driver is like 3 years old

and so a large jump in versions is somewhat scary

Thanks for the heads up!

@djtango if you use a connection pooling library, then you'll probably want to check it's recommendations for setting it up with postgres, the postgres JDBC driver has had a number of improvements in the last 3 years that require less specific changes to work optimally in pools (namely, I believe the support for jdbc4's connection checking was added, which means you don't need to set a default query to check the connection status anymore)

could be wrong about that...but that's what my overly faulty memory is thinking, so can't hurt to check it out

oo thank you that's great insight

we're using HikariCP

so will definitely also check how those two interrelate

the hikariCP author had a change in the postgres driver that got merged last year ( https://github.com/pgjdbc/pgjdbc/pull/849 ) , but you'll benefit from that without having to do any configuration changes