Using PostgreSQL functions to call an API with Supabase
For the introductory video on PostgreSQL functions, check out 👉 • Create PostgreSQL Functions with Supa...
Functions are a super powerful way to encapsulate some logic in our Postgres database. If we were restricted to only writing SQL statements, these functions would be quite limited. By utilizing database extensions, we can expand this functionality to basically do anything we want!
In this video, Jon Meyers ( / jonmeyers_io ) explains how the HTTP extension can be used to make synchronous API requests to fetch data. He uses the Kanye West API to retrieve a quote and display a personalized message for the user.
While this example is quite novel, the same method could be used to perform important core responsibilities of your application - such as charging a customer with Stripe, or sending an SMS with Twilio.
This is part of a series of videos about functions in PostgreSQL, check out the rest of the playlist to learn more: • PostgreSQL Functions
---
Learn more about Supabase 👇
🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs
🐙 Github: https://github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter: / supabase
Jon Meyers 👇
🕸 Website: https://jonmeyers.io/
🎥 YouTube Channel: / jonmeyers
🐦 Twitter: / jonmeyers_io
---