JDBC java.sql.ResultSet wrapper

RedBeardLab / JRediSQL

Java Client for RediSQL

6 stars 9 forks source link

JDBC java.sql.ResultSet wrapper #2

Open noahlz opened 4 years ago

noahlz commented 4 years ago

It would be really great if there was some kind of wrapper class that makes the data returned from redis appear to be java.sql.ResultSet - then this could be closer to a drop-in replacement for a traditional SQL database connection.

So instead of calling get(1) get(2) as in the example, you would iterate over ResultSet objects, with functions delegating to the underlying redis interface. Basically RedisResultSetDecorator.

siscia commented 4 years ago

I will look into this!

I love this kind of feedback since we are not really a Java shop so we lack the experience to make this kind of decisions

siscia commented 4 years ago

Hey @noahlz

it seems a quite bit of work, maybe it is me not having yet clear how to implement it. It is me misunderstanding something, or it is actually not as straightforward?

Do you think you can provide a PR? Or can you guys support the development maybe buying a license?

Cheers,

gkorland commented 4 years ago

Yes the JDBC API is pretty broad, but it's almost a must for Java developers so it can play nicely with all the ecosystem, perhaps we can fork the sqllite jdbc client and adapt it.