simpleflatmapper.org

What It Is

SimpleFlatMapper is a high-performance object mapping tool for Java, positioned somewhere between a lightweight mapper and a micro ORM. It can map JDBC ResultSet data to objects, supports PreparedStatement binding, and also provides a CSV Mapper, built-in CSV Parser, Excel spreadsheet support, and Cassandra Datastax use cases. The examples show that developers can build mappers directly via CsvParser.mapTo() or JdbcMapperFactory.newMapper().

Core Capabilities and Ecosystem

Its main strength is broad coverage of the Java data-access ecosystem: it integrates with jOOQ, Spring JDBC, JDBI/JDBI3, Sql2o, and QueryDSL, and provides modules such as sfm-jdbc, sfm-csv, sfm-jooq, sfm-springjdbc, and sfm-poi. In terms of mapping capabilities, it supports constructors, setters, public field injection, the Builder Pattern, deep object structures, Tuple, List, Array, Map, Google Protocol Buffers, as well as JPA and Datastax @Column. By default, it emphasizes “no annotations, no configuration,” while still allowing behavior to be customized programmatically and type mappings to be extended through converters.

Pricing and Open Source

The page does not provide commercial pricing, paid editions, or enterprise support information. It includes references to GitHub issues, Maven, Javadoc, Google Groups, and similar resources, so it appears to be more of an open-source Java library. However, the license is not explicitly stated in the reviewed text, so enterprises should verify the license and maintenance status before adoption.

Pros and Cons

The advantages are that it is lightweight, broadly integrated, and has a straightforward API, making it suitable for projects that do not want to introduce a heavy ORM but need something more efficient than handwritten RowMapper code. The CSV module also emphasizes a very fast Java CSV parser. The drawbacks are that the listed Java version support only goes up to 10, and some known issues—such as Spring Boot 1.4.3 and IntelliJ importer problems—are quite dated. Project activity and compatibility with modern JDKs need additional verification. The documentation has multiple entry points but is somewhat scattered.

Best Fit and Access from China

It is a good fit for Java backend developers, data import/export workflows, reporting, batch processing, and users of jOOQ, Spring JDBC, or JDBI. If a team already uses MyBatis or a full ORM, it should assess whether migration would bring enough value. The reviewed text does not mention access from China; GitHub and Maven-related resources may be affected by local network conditions. There is no payment information. Alternatives include MyBatis, Jdbi, jOOQ, Spring JDBC RowMapper, MapStruct, OpenCSV, and Apache Commons CSV.