i'm looking to spin up a new table after a user go...
# help
c
i'm looking to spin up a new table after a user goes through an init process, is this doable with the supabase api?
s
You don't normally do this in relational databases, you rather structure your tables to handle different user data
c
maybe a suggestion of a better way is needed. i'm making a saas platform that would intake many different companies and all their data. I don't want it intertwined so i was gonna spin up a table for each org that joined the platform.
s
Yeah this is normally done in the same table through relational keys, doing it by creating new tables is not efficient and can get chaotic quite easily
c
ok let me think about how i can keep everyone from everyone hahaha
s
You can use RLS for that
I wish I had enough time to write examples on these things
c
i think i get the gist, more of a reference abstraction higher up. allowing for more uniform data in less tables
s
yes
c
thanks @User no examples needed.
s
ok great