Add Supabase 'App' modules to Integromat for all R...
# ideas-and-suggestions
b
Add Supabase 'App' modules to Integromat for all REST operations.
a
I’ll start poking around with this one Bryan - could you give me an example flow you’d want to do?
b
@User I think something similar to the MySQL modules would be a good place to start.
I'll make a video showing what I know about it so far.
@User here is a video I made showing some of what I have done and how to edit in the Integromat UI and through a VSCode Extension.

https://youtu.be/HZBICqw3K-A

a
Ah sweet there’s a Postgres integration already. Could you not use that? You can find all the postgres auth information in your supabase project settings
b
Yep, that totally works! I was hung up on using the REST interface and didn't even think about PostgreSQL Modules as an option. Is there anything I would lose by not using the REST API?
a
Nah, only if you were doing auth stuff. But with DB queries it’d be 1-1
Hope it helps!
b
@User for this backend system, we would be using the service account to make changes to the DB. We do have a front end app that will use user auth and RLS.
a
Then yeah, you’re good to just access Postgres directly!
b
It didn't take me long to replace all my custom app modules with PostgreSQL modules. All is working now as expected.
a
Love it!