Re: Foreign Data Wrappers

The most interesting (IMHO) FDW implementation I have used is an Australian WFS service mounted locally as a Postgis table.

Not wonderful performance, but full spatial query functionality.
If performance was an issue, "create table as select * from FDW;" creates a local cache...
Very useful functionality.

Brent Wood

On Saturday, September 7, 2024 at 12:55:37 PM GMT+12, Gus Spier <gus(dot)spier(at)gmail(dot)com> wrote:

I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer to success through the documentation, youtube videos, 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 to connect to redis or elasticache? If so, how did it work out? 
Regards,Gus

--
Gus
gus(dot)spier(at)gmail(dot)com540-454-3074
“Characteropathic individuals adopt ideologies created by doctrinaire, often schizoidal people, recast them into an active propaganda form, and disseminate it with their characteristic pathological egotism and paranoid intolerance for any philosophies which may differ from their own.” (Political Ponerology, Andrew Lobaczewski, 1984)