sqlx4k `1.14.0` released: optimistic locking, save...

# server

[Yorgos S.]

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

sqlx4k is a coroutine-first SQL toolkit for Kotlin Multiplatform (PostgreSQL, MySQL/MariaDB, SQLite) with compile-time SQL validation via KSP.

New in 1.14.0
• Optimistic locking with `@Version`: generated `update`/`delete` check the version and fail with OptimisticLockFailed on conflicts. In-memory test repositories behave the same.
• Transaction savepoints: roll back part of a transaction with a scoped savepoint { ... } block or the explicit `savepoint`/`rollbackToSavepoint`/`releaseSavepoint` calls.
• MariaDB dialect: batchInsert via multi-row INSERT ... RETURNING (10.5+).
• Cancellation-safe transactions: cancelling a coroutine mid-transaction now rolls back properly.
• Kotlin 2.4.20, KSP 2.3.12.
Repo: github.com/smyrgeorge/sqlx4k
Release notes: github.com/smyrgeorge/sqlx4k/…/1.14.0
Slack Conversation