I was able to use batch insert for exposed, but wh...

# exposed

[Timur Atakishiev]

I was able to use batch insert for exposed, but when I am adding

transaction {
            addLogger(StdOutSqlLogger)
            SomeTable.batchInsert(data = listOf(1,2,3,4)) {
                this[SomeTable.someColumn] = it
            }

SQL logger shows multiple sql inserts(number of insrets = list.size)
Should not it be one insert with multiple values? Or is it StdOutLogger problems?

[spand]

Afaik not all databases support batch insert

[spand]

What are you using?

[Timur Atakishiev]

postgre

[Timur Atakishiev]

I think it should

[Timur Atakishiev]

any idea?

[tapac]

Exposed uses jdbc batching and all other things are implemented by jdbc-driver. For example, mysql driver has connection option to enable sending batches in a one statement )
Looks like there is similar one for PostgreSQL https://vladmihalcea.com/postgresql-multi-row-insert-rewritebatchedinserts-property/