Two issue I face with RPC functions
1. How to store RPC functions on GitHub, similar to how I store the edge function code — https://youtu.be/l2KlzGrhB6w?t=143 (https://youtu.be/l2KlzGrhB6w?t=143)
2. How to auto-refresh the RPC function when the underlying column data changes using Supabase JS.?
Supabase
YouTube
Deploying Edge Functions with GitHub Actions
We can use the Supabase CLI[0] together with GitHub Actions[1] to automatically deploy our Supabase Edge Functions[2].
Find the code: https://github.com/thorwebdev/edgy-edge-functions/blob/main/.github/workflows/deploy.yaml
🎙️ Presented by Thor Schaeff (@thorwebdev https://go.thor.bio/x)
Chapters
00:00 Intro
00:27 Project Setup
02:36...
1 Reply
Using the supabase migration files is likely your best bet. You can manage the rpc functions and you can update them over time by creating new versions of the functions using something like
CREATE OR REPLACE FUNCTION in subsequent migration files.