[r2dbc] Support for one-to-one and one-to-many relationships

[Topfgriff]

Since spring-data-r2dbc is now part of spring-data-relational, I wanted to reopen a much-discussed topic.

Quote from the original issue:

"Spring Data JDBC supports one-to-one and one-to-many (either as set, list or map) relationships:
https://docs.spring.io/spring-data/relational/reference/jdbc/mapping.html#jdbc.entity-persistence.types
It would be really useful to have this feature with R2DBC as well."

Being able to map "simple" relations would make working with r2dbc much easier. Many of our developers do not switch to Spring's reactive stack due to the lack of the ability to represent relations and prefer to stick with the MVC variant, where they can make use of JPA and Hibernate.

[infinite-dev22]

Any updates on this

[AbdelrahmanTarek97]

Any updates here guys?

[Exceptionflug]

Any updates here?

[ramarro123]

still no plan?

[thalesdev]

Guys any update?

[JeanPoffo]

Any update? Is a crucial feature

[nekitbr]

any updates on this?

[JoseLion]

I'm reposting this comment here for everyone's visibility 🙂

I published spring-r2dbc-relationships library to help handle relationships in R2DBC. The solution is not ideal because it uses .collectList() to collect results and issue queries for each result, but that is what we'd have to do on user-land anyway. The library provides annotations for @OneToOne, @OneToMany, @ManyToOne, and @ManyToMany relationships, and it even handles Projections. Any feedback is welcome. I hope this can help people working with R2DBC while a proper solution is provided.

• Homepage: https://joselion.gitbook.io/spring-r2dbc-relationships/
• GitHub: https://github.com/JoseLion/spring-r2dbc-relationships/

Cheers!

[kap199297]

@JoseLion, it's a very good library for R2DBC. Can we have have similar annotation (like @manytomany or @manytoone) implementation for JDBC?