A light-weight ORM kind of wrapper over the SQL2O
This wrapper allows you to Query database. a simple DSL syntax, supports multiple databases, integrates well with Java8.
Sql2o is a small java library, with the purpose of making database interaction easy. When fetching data from the database, the ResultSet will automatically be filled into your POJO objects.
Kind of like an ORM, but without the SQL generation capabilities.
Execute 1000 SELECT statements against a DB and map the data returned to a POJO. Code is available here.
| Method | Duration |
|---|---|
Hand coded ResultSet |
60ms |
| Sql2o | 75ms (25% slower) |
| Apache DbUtils | 98ms (63% slower) |
| JDBI | 197ms (228% slower) |
| MyBatis | 293ms (388% slower) |
| jOOQ | 447ms (645% slower) |
| Hibernate | 494ms (723% slower) |
| Spring JdbcTemplate | 636ms (960% slower) |
Inspired by the project https://github.com/biezhi/anima
Baseline is written based on that project and fixed few issues and maintaining seperately