I basically want to make my webapp invite-only. I implemented a workaround like this: https://github.com/supabase/supabase/discussions/3208 but I would love to be able to make unique invite tokens that people can just paste in and I verify if they exist in my db, then set to used or something. but how can I do that without making that table public (where someone could just select * tokens lol)

Hi everyone! hey, quick q, I need to give read-only access to my database to some team members. I tried adding. CREATE USER "[user]" WITH PASSWORD '[password]'; GRANT CONNECT ON DATABASE postgres TO "[user]"; GRANT USAGE ON SCHEMA public TO "[user]"; GRANT SELECT ON ALL TABLES IN SCHEMA public TO "[user]"; But the last step fails

I think it is related to my user not having full access to the DB supabase provides, does anyone knows how to fix this?

hey guys, is realtime rls available for old proyects? i been trying the whole day got get it working in a proyect I already have, but I couldn't. It didn't give any errors, but I wasn't receiving any updates either. Then I started a new proyect with the bare minumun necessary and just worked.

I also compared my settings and every seems to be the same

Where can I see supabase db logs? I wrote a trigger and a function on auth user created event. It just returns “Database error”

I don't think you can do that at the moment

Does anyone know if I can disable that app.supabase.io stays in sync on all tabs? I have multiple tabs open and I want to copy security rules but the page always changes 😂

I guess it looks very magical 🦄 - if everything is in sync, but the route should not change if you ask me

is it possible to run arbitrary select requests using the supabase-js client? the sql-editor within the supabase app seems to support any type of query. but an 'x-connection-encrypted' header is required to make the calls. i'm trying to create a complex query with joins, filtering by joined columns and to order the results from a foreign table column. how do other people perform complex queries?

I was going mad because of that haha, at some point I disabled networking in one tab

Is there anyone having problem with "Email Confirmation"? When I create user on the server supabase forces them to confirm their email adress even if it's disabled from the settings...

Yeah this will ok, but since you are referencing

auth.users

and in that table there is no reference to this, you will be creating a relationship of many to 1, which means that when querying from users to get integrations you (might) get an array of 1 item. Instead of an object directly. But still, you are safe to know that the array will be always one item (perhaps you get an object with the query and not an array, this is only my assumption with what I know today)

Hey 👋 I just posted a question related to Supabase on Stackoverflow to be searchable in the future. Maybe someone here have an idea 🙂 https://stackoverflow.com/questions/70214826/creating-nested-relationships-with-supabase

can i get only the last entry from table with .single() ?

okay, figured it out

How would I get multiple users by id? I've tried a few things but unsure

const { data: users, error } = await supabase
      .from('users')
      .select('*')
      .in('id', userIds);

As long as userIds is an array of user id that should work. Assuming, if you have RLS on, you allow any id to be read.

Anyone else where RLS with Realtime still doesn't work where the primary key is a

uuid

, or am I under the wrong impression that it was actually fixed a couple of hours ago? 🙂 - JS client verison: 1.28.5

Seems like they have to role it out into the servers. 1.28.5 addressed some of the issue, but appears the realtime server has fixes also. https://github.com/supabase/supabase/issues/4201 note the description is outdated as PG13 has issues too, pointed out further in the reply chain.

Thx bud, thought it was a client issue overall - just gotta give them some time then I guess. 🙂 (I'm on PG13)

At least until we are able to upgrade easily ourselves hehe

Hey guys! all goes well 😊, Quick (noob) question. What would be the right/best way to request data and subscribe to new data using nextjs? The idea I have in mind is a kind of setTimeout.. and Im 99% sure there is a better/simple way to do this with nextjs and supabase, thanks. I saw some documentation on the website, so I tried this:

const todos = supabase
      .from('todos')
      .on('*', payload => {
        console.log('Change received!', payload)
      })
      .subscribe()

but its not working.. but a simple request is working fine:

const { data: todos, error } = await supabase.from('todos').select('*')

so why is not working the subscribe and second thing, where is the rigth place to place this peace of code on nextjs. Thanks!

https://supabase.com/docs/guides/api#managing-realtime - Done this? :)

Hey I'm trying to toy about with Supabase in local dev but struggling to get storage working. It seems that running the docker image runs with a configuration that has storage disabled and using the cli/`supabase init` just hangs indefinitely for me

Is there some way to configure storage when running with docker-compose?

Alternatively, is there any way to run

supabase init

in a verbose manner to see if anything is occurring or if it's hanging immediately?

Hi. I'm using Prisma with my supabase database. I'm having problems with a migration script it generated. It has a bunch of SQL statements that run just fine. But then it comes to index renaming, and it just fails.

ALTER INDEX "E1spCarCategoryCount.carInfoId_categoryId_unique" RENAME TO "E1spCarCategoryCount_carInfoId_categoryId_key";

That's an example of a rename that fails. Should this be supported? Does it look wrong in any way?

I've connected to my DB with a gui db admin tool, and can see the index

The error I'm getting is "An I/O error occurred while sending to the backend."