Fork me on GitHub
#sql
<
2017-06-19
>
bja19:06:59

@petr.mensik I would suggest raw java.jdbc or honeysql with postgresql using jsonb stuff. We have a similar update that looks like:

(fn [id tag] (-> (sql/update :foo) (sql/sset {:tags (jsonb-append :tags tag)}) (sql/where [:= :id id)))
where (require '[honeysql.helpers :as sql])

bja19:06:26

that builds a nice map that can be fed into honeysql.core/format to output a clojure.java.jdbc-compatible vector with proper params passing