how to fix it? - Githubissues

Zeptosec / Thermastore

Cloud storage. Can store large amount of large files. Relies on discord webhooks and supabase for storage.

https://thermastore.netlify.app

11 stars 4 forks source link

how to fix it? #5

Closed bianvigano closed 11 months ago

bianvigano commented 11 months ago

Screenshot from 2023-12-06 15-00-45

Maybe it's because it's not completely clear about this database supabase

Zeptosec commented 11 months ago

Sorry, I haven't updated the database definitions in a while because supabase doesn't make it easy to export all definitions, functions and triggers.

I've updated it enough to get it running and working. supabase.ddl

bianvigano commented 11 months ago

Already able to walk and work.

Thank you.

But why do we have to use a database from supabase.com. Why not use SQL, SQLite, MySQL, and MongoDB databases?

Zeptosec commented 11 months ago

Supabase provided a better DX.

It gives a free database (small but good enough for small projects).
Handles auth.
Has a decent library for retrieving/mutating user data - no need for API.

bianvigano commented 11 months ago

It looks like there's another bug, or perhaps another database problem.

So, the problem is that when I try to log in with another account, the contents of 'myfiles' are the same in that account. It should be that different accounts have different 'myfiles.' this is the same

Zeptosec commented 11 months ago

It sounds like you need to setup RLS on your tables.

I can provide you with some basic policies that should fix your problem: https://github.com/Zeptosec/Thermastore/blob/3a93e66d51ccf4d41ca75f3330ebc6482a53b513/supabase.ddl#L200-L250