Here’s an observation, not sure if it’s even interesting. So next.jdbc has some good documentation on how to work with pg jsonb. But, all the examples sort of assume that you’re only storing non-scalar values, because the examples rely on metadata to pass values back and forth. I had to fight this just a bit because we have some columns where we store scalar values as jsonb (don’t ask wh 🙂 I worked around it in perhaps not the prittiest way, but, I though it was worth metioning. Eg for reading I ended up with this little bit of code:

(defn- <-pgobject
  "Transform PGobject containing `json` or `jsonb` value to Clojure
  data."
  [^org.postgresql.util.PGobject v]
  (let [type (.getType v)
        value (.getValue v)]
    (if (#{"jsonb" "json"} type)
      (when value
        (let [json-value (<-json value)]
          (cond-> json-value
            (instance? clojure.lang.IMeta json-value)
                   (with-meta {:pgtype type}))))
      value)))