sql

All things SQL and JDBC...
Jivago Alves 2020-03-19T16:20:49.246200Z

Greeting folks! We’re using next.jdbc in our app. Is there a way to “automagically” turn Clojure vectors into Postgres’ array type and vice-versa? We’ve done that for jsonb , however I can’t find any example for array in the docs. Thanks!

seancorfield 2020-03-19T17:03:08.247400Z

@jivagoalves Look at SettableParameter and ReadableColumn protocols in the docs. There's an example for json/`jsonb` in the Tips & Tricks page -- something similar should work for vectors/PG arrays.

Jivago Alves 2020-03-19T19:30:46.247900Z

We’ll take a look at that. Thanks @seancorfield!