New R2DBC Driver for IBM DB2

[jason-who-codes]

Hello R2DBC team!

I'd like to bring to your attention a new R2DBC driver for the IBM DB2 database, which I implemented while working at USAA and was just open-sourced at https://github.com/usaa/reactive-db-bridge. I am no longer employed by USAA, but would be happy to answer any questions about the driver, or connect your team with the appropriate folks still over at USAA.

Thanks!
Jason Edwards
GitHub | LinkedIn

[mp911de]

Wow, this is awesome news. What is the state of the driver? Which SPI versions (0.8, 0,9) do you support, and do you pass the TCK?

Going forward, we can include your driver in the BOM until we hit R2DBC spec version 1.0 (after which the BOM will be decommissioned).

I'd also recommend renaming your driver to provide a clear name indicating that the driver is related to R2DBC and DB2. db2-r2dbc-adapter/db2-r2dbc-bridge could be good candidates.

[jason-who-codes]

Hey Mark, it hasn't yet been battle-tested in a prod application, but the implementation is relatively simple (it merely delegates operations to the Vert.X Reactive DB2 Client).

The driver implements the 0.8.6 version of the SPI and has a passing TCK, except it does not support compound statements and has to do a bit of tinkering with the SQL in the BLOB/CLOB test cases (since the underlying Vert.X driver doesn't support LOB's, so they have to be passed as VARCHAR/VARBINARY and aren't streamed).

[mp911de]

Thanks a lot. The BLOB issue isn't really pressing. What are the plans going forward? R2DBC 0.9 has been released recently so it would make sense to have a 0.9-compliant variant.

Soon, R2DBC 1.0 will be released (with a small number of API changes). If the future maintenance is ensured, then happy to include the driver on the page and our BOM.

[odrotbohm]

I'd also recommend renaming your driver to provide a clear name indicating that the driver is related to R2DBC and DB2. db2-r2dbc-adapter/db2-r2dbc-bridge could be good candidates.

I'd still love to see a R2DBC DB2 driver to eventually end up being named R2DB2. 🙃