i want to store users by discord id

Sign in with third party providers will trigger a sign-up event if the user isn't already registered: https://supabase.com/docs/reference/javascript/auth-signin#sign-in-using-third-party-providers

So, i want my bot to store the data on a database, without any discord auth because that wouldn't be user-friendly. If they want, they can login to the dashboard and manage they data- but only their. idk if that's possible

Hi guys, I was wondering if there is any way to have an Administrator on a website? I can't find something about Admin with the Auth from Supabase?

I need an admin to be able to write in a table where others should only be able to read from

is this possible some kind of way?

One way would be to create a new column with roles or permissions and look for it on every route change. In my project, I have a "profile" table with a column "permission". Only users with 9 have access to administration options.

Saving markdown

how would you check on that then?

sorry for potentionally stupid questions, I am quite new to this whole stuff

It depends on the framework you are using and the type of project you do. But in my case, I have a "if" where I check if permission == 9, then I show the content of the page, and else, I redirect to login page. Also, I use Row Level Security to confirm that every sensitive modification to the site are made by a user with permission == 9.

I use react and the project is just kind of a hangman game page i guess. Did you do a special policy for RLS? Because thats one of the thing I do not get that much, I only know how to use the templates

Is there a way to create users without a email or something?

you can create them with phone numbers if thats better

not really...

What do you want to use to authenticate users?

do you just want to use an username instead?

Yeah, I get Row level security is not really easy. But, you have access to everything with dot notation, so I can check permission of a profile by looking where auth.uid() = profile.id and profile.permission = 9. If it returns true, the authenticated user will have access to the content. A good video to learn about RLS would be this one: It helped me a lot understanding RLS

thank you very much

So, i want my users to see their message count and server owners to edit their guild settings & co. The user should can do that without using an email adress or something like that. If he wants to use the dashboard, he can login (so an auth account will be created) and edit his data, but not the data from others

is that possible?

if you're making a bot and dash with supabase, its pointless to not have discord auth for a discord bot

How do I import a database

How do you save markdown in Supabase? Just a Text field?

does somebody know why my signup mails only get sent to some people?

the user is created completely fine it just doesnt send the mail

so i deployed the stripe subscription example on vercel

could someone maybe give me a hint on this error

i try to login with github and it kicks me to a localhost site

vercel is throwing this out Failed to compile. ./pages/signin.tsx:51:58 Type error: Type 'Provider' is not assignable to type 'Provider | undefined'. Type '"linkedin"' is not assignable to type 'Provider | undefined'. 49 | const handleOAuthSignIn = async (provider: Provider) => { 50 | setLoading(true); > 51 | const { error } = await supabaseClient.auth.signIn({ provider }); | ^ 52 | if (error) { 53 | setMessage({ type: 'error', content: error.message }); 54 | } error Command failed with exit code 1. info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command. Error: Command "yarn run build" exited with 1