#843999948717555735 I have a problem with next.js/SSR and Supabase. I am following the next.js starter tutorial but I wanted to load the profile before the page render. To achieve that I moved the respective code under api/

export default async function handler(
  req: NextApiRequest,
  res: NextApiResponse
) {
  const user = await supabase.auth.user();
  const { data, error, status } = await supabase
    .from("profiles")
    .select(`username, country, avatar_url`)
    .eq("id", user?.id)
    .single();

  if (error) return res.status(status).json({ error: error.message });
  return res.status(200).json({ user: data });
}

However, I am getting an error response

error: "invalid input syntax for type uuid: \"undefined\""

Can't I reach logged in user's id inside the API folder?

SSR and user

Hi Supabase, I have a bug where if a field is of type text, when I want to change it to an array type, it doesn't work.

Can anyone help with a signup flow and RLS. I have this code

export async function signUp(credentials: Credentials, name: String): Promise<Player> {
    // Create the user
    let userRes = await supabase.auth.signUp(credentials);
    console.log("signUp", userRes)

    if (userRes.error) return Promise.reject(userRes.error);

    // Create and insert a Player
    const newPlayer = {
        user_id: userRes.user.id,
        name
    }
    // insert takes a list
    const { data, error } = await supabase.from(PLAYERS).insert([newPlayer])
    if (error) return Promise.reject(error)
    return data[0]
}

And setup Select and Insert RLS with

(role() = 'authenticated'::text)

But I get an RLS error about creating new player

Hello, I am new to supabase. Today I use the table editor but I realized that the table is by default added to public schema. Can we create new schema or am I missing something?

Try creating a new field with type text and Define as Array checked. I think you can't change this after creation of the field.

Hi! I'm working on a project where I need to use variables to define my request and more precisely one where I could get data for foreign tables. My code is working, except for the part with Order and Range. The returned list contains my foreign tables, but it is not ordered and I think the count doesn't work.

oops I found it by run sql script via sql editor hahaha

it's most likely a PostgreSQL error that's not shown on the UI because

text

cannot be implicitly casted to

text[]

. If your table is empty and does not have data, just drop the column and add it again with the new type. Otherwise, if you need to cast existing data from

text

to

text[]

you can write a query that uses

string_to_array(value_from_column, delimiter)

... see this answer for how it can be done using the SQL editor: https://stackoverflow.com/a/27195528/10976714

You may need to specify the schema in the Policy — ie

auth.role() = ….

@User - this is what I have

What is the different between Auth and Auth (Server only?) If I am using for example sveltekit and using endpoints (call supabase from server, not frontend) should I focus on the documentation about server then?

honestly, I don't use the UI to create policies so I'm not very familiar with it.. it'd be helpful though if you share the error that you're receiving

Here you see that the confirmation that the user was added to the users/auth table, and then the error that occurred trying to create the player @User

hmm, same errorm, but perhaps this wll be an easier way to iterate

Server only

hmm fuck I think I forgot my database password in supabase, any way to recover it? Or do I need to create a new database?

It is not the anon key right?

try this in the SQL Editor and see if it works:

sql
alter user postgres with password 'new_password';

is the default user postgres?

where can I run queries in the dashboard?

ok found the query ui

Order

Is it possible to change server regions? or is there anyway to migrate my current db to a new project located in a different region?

How do I create a trigger to make sure

created_at

is not changed by the user? I'm thinking:

typescript
create trigger posts_created_at after update on posts
OLD.created_at === NEW.created_at or undo transaction?

I'm not sure how to confirm this...

There may be some automated way to deal with that, but at a minimum if you have a trigger on update that does new.created_at = old.created_at the value the user provided would be ignored.

right, but how? I would think this would be a standard security issue that someone has already solved, but I can't find anything

Well if no better way exists, or no one else responds with it, you just do an update trigger on your table and call a function that does new.created_at = old.created_at and returns new (which it has to do anyway).

I don't think you can return a value, as it only returns boolean. I'm thinking the trigger checks, then if false runs a procedure to add old value back? or do I need just a procedure...

need some help here (i wont be available though, going to sleep right after this), i have an additional redirect url for my dashboard (https://dash.example.com and https://dash.example.com/auth/callback, in case either one doesn't work), and when i oauth with supabase, after auth is completed it just sends me back to the site url and not the redirect url i specified. my code:

supabase.auth.signIn({ provider: 'discord' }, { redirectTo: `${process.env['NEXT_PUBLIC_AUTH_ENDPOINT']}/auth/callback` })

any and all help is appreciated!