JDBI VS Ebean ORM

While this may work for greenfield applications, I don't see this working well for preexisting schemas. From their getting started page: "Database fields are automatically created for any abstract getter methods", which definitely scares me away since they seem to be relying on automatic field type conversions. I prefer to manage my schemas when I can and do type and DAO conversions via mapper classes in the very... - Source: Hacker News / 7 months ago

Someone else mentioned jOOQ, but personally I also rather enjoyed JDBI3: https://jdbi.org/#_introduction_to_jdbi_3 It addresses the issues with using JDBC directly (not nice ergonomics), while still letting you work with SQL directly without too many abstractions in the middle. In combination with Dropwizard, it was pretty pleasant: https://www.dropwizard.io/en/stable/manual/jdbi3.html Other than that, I actually... - Source: Hacker News / 7 months ago

> I've been doing ORM on Java since Hibernate was new, and it has always sucked. Have you ever looked at something like myBatis? In particular, the XML mappers: https://mybatis.org/mybatis-3/dynamic-sql.html Looking back, I actually quite liked it - you had conditionals and ability to build queries dynamically (including snippets, doing loops etc.), while still writing mostly SQL with a bit of XML DSL around it,... - Source: Hacker News / 10 months ago

I found JDBi[1] to be a really nice balance between ORM and raw SQL. It gives me the flexibility I need but takes care of a lot of the boilerplate. It's almost like a third category. 1. http://jdbi.org. - Source: Hacker News / 11 months ago

You could use something like jdbi or mybatis. It's not as ugly as raw jdbc and easier to use without all of the gunk from an ORM like hibernate. Source: about 1 year ago

You can have a look at https://ebean.io/ ... Better control over the generated SQL, multiple levels of abstraction, can generate DB migrations and run the DB migrations, transparent encryption support, SQL 2011 history support, test against docker containers. Source: about 2 years ago

There is https://ebean.io/ and looks like it a community driven alternative to jOOQ. Source: over 2 years ago

Ebean ORM https://ebean.io/ was built to somewhat rival JPA (and JDBI) Btw: you can use java 16 records with ebean as DTOs, EmbeddedId and also as read only entity beans (and JPA implementations could similarly do so). Source: over 2 years ago

I wouldn't call it micro, but https://ebean.io/ is pretty nice. - Source: Hacker News / about 3 years ago