Foreign Data Wrappers allow Postgres to communicate with external data sources. In this video, Jon Meyers demonstrates how to create a custom Foreign Data Wrapper using Wasm (WebAssembly) to combine data from a Google Sheets spreadsheet with table data in PostgreSQL.
✍️ Foreign Data Wrappers with Wasm (blog): [ Ссылка ]
00:00 What are Foreign Data Wrappers
00:42 Forking the FDW Wasm template from GitHub
01:39 Creating a database with Google Sheets
03:10 Building a Foreign Data Wrapper for Google Sheets
04:58 Releasing our custom FDW on GitHub
06:52 Installing custom Foreign Data Wrappers in PostgreSQL
08:37 Query data from external sources with Foreign Data Wrappers
09:11 Joining table data with external data in Postgres select query
10:10 Why we decided to build Supabase Wrappers
💻 Videos to watch next:
▶ I gave AI full control over my database (postgres.new): [ Ссылка ]
▶ You don't need Supabase Auth - use this instead: [ Ссылка ]
▶ Configure Log Drains with DataDog and Custom HTTP Service using Edge Functions: [ Ссылка ]
👇 Learn more about Supabase 👇
🕸 Website: [ Ссылка ]
🏁 Get started: [ Ссылка ]
📄 Docs: [ Ссылка ]
🔔 Subscribe for more tutorials and feature updates from Supabase: [ Ссылка ]
📱 Connect with Us:
🐙 Github: [ Ссылка ]
💬 Discord: [ Ссылка ]
🐦 Twitter: [ Ссылка ]
▶ Instagram (follow for memes): [ Ссылка ]
ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.
Build in a weekend, scale to millions.
#Supabase #AppDevelopment #RealtimeApps #DeveloperTools
Ещё видео!