redis_fdw | A PostgreSQL foreign data wrapper for Redis | Wrapper library
kandi X-RAY | redis_fdw Summary
kandi X-RAY | redis_fdw Summary
This repository has moved to Please back up your repo to the previous commit and adjust the git config to point to or git://github.com/pg-redis-fdw/redis_fdw.git. The commits are identical in the new location up to the point where we moved it. Sorry for any inconvenience.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of redis_fdw
redis_fdw Key Features
redis_fdw Examples and Code Snippets
Community Discussions
Trending Discussions on redis_fdw
QUESTION
I'd like to call a custom EVAL function from within postgres to a redis instance (so I'm not sure if redis_fdw will work in this case.)
The other option is to use plpython
with a redis library
https://pypi.org/project/redis/.
ANSWER
Answered 2021-Feb-24 at 07:48redis_fdw only mentions support for a handful of built-in data structures, so it doesn't look like much help for an EVAL
.
A global connection pool will probably not be easy. Postgres runs each connection in its own server process, and you can't pass anything between them without allocating it in shared memory (which I don't see a PL/Python API for, so I think it'd need to be done in C).
But if you can afford to create one Redis connection per Postgres connection, you should be able to reuse it across PL/Python calls by putting it in a shared dictionary:
The global dictionary
SD
is available to store private data between repeated calls to the same function. The global dictionaryGD
is public data, that is available to all Python functions within a session; use with care.
So, something like
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install redis_fdw
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page