Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Are there any security rules on database?

so users can read rows where the UID column value is equal to theier auth UID?

What's the term in supabase* (for security rules in Firebase)

You can make use of Supabase's integrated Row Level Security

Learn more at:
https://supabase.io/docs/learn/auth-deep-dive/auth-row-level-security

Yes. Just 1 more question:
```sql
FOR UPDATE USING (
  auth.email() = email
) WITH CHECK (
  auth.email() = email
);
```

```sql
FOR DELETE USING (
  auth.uid() = user_id
);
```
If I understand it correctly  `WITH CHECK` is just compare those 2 values. But why the the DELETE example not using it?

That relates to SQL's policy, which you can also check out at:
https://supabase.io/docs/learn/auth-deep-dive/auth-policies

Posgres's documentations could give you the general idea on that more clearly.
https://www.postgresql.org/docs/12/sql-createpolicy.html

```
'check_expression':
This expression will be used in "INSERT" and "UPDATE" queries
```

so this is to validate incoming data and hence is used in insert or update only.

Is there any documentation on how roles work with auth? Can't seem to get the `inviteUserByEmail` api to work due to users not having the right roles, but unsure on how to set roles for users?

I think this is only available when using the service_role secret which should only be used server side

Ahh I see... thanks! Hypothetically could I use nextjs's API routes? If so, how would/should use the service_role secret with the call... doesn't seem to be a param in the docs?

You would have to instantiate the Supabase client again in your nextjs API route with the `service_role` `secret` instead of the `anon` `public`

Ahh of course, that makes total sense 😄

Hello,

I'm not sure if it's possible. But have anyone tried "TRIGGERING PYTHON SCRIPT WHEN ROW INSERTED IN A DB TABLE"

yes this is very doable  https://supabase.io/docs/reference/javascript/subscribe
see this section of docs

and you can start the stream on `INSERT` event as stated

and after that you can use `child_process` node module

https://nodejs.org/api/child_process.html

to spawn new process every time an insert happens

Does supabase have any triggers on storage ?
When a new file is uploaded it triggers something ?

Similar to Firebase's `onFinalized` triggers

Hi guyss, any of you know how to remove this? since I am only interested on the data

You can't, these are Vue JS reactive functions, they won't do anything to your data

We are having another issue with Supabase, currently getting, the following issue, any one else?

Thanks <@!840454244280172594> - I haven't even used threads yet 🙂

Getting some issues with our login as well, network request errors and 504 errors

Three of us getting the error inside app.supabase.io as well

As well as our frontend

Can you show the request from the Network tab please?

Nevermind it's just started working again 🤷‍♂️

that's status 500 so maybe not an issue with supabase

its receiving req but it's responding with 500 as there might be some internal error?

Please create a thread for this issue, <@840454244280172594> <@195970119623507968>