question about connection pooling for the fdw

pg-redis-fdw / redis_fdw

A PostgreSQL foreign data wrapper for Redis

494 stars 68 forks source link

question about connection pooling for the fdw #28

Closed zcaudate closed 3 years ago

zcaudate commented 3 years ago

I'm wondering if there is connecting pooling for redis fdw.

Also, I'd like to be able to run an EVAL call to redis with arguments (to get back a json in order to insert into a table), is there anyway to do this currently?

adunstan commented 3 years ago

there isn't any connection pooling, or even connection caching right now. We need to do caching.
See https://bitbucket.org/adunstan/redis_wrapper/src/master/ it might do what you need

zcaudate commented 3 years ago

@adunstan thanks for the link. it is what I'm after.

I'm curious why you didn't put the repo up on GitHub?

adunstan commented 3 years ago

It was originally developed for a company that uses BitBucket as their cloud git provider. I use Github, Bitbucket and GitLab :-)

zcaudate commented 2 years ago

@adunstan: can I get a couple of clarifications about your library - https://github.com/zcaudate/redis_wrapper

Am I correct is understanding that:

a single connection can open multiple redis connections
two db connections cannot share a redis connection
there is some sort of auto cleanup when a db connection goes down.
the best way is to keep the db pool and create redis connections as needed.