Who should i chat with to have my supabase account email updated?

I have accounts with a user_id which is a foreign key to the users table. When i try to query accounts joined with users, it says no table users in the current schema. Do you guys know how i can fix it?

Changing supabase email account

Hi all, I am having a doubt/issue with the

generateLink

method to confirm an email for a new user. Do you know if there is any way to validate an email BUT disabling the "email confirmation" setting in a project (so the user can be logged in directly when signing-up)?

When I try to create a postgres function via the supabase UI I get the following error message:

Failed to create function: cannot use RETURN QUERY in a non-SETOF function

If I look through the return types that I can select there's no

setof

return type. Does that mean I need to use the SQL editor if I want to return a set of

x

?

Hi! How do i work with dates in supabase?

Export import database

Different environments

Is it just me or do the docs seems incorrect. Below is taken straight from the docs, but the console.log does not do anything.

js
    const { user, session, error } = await supabase.auth.signIn({
      // provider can be 'github', 'google', 'gitlab', or 'bitbucket'
      provider: "github",
    });

    console.log(user);

Dates in supabase

how to have realtime or like ajax in supabase

how can i trigger this when theirs changes in my table?

Hi all, How to get rid off this warning message (I assume it came from ESLint)

javascript
Argument of type '() => () => Promise<{ data: { openSubscriptions: number; }; error: null; } | { error: Error; }>' is not assignable to parameter of type 'EffectCallback'.
  Type '() => Promise<{ data: { openSubscriptions: number; }; error: null; } | { error: Error; }>' is not assignable to type 'void | Destructor'.
    Type '() => Promise<{ data: { openSubscriptions: number; }; error: null; } | { error: Error; }>' is not assignable to type 'Destructor'.
      Type 'Promise<{ data: { openSubscriptions: number; }; error: null; } | { error: Error; }>' is not assignable to type 'void | { [UNDEFINED_VOID_ONLY]: never; }'.
        Property '[UNDEFINED_VOID_ONLY]' is missing in type 'Promise<{ data: { openSubscriptions: number; }; error: null; } | { error: Error; }>' but required in type '{ [UNDEFINED_VOID_ONLY]: never; }'.ts(2345)

I'm using Supabase with Next.js in Typescript here is code.

javascript
const fetchData = async () => {
    const { data, error } = await supabase.from("went_well").select();

    if (error) {
      setErrorText(error.message);
    }

    setData(data);
  };

  React.useEffect(() => {
    fetchData();
    const mySubscription = supabase
      .from("went_well")
      .on("*", () => fetchData())
      .subscribe();

    return () => supabase.removeSubscription(mySubscription);
  }, []);

How to delete all rows from a foreign table, https://supabase.com/docs/reference/javascript/delete It's deleting single instance as of now

const { data, error } = await supabase
  .from('cities')
  .delete()
  .match({ id: 666 })

Am I able to update 2 fields in a column on 1 update, or do I need to call update() 2 times?

just remove the

match

method

js
const { data, error } = await supabase
  .from('some_table')
  .delete()

Supabase and Prisma

Hello there, is anyone has the answer to that? i'm trying to do the exact same thing. But for function that is triggered on auth.users INSERT, the

new

does not have the

user_metadata

property

@everyone could someone please help me with setting up the supabase github repository on my local or please point me to the thread if this is discussed before.

Please do not ping a role to get help, just wait

In case someone need to know how to use Twitter OAuth API on local enviroment for development purpose, refer to the closing comment of this issue https://github.com/supabase/supabase-js/issues/354#Fixed

I'm trying to use Realtime by self hosting supabase. However, I can connect, but WebSocket does not respond. When I tried using the free plan of supabase without self hosting, it worked, so I think the hosting is not working. (Using Docker for self hosting) I'm using the following version of supabase: https://github.com/supabase/supabase/tree/9f158a1eda1a6ecb4886fc006b5f8395e216e146

Hi guys, can someone help me with using array arguments in functions editor?

You will need the sql editor to create or alter the function to use arrays as variables or sets of records in returns.

Can you point to some examples please?

My use case is pretty simple. I need to increment a column from a group of users whose IDs I pass as an array.

Can I use json for that in functions editor? Is there someway to extract that array from json key value and refer in my where clause as.. where Id in (Array)

Hi

Can Someone help me with the docker installation, or better walk me through it. I don't get it.

I have changed the secrets in the .env files but I am not sure what I should do with the urls