What I want is to say, get me all records that are named new zealand OR france AND contain a certain keyword

Also, can I include multiple AND statements in an OR?

anybody have any recommendations for how to run a webhook when a certain row is changed in the database?

when using upsert on a supabase row, can onConflict take an array of values, in case you have multiple columns conflicting?

onConflict array

anyone here having trouble with CORS? I just created NextJS project (using v12) and using supabase.auth.signIn would throw CORS error

recently move to another supabase instance, and it works immediately. seems like there's a bug on a restarted instance

CORS error with instance

Hey all, I can't find anywhere how to sort data by date, for example i want to sort upcoming events, or get past events... Does anyone have that resolved or know the solution?

#869406062036529193 Hello everyone, i want display data with flat list or map function but i can't display related array data, how can i make? Thank you

what's the correct way to setup SvelteKit with Supabase? The auth works flawlessly on the client side, but how do I get the session details on the server end? There's several examples on github, but all of them themselves claim to be a bit "hacky" and perhaps not the correct way of doing things.

SvelteKit and Supabase

Hello guys, have some problems, I use real-time on my project, and all tables listening fine except one table , maybe someone has the similar issue. on().subscribe()

is this how you would get user profile after the user logins or session ?

useEffect(() => {
    setSession(supabase.auth.session());
    if (supabase.auth.session()){
      getProfile();
      //setProfile
    }
    supabase.auth.onAuthStateChange((_event, session) => {
      setSession(session);
    });
  }, []);

Hello team, I have 2 doubts of using the supabase lib. First. I have 3 tables to handle roles that can interact with tables based on the user relationship with the project, 4 tables:

users

,

projects

,

roles

and

projectMembers

with Primary keys

user_id, project_id

and a single

role_id

per user/project (not primary). I want to know if a given user is capable of reading a random table if we know the project owner of the table and the user itself. So i use this:

javascript
const { data, error } = await supabase
    .from("users")
    .select("name, projects(name, role:roles(name))")
    .eq("id", 1) // id of the user
    .eq("projects.id", 2) // id of the project
    .single();

The problem is that, even if i fix the FK of the project to 2 I still get an array for projects, and even if only one role can be assigned, I also get and array of objects. Is it there any way i can make foreign tables to be single if I know they should be only one??? This is what I get for example from the previous project:

json
{
  name: 'John',
  projects: [
    { name: 'ACME', role: [ { name: 'project_admin' } ] }
  ]
}

Also, another weird thing with the API, If i filter a foreign key and nothing is found, I still get all the table with

[]

in the foreign key. How can I remove entries that are empty or not found in foreign tables from the main table. Example:

javascript
const { data, error } = await supabase
    .from("users")
    .select("name, projects(name)")
    .eq("projects.id", 9999) // nobody is asigned to this project.

instead of getting

[]

I get all the users but with empty foreign key like this:

json
[
 {
   name: 'John',
   projects: []
 },
 {
   name: 'Mike',
   projects: []
 },
 // and all the entire list of users. When nothing should actually be returned.
]

I don't undertand but I think this issues are unavoidable in the Javascript library, aren't they?

Did you enable realtime /replication for that table?

doubts

Thanks, good point

is it possible to use a foreign key within a listener? so whenever a new object inserted the related data is also send in the payload.new

Realtime uses the replication feature of Postgres for the exact table you want a listener on. Because at the moment, realtime/replication ignores RLS you are probably better off just getting "an update occurred at" from the payload and then fetching the data with a new request that honors RLS, IMO unless it is totally public data.

thanks thats what i figured. currently the data is somewhat public (user info) but not something we'd want public access to.

Hey guys, I'm implementing third party authentication in react. After following the documentation, I'm presented with a null user object and a null session object. After a little bit of digging, I understand that this is the intended behaviour, but how would I go about authenticating my user without a user object? Any help is highly appreciated.

React auth

Hey all, I am wondering if there's a way to automatically reference the creating users uuid / auth.uid on insert in a table without having to send it from the client?

If you mean you want to insert the uid in a column then you should be able to set default to auth.uid() for that column.

yeah that works, thanks a bunch!

Is there a way to set up a webhook to run whenever a value from a specific column is updated?

I think it is possible via triggers and http extension, didn't investigate much just yet

i think i found a weird bug for the js client

well, that was fun to figure out