SupabaseS
Supabase3y ago
doa

Need advice with storage and table

I want to make a platform of sort in Supabase, where user can upload "books" and other user can view them. But I am struggling with connecting the table with the storage,

So the table is "contents" where it have the books, and the book themselves is in a bucket under storage named "books".
It looks like this under buckets: books/[book_title]/[chapter_number]

So for example it could look like this: books/Cinderella/chapter 01/
And then a chapter consist of multiple images.

Now the problem is because I want to track who is the original uploader I want a way to connect them. Any user can view the books but delete, edit, and upload belongs to the original user.

So I want to put Cinderella for example into contents, and now I can see what titles I have in contents and access them. But how do I do this ?
Was this page helpful?