public inbox for [email protected]
help / color / mirror / Atom feedFrom: Brent Wood <[email protected]>
To: pgsql-general <[email protected]>
To: Gus Spier <[email protected]>
Subject: Re: Foreign Data Wrappers
Date: Sat, 7 Sep 2024 02:40:48 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAG8xnifz_V1Cr1fehMGS1nxhmAgX4Y4EUsvnvNb6DkB==AGP1w@mail.gmail.com>
References: <CAG8xnifz_V1Cr1fehMGS1nxhmAgX4Y4EUsvnvNb6DkB==AGP1w@mail.gmail.com>
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 <[email protected]> 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
[email protected]
“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)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Foreign Data Wrappers
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox