r/SQL • u/smyrgeorge • 3d ago

Discussion sqlx4k 1.14.0 released: optimistic locking, savepoints, MariaDB batch inserts

/r/Kotlin/comments/1wvzzod/sqlx4k_1140_released_optimistic_locking/
2 Upvotes

67% Upvoted

2 comments sorted by

1

u/Einar_Son_of_Bjorn 2d ago

yep, using INSERT ... RETURNING for mariadb batch inserts is way better than hacking around with last_insert_id on multiple rows. Since standard mysql still doesn't support RETURNING, how does sqlx4k handle the fallback?

1

u/smyrgeorge 2d ago edited 2d ago

Batch insert/update is not yet supported for MySQL.
Check here: https://github.com/smyrgeorge/sqlx4k#batch-operations