Foreign data wrapper study for schemaless databases
summary
Examines implementing a PostgreSQL Foreign Data Wrapper that supports schemaless databases without requiring foreign table definition changes when remote columns are added. Uses InfluxDB as the example schemaless/time-series database and discusses approaches to let PostgreSQL query evolving remote schemas via an FDW.
AI-written summary · about
related talks
46mWriting a Foreign Data Wrapper
50mBeyond Foreign Data Wrappers: building a data warehouse from heterogeneous external data sources
52mSharding PostgreSQL using Foreign Data Wrappers
34mJoining Heterogeneous Databases is a reality, not a Myth
51mUsing Postgres FDW with a sharded PostgreSQL Database
54mFederating Queries Using postgres_fdw
47mpg_shardman: Sharding in PostgreSQL
25mRuby and PostgreSQL, a love story