Did you look at next.jdbc/execute-batch! ? Do you have a specific question about how to use it?

So i am using it for inserts but it doesn't seem to work for delete

i will show you what i am doing maybe I am doing something dumb in this context

(jdbc/execute-batch! db "delete from table where key1 = ? and key2 = ?"
                         data
                         {:rewriteBatchInserts true})

[[key key2]]

for the data

And db is...?

the connection/component

Can't infer the SQL type to use for an instance of clojure.lang.PersistentVector. Use setObject() with an explicit Types value to specify the type to use.

@U04V70XH6 IGNORE Me! I got it working. I forgot to source the code that I changed into the batch statement, lol

One thing to watch out for: `rewriteBatchInserts` reWriteBatchedInserts needs to be on the JDBC connection string (URL) so if you are using a pooled datasource, you need to specify it when that is created, not on operations that use those connections.

oh, good to know!

And I think it's actually reWriteBatchedInserts for PostgreSQL, looking at some search results (I do not use PG so the docs are based on what people have told me)

Ah, yes, the docs are correct: :rewriteBatchedStatements for MySQL and :reWriteBatchedInserts for PostgreSQL... so it may not matter for PG since you're not doing inserts -- but execute-batch! should still help for those delete statements.

cool, i will make the adjustment to add it to the connection pool

@U04V70XH6 would the rewriteBatchInserts go under

:datasourceProperties

How exactly are you creating the connection pool? Are you using the next.jdbc.connection/->pool or component calls?

yep

(defrecord Database [db-spec     ; configuration
                     init-fn     ; callback to initialize the database
                     datasource] ; state

  component/Lifecycle
  (start [this]
    (log/info "Starting Database of type " (:dbtype db-spec))     
    (if datasource
      this ; already initialized
      (let [database (assoc this :datasource (connection/->pool HikariDataSource db-spec))]
        ;; set up database if necessary
        (log/info "testing db connection")
        (.close (jdbc/get-connection (:datasource database))) ;;ensure connection and datasource setup correctly
        (log/info "Connection pool established")
        (when init-fn
          (log/info "Initializing DB") 
          (init-fn database))
        (log/info "Database started")
        database)))
  (stop [this]
    (assoc this :datasource nil))

if thats the spot i would just add it to that key on the

db-spec

Yup, that would be the place. You know that next.jdbc.connection/component will build that for you? https://cljdoc.org/d/com.github.seancorfield/next.jdbc/1.3.847/api/next.jdbc.connection#component

I did not

It doesn't have the init-fn tho'... that's an interesting idea... I could add that as an option to n.j.c/component 🙂

https://github.com/seancorfield/next-jdbc/issues/237

I think modeled that after your user polylith example so I can't take credit for that, lol.