Call Postgres functions from JavaScript with RPC

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: ---
Back to Top