Thread: Foreign Data Wrappers

> On Sep 6, 2024, at 17:55, Gus Spier <gus.spier@gmail.com> wrote:
> If I understand the concepts correctly, FDW not only makes other databases available, FDW also offers access to .csv
files,plain text, or just about anything that can be bullied into some kind of query-able order. 

There two parts to FDWs: The code in the PostgreSQL core, and the FDW extension that is specific to type of the remote
datasource.  It's up to the plug-in to translate the remote data source into a format that appears as a foreign table,
sothe specifics of how the remote data source are mapped to the table depend on the plug-ins implementation.  You need
toinstall the FDW extension in the PostgreSQL instance as you do with any extension.  There are a lot of different
plug-ins,of varying degrees to maintenance, out in the ecosystem.  They definitely exist for Redis; I'm not sure about
Elasticache.

2024年9月7日(土) 9:55 Gus Spier <gus.spier@gmail.com>:
>
> I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer to success through the documentation,
youtubevideos, and various google resources. But I've come across a concept that intrigues me very deeply. 
>
> If I understand the concepts correctly, FDW not only makes other databases available, FDW also offers access to .csv
files,plain text, or just about anything that can be bullied into some kind of query-able order. Has anyone ever tried
toconnect to redis or elasticache? If so, how did it work out? 

There are two FDW implementations listed for Redis here:

    https://wiki.postgresql.org/wiki/Foreign_data_wrappers#NoSQL_Database_Wrappers

but neither have been updated for recent PostgreSQL versions.

Regards

Ian Barwick

Gus Spier <gus.spier@gmail.com> writes:
> If I understand the concepts correctly, FDW not only makes other databases
> available, FDW also offers access to .csv files, plain text, or just about
> anything that can be bullied into some kind of query-able order. Has anyone
> ever tried to connect to redis or elasticache? If so, how did it work out?

Looks like it's been done:

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

(No warranty expressed or implied on the quality of these
particular FDWs.)

            regards, tom lane