I'm happy to announce that Sql2o 1.7.0 was finally released today.

[aaberg]

It’s been quite a few years since the last release of Sql2o. During that time, I’ve had many questions about its future. Some have understandably been worried about using Sql2o in their systems because of missing updates, and others have expressed a desire for the project to be maintained because it still solves an issue with JDBC being too expressive. Also, according to the Nexus repository manager used by Maven Central, artefacts in the org.sql2o group have about 100,000 downloads each month, which tells me that the project should have a future.

With that in mind, I’m happy to announce that Sql20 version 1.7.0 was released today. The focus of this release has been to ensure that everything in Sql2o works as expected with all newer LTS versions of Java and to remove the obstacles to testing and deploying the library, making it easier to release new versions in the future.

The project now has a GitHub Actions pipeline that does the following:
• Spins up a testing environment with Docker Compose that contains both a Postgres and an Oracle database.
• Builds and runs all unit tests and integration tests against H2, HSQL, Postgres and Oracle. Tests are repeated with Java 21, 17 and 11 to ensure everything works as expected for all newer LTS versions.
• When a release is made in GitHub, the library is automatically built, packaged, signed and deployed to Maven Central.

This greatly simplifies the deployment of future releases and should make it easier to approve and merge pull requests.

Moving forward, the focus will be on the following:
• Further improve testing by adding tests for DB2, MS SQL Server and My SQL.
• Restructuring the test classes with a better distinction between unit tests and integration tests.
• Native support for Spring Boot.
• Improving documentation.