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 1smkK3-007xvv-1p for pgsql-general@arkaria.postgresql.org; Sat, 07 Sep 2024 01:33:07 +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 1smkK1-007fa5-Fz for pgsql-general@arkaria.postgresql.org; Sat, 07 Sep 2024 01:33:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smkK1-007fYk-3H for pgsql-general@lists.postgresql.org; Sat, 07 Sep 2024 01:33:05 +0000 Received: from mail-pj1-x1032.google.com ([2607:f8b0:4864:20::1032]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1smkJy-000WeO-NF for pgsql-general@lists.postgresql.org; Sat, 07 Sep 2024 01:33:04 +0000 Received: by mail-pj1-x1032.google.com with SMTP id 98e67ed59e1d1-2d89229ac81so2065605a91.0 for ; Fri, 06 Sep 2024 18:33:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725672781; x=1726277581; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dwFz8yHOIETuo2DMaWR22pwiCBlyXpoFnrUld8PffOA=; b=NTwEYOxRGabFHSQJM0Wn26NHzs/ArFTSydsl+PHA79Ieebp+2KHeZRo26MqCa5JH4K DPimTNCtKxFZ/OM/Zdi8dLwa+n42uWSuiS3gTk6tAD30dXz78n7LrHtIdZJ6tpnvNXjo o0nrOcpKIwHdPrp8u8dOBJCDnQBwQLmNlR6NntNLbebEESRzhO+Wc+R1yoHfRkERbdZo U7o455PRPC6XQ2tfudAyFExFHLVKi++Dw4W5RyLBdhQwAywDGgpkofPxVZfQ5G0e9I3Z zluat9ysEW8GNX13Io6udZZhNP8GYEcEFnNqx3GI1risBOcMq0EASPJyW9C6WXas6txN cUSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725672781; x=1726277581; h=content-transfer-encoding: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=dwFz8yHOIETuo2DMaWR22pwiCBlyXpoFnrUld8PffOA=; b=uxApN9rh/UfGVfwBzdkI9ldzRMcrLuPD4m+vu9lDQZy8w2zQiEUdDLK7K9w16BNpKe 4k48wlW/s6oJcr4q2rprrcY0r5aLonhO3gpV7RnbJ6t7bmCXzcp7ddpbfMRwlCFOhE45 yso63EUqTHR1zhw5lFdSFlxJdupBpqFqUbUBDIXTrDW+0sDYwlm+KtaQLlhakRJysAQb j6gtsZa1t7WUPNw/KgBykd6sQ6TkGnz+ibgIE1i5nrlaENRrqqnZ0QdrGSfYBE7pL34o zdoQIl8SV1L3k5fHmzzh/U/ONo7z6WSL+tpBGeAj6+UH9hHdn9mSGrN4TJ/iFONRWW+b fpjw== X-Gm-Message-State: AOJu0YzLPbCrpVixN8Ulp89DVQRM3m2gAZbB4lnq9adAfedCAZc+F9rk W4aJl5KX+QIj8/h0Fjon4AbJbwZZTIztFzHCM6ImkvJNbPyGDQ/G90rE2MWVmwo40klqAnGn2/e 0rDpCKM89Zfjcsn8qkzVGV+6aFQE= X-Google-Smtp-Source: AGHT+IEtUnEOJztFKLhEwW7W3q7eVu1YxIg2taZbZMED1ObkcBg6OBlNroaxqe0SYdBWshXpJNfx6Q8e54oZQbv4bmA= X-Received: by 2002:a17:90b:1c10:b0:2d8:8991:211f with SMTP id 98e67ed59e1d1-2dad50d0f78mr5147795a91.28.1725672780932; Fri, 06 Sep 2024 18:33:00 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ian Lawrence Barwick Date: Sat, 7 Sep 2024 10:32:49 +0900 Message-ID: Subject: Re: Foreign Data Wrappers To: Gus Spier Cc: pgsql-general Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 2024=E5=B9=B49=E6=9C=887=E6=97=A5(=E5=9C=9F) 9:55 Gus Spier : > > I find myself in new territory, Foreign Data Wrappers (FDW). I stumble cl= oser to success through the documentation, youtube videos, and various goog= le resources. But I've come across a concept that intrigues me very deeply. > > If I understand the concepts correctly, FDW not only makes other database= s available, FDW also offers access to .csv files, plain text, or just abou= t anything that can be bullied into some kind of query-able order. Has anyo= ne ever tried to connect to redis or elasticache? If so, how did it work ou= t? There are two FDW implementations listed for Redis here: https://wiki.postgresql.org/wiki/Foreign_data_wrappers#NoSQL_Database_W= rappers but neither have been updated for recent PostgreSQL versions. Regards Ian Barwick