Manage secrets and query third-party APIs from Postgres

Foreign Data Wrappers (FDW) are a core feature of Postgres that allow you to access and query data stored in external data sources as if they were native Postgres tables. Using this concept we can query our live Stripe data from within our Supabase Postgres Database!

- Read the docs: https://supabase.link/foreign-data-wr...
- Manage secrets with Supabase Vault: https://supabase.link/vault-yt

Presented by Thor Schaeff (@thorwebdev https://go.thor.bio/x)

CHAPTERS:
00:00 Intro to Supabase Vault
00:39 Encryption key management
01:08 Vault UI in the Supabase Dashboard
01:18 Add a new secret API key
01:37 Intro to Supabase Wrappers
02:09 Create a new Stripe restricted key
03:11 Add the API key as a new secret
04:07 Inspect the Vault schema and tables
04:34 Decrypt secrets via a Postgres view
04:58 Enable the Foreign Data Wrapper for Stripe
06:43 Connecting to Stripe from Postgres
07:55 Create a Foreign Data Table
08:57 View Foreign Data Table in the Dashboard
10:15 Use SQL aggregate methods on foreign data

💻 Videos to watch next:
▶ Fastest way to build a SaaS in 2024 - Next.js, Supabase and Stripe
:    • Fastest way to build a SaaS in 2024 -...  
▶ Encrypted Columns in PostgreSQL - Secrets Management with Supabase Vault: https://www.youtube.com/live/QHLPNDrdN2w
▶ Postgres FDW framework - Supabase Wrappers: https://www.youtube.com/live/QA2qC5F-...


👇 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://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