spring-cloud-aws icon indicating copy to clipboard operation
spring-cloud-aws copied to clipboard

New module 'spring-cloud-aws-r2dbc'

Open alxgrk opened this issue 5 years ago • 2 comments

Is your feature request related to a problem? Please describe. Reactive Relational Database Connectivity (R2DBC) is getting more and more attention. spring-data-r2dbc has recently been released as 1.0.0.RELEASE. I would now love to use it, when connecting to an AWS RDS instance - but not without having the nice features of spring-cloud-aws-jdbc like connection pooling or failover support.

Describe the solution you'd like In my mind the easiest solution will probably be to add another module to this repository called something like spring-cloud-aws-r2dbc. It could surely re-use most of the code used in spring-cloud-aws-jdbc, maybe extracting the common parts into another module would be a good thing to do. For handling the connection pooling, one could use r2dbc-pool, which has been stably released recently as well. There are probably some other places it didn't see yet, where replacing JDBC by R2DBC might be difficult.

Describe alternatives you've considered Alternatively, one could simply use spring-data-r2dbc directly as well, but then features like connection pooling, failover support and instance resolving would be missing.

Additional context I can try and work on a PR, although I'm not sure, if I will manage to do it within a reasonable time frame. Additionally, I would like to discuss, whether the general approach suggested is viable or not.

alxgrk avatar Dec 10 '19 00:12 alxgrk

Any updates regarding this?

itsandreramon avatar Dec 26 '20 14:12 itsandreramon

Currently, spring-cloud-aws doesn't block to use rd2bc, you can use it as you can use jdbc even without the spring-cloud-aws-jdbc module. Most of the supported databases by AWS RDS have a r2dbc driver. Connection Pool is offered by spring-boot auto-configurations already and regarding to "failover support" using multi AZ or rds proxy is something that the infrastructure can manage.

eddumelendez avatar Dec 27 '20 06:12 eddumelendez