So, I want to have a local copy of all my plpgsql functions, in case they get lost or if I want to re-create the DB locally. Right now I am copying them manually over to supabase, but is there an API to push them to supabase, so I can automate this? Thanks!
12/30/2021, 7:43 PM
You can use any database migration library to do this
12/30/2021, 7:44 PM
Ahh, right because it can connect directly to the postgres instance.. okay, thanks!
12/30/2021, 8:35 PM
Just make sure the credentials aren't available to the frontend app. I'm doing my deployments with GitHub actions on fly.io and I store my database credentials inside of GitHub secrets
12/30/2021, 9:08 PM
@User do you have them in an .sql file and push it with psql then?