Question Re: R2DBC for SQL Anywhere in Technology Q&A

R2DBC for SQL Anywhere

former_SQLA_member1694890 — Tue, 29 Mar 2022 09:57:41 GMT

We are looking R2DBC (Reactive Relational Database Connectivity) driver for SQL Anywhere DB. May be are examples for using R2DBC with SQL Anywhere DB

Thanks in advance, Hanan Brener

Re: R2DBC for SQL Anywhere

Breck_Carter — Tue, 29 Mar 2022 15:43:34 GMT

There are no R2DBC drivers for SQL Anywhere listed on https://r2dbc.io/drivers/.

Auntie Google doesn't have anything useful to say when you search on "R2DBC" "SQL ANYWHERE"

Re: R2DBC for SQL Anywhere

VolkerBarth — Wed, 30 Mar 2022 03:22:39 GMT

But as R2DBC is open source, and there already is a MS SQL driver, and SQL Anywhere speaks TDS, too, so how hard can it be to build a driver for SQL Anywhere? 🙂

Re: R2DBC for SQL Anywhere

Breck_Carter — Wed, 30 Mar 2022 08:45:17 GMT

> how hard can it to build a driver

LOL!

Seriously, it looks pretty hard to me.

Re: R2DBC for SQL Anywhere

VolkerBarth — Wed, 30 Mar 2022 09:04:49 GMT

Well, before I wrote my comment, I had actually taken a look at the MS SQL driver code expecting I would be able to somehow grab how the real database connections are handled (or how they are bound to a known database API). But I was not successful. Probably that is the point of the "reactive approach" that it does not make use of an underlying common "blocking" DB API.

Apparently I am not in the position to estimate how hard that really is if one is familiar with R2DBC...