Security question/suggestion about simpledb HOT 4 OPEN

Hi @rustamd thanks for stopping by this repo and gave me some suggestions.

First, I don't really get use different supabase project with keys/project ref names that are not in public repo. Is it mean that I just need to hit API within a private repo, then from the private repo, go to this supabase project keys?

Another thing that comes to my mind is since this project using nextjs, is it just simply put the key and ref in the env file to solve this?

from simpledb.

In my eyes the issue is that none of data/API's are secure.

There should be no way for me to get/delete/modify data that another user "owns". But currently that is possible.
The reasons that is possible is because:

• Supabase project ref and apikey are accessible here
• Table name where user data is stored is accessible here

With that information anyone can poke around in your database. My original thought was to use separate project, who's apikey are secure/private. But that would only get you certain amount of "security".

But proper solution would be to enable Row Level Security

Here are some policies to get started:

• Anyone can insert into simpleDB-token
• No one can modify simpleDB-token
• Anyone can delete simpleDB-token if they know the token
• Anyone can insert/modify/delete simpleDB-data if they know userId
• Anyone can insert/modify/delete simpleDB-property if they know userId

from simpledb.

I'm not sure what I expected, but I did not expect to be ignored and my comment minimized. Was just trying to help...

from simpledb.

Hi, sorry. I get some other things to do here and not replying to your suggestion immediately. But thanks for your suggestion, gonna try to implement them one by one

from simpledb.