Hi I switched to Kotlin for a project that require...

# spring

[Nathan]

Hi I switched to Kotlin for a project that requires full reactivity, has anyone successfully used r2dbc? What did you use for ORM? Do I have to manually write all SQL queries and handle entity relationships? Hibernate doesn’t work with r2dbc. Thanks for your insight

[Robert Jaros]

You could check https://www.komapper.org/

[Nathan]

Thanks @Robert Jaros the project looks interesting, might be difficult getting buy in at work due to “adoption”. I’ll try regardless

[Johan]

Havnt used it myself but for spring you can use https://docs.spring.io/spring-data/relational/reference/r2dbc/repositories.html

[Nathan]

Thanks for the suggestion, already using this. The issue is managing relationships between entities- I need a compatible ORM

[mbratek]

There is https://hibernate.org/reactive/documentation/2.2/reference/html_single/
however, I would reconsider the choice of r2dbc if you have relationships, this is not as smooth as jdbc and many pitfalls can happen.

[Nathan]

Yeah I switched to jdbc, seems a better decision.

[Jacob]

I use spring data jdbc as a lightweight orm. I would avoid hibernate / jpa. I don't like the massive amount of global mutable state that comes with it. It's not in line with the more functional direction the industry has been heading

[Nathan]

@Jacob what do your repositories look like without extending JpaRepository? Do you have a blog or any non trivial code snippet to share that explains your pattern?

[Jacob]

https://docs.spring.io/spring-data/relational/reference/r2dbc/repositories.html

[Jacob]

https://docs.spring.io/spring-data/relational/reference/kotlin/coroutines.html#kotlin.coroutines.repositories