Database Functions vs Edge Functions
I've been learning how to write edge functions this last week, which has meant learning basic javascript and getting a CLI environment running.
I see the advantage of them for opening up APIs that I can call externally from some other app.
However, all of the functions I'll want to use involve calling some other external api and pulling in fields. Given that I'm more comfortable with Python (and that postgres stored procedures support it), I'm wondering if there's any reason not to just write all those external api calls as postgres database functions?
If the answer is that I should just use postgres functions, then the remaining advantages of having Supabase include:
I see the advantage of them for opening up APIs that I can call externally from some other app.
However, all of the functions I'll want to use involve calling some other external api and pulling in fields. Given that I'm more comfortable with Python (and that postgres stored procedures support it), I'm wondering if there's any reason not to just write all those external api calls as postgres database functions?
If the answer is that I should just use postgres functions, then the remaining advantages of having Supabase include:
- Authentication
- Native integration with WeWeb
