Top 3 foreign-table Open-Source Projects

sqlite_fdw

6 193 5.7 PLpgSQL

SQLite Foreign Data Wrapper for PostgreSQL

Project mention: Things that surprised me while running SQLite in production | news.ycombinator.com | 2023-07-03

https://github.com/pgspider/sqlite_fdw
Postgres has foreign data wrappers which can kinda achieve this(see also: https://github.com/pgspider/sqlite_fdw ), but ive been surprised by how well sqlite is already supported by many tools : sometimes it comes for free as its used in testing - hooking up stuff like litestream can work really wel l too

parquet_s3_fdw

1 162 2.3 PLpgSQL

ParquetS3 Foreign Data Wrapper for PostgresSQL
InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
firebird_fdw

2 36 5.1 C

A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).