You don't need a Database - use this instead!
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): https://supabase.com/blog/postgres-fo...
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): • I gave AI full control over my databa...
▶ You don't need Supabase Auth - use this instead: • You don't need Supabase Auth - use th...
▶ Configure Log Drains with DataDog and Custom HTTP Service using Edge Functions: • Configure Log Drains with DataDog and...
👇 Learn more about Supabase 👇
🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: / @supabase
📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter: / supabase
▶ Instagram (follow for memes): / supabasecom
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
