search

pg-redis-fdw / redis_fdw

A PostgreSQL foreign data wrapper for Redis
497 stars 68 forks source link

Make use of HINCRBY? #21

Closed baudehlo closed 7 years ago

baudehlo commented 7 years ago

Is there any way to use this to access HINCRBY? I can't find anything in the docs or tests that would reflect it.

adunstan commented 7 years ago

No, how would that work via a foreign data wrapper? There is a low-level redis extension also available, although it's not very maintained, but still works - see https://bitbucket.org/IVC-Inc/redis_wrapper

baudehlo commented 7 years ago

I didn't know if the modules got access to the sql used, in which case you might be able to see 'colname = colname + ?' statements and convert them. But I guess pg does all the sql parsing before it gets to the fdw.

On Mar 18, 2017, at 9:23 AM, Andrew Dunstan notifications@github.com wrote:

No, how would that work via a foreign data wrapper? There is a low-level redis extension also available, although it's not very maintained, but still works - see https://bitbucket.org/IVC-Inc/redis_wrapper

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

adunstan commented 7 years ago

The whole point of Foreign Data Wrappers is not to give SQL access to the foreign API but to make the foreign data store look like SQL tables. If you want SQL access to the Redis API, use redis-wrapper - that's what it's designed for. You can use both.