sql

All things SQL and JDBC...
wotbrew 2020-12-11T13:38:55.480Z

Does there exist any pair of functions to move from next.jdbc connectable's to clojure.java.jdbc maps (and vice versa) correctly in all cases? e.g in transactions and so on. I'm thinking about being able to work with functions defined against next.jdbc in a project where the entire codebase uses the old db spec format.

2020-12-11T17:07:00.481600Z

it is complicated because connectables to connection spec maps is kind of a bidirectional many to many relationship. clojure.java.jdbc accepts many different formats of connection spec maps

2020-12-11T17:08:18.482900Z

at work we have a clojure.java.jdbc setup with a connection pool that results in a connection map that is just {:datasource ....} so to pass that to next.jdbc we just (:datasource ...)

2020-12-11T17:08:46.483400Z

but we don't mix and match in one transaction