How to get data from two tables from Supabase?

kacharohan7 · 2024-09-19T17:11:58.879Z

I’ve a login form in bubble.io and database in supabase. I have two tables in supabase for users that are one is default supabase auth’s user table and another user table is in public schema. So when I do signup I store details in this two tables, auth data will be in auth table and name, roles is in public table. so how could I store full user information in bubble after did login in bubble.io?

Zeroic · 2024-09-21T10:24:58.230Z

Hi! You can just use the Create a new thing operator to save data to your DB in Bubble - or am I missing something here?

sem · 2024-09-21T14:38:13.405Z

I would consider a view in Supabase (that you can access by api) and not storing anything in Bubble. It is faster and consumes less WU. Also no data duplication

system · 2024-11-28T17:12:40.398Z

This topic was automatically closed after 70 days. New replies are no longer allowed.