What is the best lightweight orm to use?

Question

PostgreSQL

Base - postgres. I liked morphia, but it's for mongo. Hibernate doesn't like it.

Answer 1

Spring Data JPA - for standard tasks it's nowhere easier...
https://habrahabr.ru/post/139421/
Particularly provides the ability to use dynamically generated methods like findByFirstnameStartingWith, findByStartDateBefore, etc., for which no implementation is needed.
docs.spring.io/spring-data/jpa/docs/current/refere...

Answer 2

I would advise you to take a closer look at MyBatis. easy and not forced)

Answer 3

If it's not a secret, why don't you like Hibernate? What specifically is not to your liking?
The most lightweight will be bare JDBC. And the most flexible.

Answer 4

Hibernate. I don't know why it looks bad to you. Never failed.

Answer 5

It is better to refuse orm. Of course, it speeds up the development process, but only in prototypes. In production, it will be more difficult to scale, shard.