sql

All things SQL and JDBC...
synthomat 2020-07-12T10:49:07.217Z

Hey, I try to convert a clojure object vec (or ISeq?) to a database type PgArray using next-jdbc ; Converting from PgArray to clojure type can be done using the ReadableColumn protocol. But what’s the counterpart to convert a clojure type to a database type? Is it SettableParameter or Executable or am I re-inventing the wheel?

synthomat 2020-07-12T10:55:44.217600Z

oh looks like it’s indeed the correct thingy to do; I just had a weird error because I missed another thing…

synthomat 2020-07-12T11:06:58.217800Z

yay

seancorfield 2020-07-12T19:16:52.218500Z

@synthomat Sounds like you don't need help now but for the future that is all covered in the docs https://cljdoc.org/d/seancorfield/next.jdbc/1.1.569/doc/getting-started/tips-tricks#working-with-arrays specifically for PostgreSQL.