is there an easy way to quickly generate a jwt for a user from the admin panel? i haven't working on auth in the front-end yet, just trying to authenticate supabase jwt's in my backend for now figured it out; just send yourself a magic link and fetch the token from the url 🙂

Does supabase or a blog provide a pricing example or would it be possible to recreate the firestore pricing example?(https://firebase.google.com/docs/firestore/billing-example) So that non database experts have an easier time to compare prices? Or could someone show me a rough way how to calculate it?

What does "Could not embed because more than one relationship was found for 'blog_post' and 'users'" even mean? i have a FK in "blog_post", where author is linked to users id

Trying to do this query, let { data, error } = await supabase.from('blog_post').select('id, title, users(id)');

is there a desktop client to view my stuff?

the web dashboard sessions expire so frequently it makes me want to quit supabase entirely

its incredibly frustrating

Session duration - Desktop client

Could not embed because more than one relationship was found for blog_post and users

Rbac

Hey, did you manage to resolve this? I'm having the exact same issue.

I did, got upgraded to the latest real-time release via an email to support and it worked like a charm

thanks, I'll fire off an email now. Any idea what the underlying reason was?

Not sure. I definitely had it narrowed down to that. I suspect something in my RLS policy. I do join in a permissions lookup table which also has RLS set so perhaps that was more than the initial real-time release expected

But I did see it even with the policy set to “true”

Yeah this is what I'm seeing currently: 1. Create a new table 2. Create a subscription to new table 3. See all events come through 4. Enable RLS, set policy to

true

5. No more events

Yep same behavior

Hi everyone! I'm building a project where I have an app and a store dashboard to manage each store listed on the app. I would like to have distinct auth for each one, can I do this in supabase with a single project?

Hey everyone, i've installed supabase in self-host I'm trying to connect by direct connection to the postgre db I but can't, do u have any idea why? thanks 😄

does it show any errors?

No, but I didn't install it with the cli but with another tool that integrates traefik and supabase on my instance, I think the problem doesn't come from supabase directly because my local version works well

I wasn't able to create any query with studio too x) so I'll reinstal everything properly

Hi 👋, I'm working on a setup to use the phone auth feature through twilio. I got it all working great, but I'm trying to figure out how tell if somebody trying to sign in actually doesn't have an account. Like I'm not getting an error message back saying that there is not user with that phone. This would be helpful to provide the user with helpful feedback or redirect them to the signup page.

Hey all, I am trying to create a policy to be able to access object from storage based on members of a project. But the policy seems to be not working, I tried to wrap my head around why it won't work but unable to think of a reason. Am I missing anything obvious here - The raw policy code looks like this -

create policy "Allow project members access to snapshots"
on storage.objects for select
using (
  exists (
    select 1
    from project_members
    where project_members.project_id::text = bucket_id and project_members.user_id = auth.uid()
  )
);

are there any ressources on how to work with foreing key restraints on the UI?

To enable cascading deletes for example

yo. I'm using supabase with next js and want to run getStaticPaths to generate paths for some detail pages. the issue is that I've enabled RLS to check the identity of the user before returning any data from the table I want to use for the detail pages. since the user isn't logged in when getStaticPaths runs, I don't get any id's to generate the paths with. my solution was to create a public table with all of the id's I need for routing. this works, but I was wondering if any of you have a solution that doesn't require adding an additional table?

actually it works better for me to use query params in this scenario.. 😅

I'm having some issues with the function hooks. I'm trying to create a stripe account after a new row is added to the profile. Using postman I can create a stripe account with the api.. But when I change it to use the function hook, I get the following error: Database+error+saving+new+user. Anyone run into this issue before?