Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I have a DB trigger to create profiles on auth signup, identical to https://egghead.io/lessons/supabase-use-supabase-to-subscribe-to-database-events-with-postgres-triggers

```sql
create function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, full_name, avatar_url)
  values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url');
  return new;
end;
$$ language plpgsql security definer;
create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();
```

Oh I'm seeing the first part of your message now, so it creates a profile, this is relatively quick to do so I don't think it would lead to the profile not being ready by the time you reach the next-steps page

How are you retrieving the profile from the DB?

hmm, maybe its a slightly different issue then

my `next-steps` page is SSR, with `user` and `profile` both being fetched by the server

but i set the supabaseCookie via a client side api call

I think that's where the issue is, the request to the profile is probably happening before the cookie is being set

So it's not sure which user it should be looking for

how can I ensure I set the cookie before I navigate via `redirectTo`?

I'm doing something hackish in my SvelteKit app (which I'm sure will work in any other SSR framework), I first redirect to a page that then redirects to the next-steps page, so the cookie gets set when I redirect to that page first before moving to the `next-steps` page

This hopefully will be fixed in the future as the team is working on something around this from what I can remember. So this step won't be necessary at that point.

I made the first redirect page like a loading screen that just redirects after a few milliseconds

waiting for the cookie to be set instead of polling is much smarter

Yep, mine was even worse because you would log in and couldn't see the protected pages and be redirected back to the login page because I was setting the logged in session based on the cookie being set first.