how can I differentiate that case from the case where a new user object was created, but the email confirmation step has not yet taken place?

i.e., on the user interface, how do I present the user with: "That email is already taken, did you mean to sign in?" versus "We sent you a confirmation link, go click it"

Here is one discussion I've seen on this (mainly the later part) https://github.com/supabase/supabase/discussions/1282 Note once a question goes much beyond a single reply "they" really want us to use threads, especially if reply is not to last post.

i was feeling super lost with this too when i tried working with it yesterday, thanks so much for linking that thread! 🙏

how do you make AND statements? like supabase.from().select().eq().eq()?

like eq("Id", id).eq("owner_id", owner_id)? does that work?

I want to build a small game where players can just join via an invite link into a lobby. I don't want them to have to set up an account. (and I don't really want to store anything on the users besides their username and game stats) Now I'm thinking of just generating a random string for email address and password client side (without showing the user). I could then store username and the password in cleartext in localstorage, so that the user could be logged in next time automatically - but I'm having hesitations as this sounds like obviously a bad idea - and would storing the credentials even be necessary anyways?

Hey, in the FAQs on the pricing page it is written that one can have 4 free projects (2 orgs with 2 projects). I have 1 org with 1 project and want to create another but get this error "Failed to create new project: You have reached the limit for the number of free projects you can create" Same happens when I create a second org. Is this a bug or did they change the free project limit?

Heyo, how do I write this using the supabase-js client?

select k.key, u.*
from api_keys as k
join Users u on u.id = k.user_id;

That works, or you can combine them into a single .match() filter See: https://supabase.com/docs/reference/javascript/match

Heya! Coming from working mainly with MongoDB, so pretty new to Postgres and the whole ecosystem. Just wondering if I have a table with a foreign key, can i populate that column? For example, when i get an article, can i the populate the author (which is an ID of a user) with the user information like name etc?

Hmmm that is interesting, I have 2 orgs with 3 projects each. So I maxed out at 6. Ive had to selfhost a few projects since

Haven't tried this myself yet, but I think this may be what you're looking for: https://supabase.com/docs/reference/javascript/select#query-foreign-tables

I'm trying to work my way through that same guide, I don't really understand how the documented syntax maps to standard sql join syntax

how do you guys manage users with supabase auth?

how do you select a user from the users table?

const userRes = await supabase
        .from('users')
        .select();

Trying to write a little auth middleware which maps a token -> user. I've tried

users

,

auth.users

, etc, it seems there is no table for it. "relation "public.auth.users" does not exist"

ty! i’m new to auth and triggers. let’s say i want to set a trigger where if a new github user signs up. it will update their profile with their github username and avatar_url. so the user doesn’t have to set it. ty for help.

Thanks mate!

triggers

Does supabase creates index automatically for every foreign key?

Or do I have to explicity do it?

You need to create any indexes you need or want.

k thanks

Hey guys, i am trying to delete things that are related to some reference. For example I have post and that post have comments, if I as an owner delete that post from my profile, I want to delete all comments which are related to that post id. Is there any solution for it? I researched and found something like cascade deleting or something like that. I am not the expert in sql. 🙂

are there any examples projects/docs of using the Function Hook Triggers? Im interested and seeing how the payload looks since we're using AWS Lamdas. Also, if anyone has done this before, id love to chat!

on delete cascade

Hello, I'm getting this error in Supabase Storage and I'm not able to create a bucket

column buckets.public does not exist

Hey everyone, I have question regarding the policies, first case is that i want to have one superadmin who can do all operations, how can I achieve that?

When i am creating a new user, do i need to add something like role: 'superadmin' or i need to update user_metadatain auth.user()