For the introductory video on PostgreSQL functions, check out 👉 • Create PostgreSQL Func...
Sometimes we have a collection of complex steps we need to perform in a particular sequence from the front-end. Maybe we want to execute an SQL statement that the supabase-js library does not yet support. These are both excellent use cases for RPC.
RPC in supabase allows us to call a PostgreSQL function from JavaScript. This means we can abstract away our complex logic, or multi-step process into a Postgres function, and just make one request to call this function from the client.
In this video, Jon Meyers ( / jonmeyers_io ) demonstrates how we can create a function to increment a column's value by one, and call this when the user clicks a button using RPC.
This is part of a series of videos about functions in PostgreSQL, check out the rest of the playlist to learn more: • PostgreSQL Functions
💰 Get really good at Supabase and build a SaaS product (free course): egghead.io/cou...
---
Learn more about Supabase 👇
🕸 Website: supabase.com/
🏁 Get started: app.supabase.com/
📄 Docs: supabase.com/docs
🐙 Github: github.com/sup...
💬 Discord: discord.supaba...
🐦 Twitter: / supabase
Jon Meyers 👇
🕸 Website: jonmeyers.io/
🎥 KZitem Channel: / jonmeyers
🐦 Twitter: / jonmeyers_io
---
Негізгі бет Call Postgres functions from JavaScript with RPC
Пікірлер: 45