1.5.1

Release Notes - Version 1.5.1

This release includes several refactorings for consistency across database modules, improvements to transaction handling, new features for PGMQ, and various dependency updates.

🚀 Features

• PGMQ Improvements: Added support for installing the PGMQ extension directly from SQL files.
• Result Set Extensions: Added unsigned number type extensions to ResultSet.Row.Column for better type support.
• Enhanced Error Reporting: SQLError now supports nested exceptions, providing more detailed error reporting.

🛠️ Improvements & Refactoring

• Consistent Naming: Refactored connection and transaction classes to use consistent Sqlx and Native prefixes across MySQL, PostgreSQL, and SQLite modules.
• Transaction Handling: Improved rollback error handling and separated commit logic from the main try-catch block for better reliability.
• Transaction Error Codes: Added specific error codes for transaction commit and rollback failures.
• Optimization: Optimized schema check queries and re-enabled consumer tests in both JVM and Native test suites.
• PGMQ Configuration: Updated the PGMQ GitHub organization reference.

🐞 Bug Fixes

• Fixed a typo in libs.versions.toml and build scripts, correcting kotlinx-serialisation to kotlinx-serialization.

🔄 Dependency Updates

• Kotlin: Updated to 2.3.0.
• Gradle: Updated to 9.2.1.
• KSP: Updated from 2.3.2 to 2.3.4.
• Spring Boot: Updated from 3.5.7 to 4.0.1.
• Kotlinx Libraries: Updated kotlinx-io (to 0.8.1) and kotlinx-datetime.
• SQLite JDBC: Updated from 3.51.0.0 to 3.51.1.0.
• GitHub Actions: Updated actions/cache to v5 and actions/checkout to v6.
• Publish Plugin: Updated from 0.34.0 to 0.35.0.

New Contributors

• @ChuckHend made their first contribution in #73

Full Changelog: 1.5.0...1.5.1