FOSDEM event "Foreign data wrapper study for schemaless databases"

Hiroki Kumagai

Type devroom

Starts on day 1 (2021-02-06) at 11:00 (Brussels time, UTC+1) in room Postgresql (duration 00:30)

Matrix room #postgresql:fosdem.org

In order to connect to external databases, PostgreSQL supports Foreign Data Wrappers (FDW), and there are already many FDWs.

However, among of FDWs have various restrictions preventing utilization of external databases features. As such a restriction,

FDWs for schemaless databases need to change the foreign table definition, when some columns are added in remote database.

This restriction can not take full advantage of the schemaless feature.

In this time, we considered implementing FDW that does not require changing the external table when columns are added on

external database. I would like to introduce this study based on the time-series database InfluxDB as schemaless database.

=> FOSDEM schedule page