Fork me on GitHub
#honeysql
<
2021-07-09
>
pinealan02:07:14

I’m trying to use honeysql to format an insert Prepared Statement with next.jdbc/execute-batch!, how that seems not possible since honey.sql needs all the values up front to format the sql string appropriately, and I’m stuck using next.jdbc/execute!. Are there idioms that I’m missing which would make things easier? Should I even be concerned with using execute-batch!?

seancorfield02:07:17

execute-batch! exists for a very specific purpose, namely "repeating" the same statement -- typically an insert -- with lots (and often LOTS) of groups of parameters.

seancorfield02:07:00

HoneySQL is designed to help you programmatically create single SQL statements with a (single) group of parameters.

pinealan06:07:03

thanks ya I think I can stick with honeysql and use partition with doseq and achieve a similar factor of optimisation