How can I use SQL scripts with Supabase resource in Windmill (self-hosted)?
I'm migrating my self-hosted PostgreSQL db to Supabase and trying to integrate it with my self-hosted Windmill instance
https://www.windmill.dev/docs/integrations/supabase
The guide recommends setting up Supabase as a resource using the url and key. This works for querying through TypeScript
I have a number of existing PostgreSQL scripts and prefer using SQL for quick tasks, however, with the Supabase resource type, I haven’t found a way to execute raw SQL scripts as I could with a standard PostgreSQL resource
I know that I can connect to supabase using their postgres url but I think that since the docs recommend this and I don't want to have duplicate resources for each thing I want to run, how to connect supabase properly
Should I connect so supabase with oauth? I am unable to select it as one of the items, is it because I am not in the admin account and if yes, how can the admin set it up?
Supabase integration | Windmill
Supabase is an open-source Firebase alternative.
4 Replies
Use the postgres url, that will be simpler and more efficient
👍
Also are there any complications in migrating to supabase as my primary database for windmill that I must know? I found that rls must be disabled in supabase for windmill to work. Is this a viable path?
I would really not recommend using supabase as the primary database for windmill
perf are not adequate
Hmm okay