Postgres Foreign Data Wrappers with Wasm

Foreign Data Wrappers (FDWs) in Postgres allow interaction with externally hosted data by creating foreign tables. Today, support for WebAssembly (Wasm) wrappers has been released, enabling users to create Wasm wrappers to external services and run them directly from platforms like GitHub. This feature enhances security, simplifies development, distribution, and improves performance of FDWs. The architecture includes a Supabase Wrappers Extension that runs within Postgres and isolated, dynamically-loaded Wasm packages (guests) for data fetching and processing. Currently, the Wasm FDW supports HTTP(s)-based JSON API sources but not TCP/IP-based DBMS or local files. Developers can build their own Wasm FDWs to integrate diverse data sources into Postgres. The feature is available on the Supabase platform with built-in wrappers for Snowflake and Paddle.