Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smkS6-007yfa-J1 for pgsql-general@arkaria.postgresql.org; Sat, 07 Sep 2024 01:41:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1smkS4-007ugo-Rt for pgsql-general@arkaria.postgresql.org; Sat, 07 Sep 2024 01:41:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smkS4-007ugg-G7 for pgsql-general@lists.postgresql.org; Sat, 07 Sep 2024 01:41:24 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1smkS2-000XIP-Dr for pgsql-general@lists.postgresql.org; Sat, 07 Sep 2024 01:41:24 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-6b747f2e2b7so24613037b3.3 for ; Fri, 06 Sep 2024 18:41:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725673279; x=1726278079; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=UcF/6Wy8xDbjQsW5h9Z6XzMa4O193XdvNFJjDc8IQnc=; b=l8XjPQ2Tqpiqmv9EEkfElPsPp1A9ApykoMcqtTR4XSZ1PsRfBprTyqGKMJrg0bYWEQ NAeJvTiFxhP2T4f4DHmFmSiQF80YVk5TkahK6yhTZ5YsS3FgIqUWj+LzMXdQIEoU5FP7 26kns/5M2ohYszRVIu0sGinOTB5bY+3STVCqSVwZ40qzgRexWVBBXYTLNuwMYS2eN8xE BGxb0vLvTHz8HwySP9njJSlfLOxf/visgiTiMpfRjqJZjJei/pyScTd60E+Ix/Ha93Wb m7gVW3iDkwRQdFcDLh90ZVo3qPxukD1lbqml1dMTCeLxrXK8Kw/lW9++rJmyYd07qFjb NogA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725673279; x=1726278079; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=UcF/6Wy8xDbjQsW5h9Z6XzMa4O193XdvNFJjDc8IQnc=; b=r2q2vhRrQDWewHvDBICr5cTSvkxHXRuFrZSur2gZkc2oWW8cEhwikTp+QiPQLFX2l5 UlLT7+MDbejN7wgsdy7ig6PEhLdfkmkCjuS2ZxL/SKej+4upcMlSU+7YhUyIp0xakW/h uomtj8vr/v1O2Elh3VaZUh8tiI+t2ad/FIBePnMuNpaboXIhUPRRwdCyUdZkjV8xhmgu 8wKHBPXSQkCVRYuEEhu0fVOA341exT1SjesW+2/RAljbZ2ChM8zVsR18/IRocIzM1JQ/ 5NFfj2DTc09EikvE8mmn7GsANOPHFnOIY6iB/GpqmJPhUASgYQwbZq0agT54aG/bocJ9 inuA== X-Gm-Message-State: AOJu0YzxpLMRLhXJ1VwbvjPJjsoPNNuYuvyfCDs6zuNyjAnJWjATZH0F 3FN1EA06Va8EqD+pXY1O90eDpKqVajsUZcAk/l4BejPpUmRrQnzPJiAIle4xXOlvVSWuXWaO4fU PjAN3m1XeT1Mb8/YLtLCYfdfpE6ByQg== X-Google-Smtp-Source: AGHT+IGR62iE4eM7GqKD7llxSTASrS4PNKvJWy9UTIVpY5oUj1AZwfrr1TRVhvn+RvL0ciwu3eUTPanBc1upvnsA724= X-Received: by 2002:a05:690c:3208:b0:6d0:f91e:2ff0 with SMTP id 00721157ae682-6db44d9c119mr43661047b3.11.1725673279582; Fri, 06 Sep 2024 18:41:19 -0700 (PDT) MIME-Version: 1.0 References: <2406562.1725672949@sss.pgh.pa.us> In-Reply-To: <2406562.1725672949@sss.pgh.pa.us> From: Gus Spier Date: Fri, 6 Sep 2024 21:41:10 -0400 Message-ID: Subject: Re: Foreign Data Wrappers To: Tom Lane Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000d3f7e606217d9ebd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d3f7e606217d9ebd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks for the pointers! I'll resume my task in the morning. If I get anywhere, I will post the outcome. R, Gus On Fri, Sep 6, 2024 at 9:35=E2=80=AFPM Tom Lane wrote: > Gus Spier 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 > --000000000000d3f7e606217d9ebd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for the pointers!

I'll resum= e my task in the morning. If I get anywhere, I will post the outcome.
=

R,
Gus

On Fri, Sep 6, 2024 at 9:35=E2=80= =AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Gu= s Spier <gus.sp= ier@gmail.com> writes:
> If I understand the concepts correctly, FDW not only makes other datab= ases
> available, FDW also offers access to .csv files, plain text, or just a= bout
> anything that can be bullied into some kind of query-able order. Has a= nyone
> 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.)

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 regards, tom lane
--000000000000d3f7e606217d9ebd--