For the introductory video on PostgreSQL functions, check out π
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 () 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:
π° Get really good at Supabase and build a SaaS product (free course):
---
Learn more about Supabase π
πΈ Website:
π Get started:
π Docs:
π Github:
π¬ Discord:
π¦ Twitter:
Jon Meyers π
πΈ Website:
π₯ YouTube Channel:
π¦ Twitter:
---
1 view
747
209
6 days ago 00:15:36 1
Call Postgres functions from JavaScript with RPC
2 months ago 01:20:31 1
Create A REST API with FastAPI, SQLAlchemy and PostgreSQL.
6 months ago 00:17:38 1
PostgreSQL Tutorial - 16 - How to setup streaming replication in PostgreSQL step by step on Ubuntu
10 months ago 00:14:43 1
Why Postgres Query is Not Using Index
10 months ago 11:52:34 1
PostgreSQL Administration in 12 Hrs. #PostgreSQL #PostgreSQLTutorial #PostgreSQlTutorialForBeginners
10 months ago 06:14:55 1
Postgres Admin in 6 hours #postgresql #postgres
2 years ago 00:12:48 1
Using stored procedures in PostgreSQL for CRUD operations in C# Code | Simple Example