I believe you have to prefix environment variables you want exposed to the client with

NEXT_PUBLIC_

in next js

Sorry I'm not sure I follow. Why is the username authenticator instead of postgres? If it's postgres, doesn't that mean it bypasses RLS? When you don't want that, actually?

Sorry if this is too vague/basic of a question, but how would I go about creating a privileged userin supabase? Would I need to update a user profiles table on auth with privilege levels?

Hello people. Maybe they have already answered my question before. But is there any way to have two supabase clients on NextJs without conflicts?

Doing here I have a 401 error when fetching some tables, I believe due to cookies.

Has anyone tried the supabase-elixir package out? Thinking of trying that today (there's no guide sadly)

Hey I am trying to use Function Hooks to POST to my Firebase function but whenever I edit a row I get this error:

ERROR:  invalid input syntax for type bytea
CONTEXT:  SQL statement "insert into net.http_request_queue(method, url, headers, body, timeout_milliseconds)
    values (
        'POST',
        net._encode_url_with_params_array(url, params_array),
        headers,
        body::text::bytea,
        timeout_milliseconds
    )
    returning id"
PL/pgSQL function net.http_post(text,jsonb,jsonb,jsonb,integer) line 42 at SQL statement

My query is simple:

UPDATE assets SET description = 'Yes' WHERE title = 'Otto';

How do I fix this?

Yeah that is the solution, I managed to fix it earlier today. I should've left a note in this channel. Thanks!

Hi, the gotrue-js client library stores the session in localstorage. Why is this considered "safe"?

It probably only stores the JWT token in session storage and the token can be read by anyone as it is encrypted

(only the backend has the key which can decrypt it)

hi guys, why i reaceived 404 in this code?

when you call

typescript
const { user, error } = await supabase.auth.signUp({ email, password });

How would I go about attaching a username to the newly created user? I'm pretty confused about how the API works. I have a 'profiles' table that was created from the

User Management

starter, and I tried calling this after creating the user, which doesn't seem to work.

typescript
await supabase.from('profiles').update({ username }).eq('id', user?.id);

how about update your user.meta

im not sure if this a good practice

user.meta?

what do you mean? What am I doing incorrectly?

like this one

are you working with profile ?

Yes I have a profiles table.

I just wanted to be able to attach more information to a new user on signup because I want them to set a username/avatar etc

yeah were almost the same

Hello. I am new to using supabase. I was wondering if there was a way to connect to the database via vanilla JavaScript and the connection string or do I have to use a back-end framework?

Hey, Yes you can use vanilla JavaScript, too!

Which postgresql user should I use when I want to connect to the database via a third party application? Just

postgres

?

Is there a way to update rows based on current value. So instead of querying current value, you can say quantity + 10 for an update? I know Postgres supports it natively, does the API have a way of doing it?

I guess you can always make a stored procedure

and then call the rpc through the api

Is that the only way to do it? It is possible using Postgres natively.

i think that is the only way; otherwise you would need typescript to retrieve the row field, adjust it and then update it