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.sp...@gmail.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.spier@gmail.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)
