{message: 'Could not find a relationship between chats and user_id in the schema cache', hint: 'If a new foreign key between these entities was cr… in the database, try reloading the schema cache.'}hint: "If a new foreign key between these entities was created in the database, try reloading the schema cache."message: "Could not find a relationship between chats and user_id in the schema cache" Is there anybody who is having this problem on relational tables?

Redirect to

could not find relationship

is there a better way to get user session and user profile at the same time when user logins. my current method

useEffect(() => {
    const userSession = supabase.auth.session();
    setSession(userSession);
    if (userSession) {
      getProfile(userSession.user.id);
    } else {
      setSession((s) => ({ ...s, profile: null }));
    }
    supabase.auth.onAuthStateChange((_event, session) => {
      setSession(session);

      if (session) {
        getProfile(session.user.id);
      } else {
        setSession((s) => ({ ...s, profile: null }));
      }
    });
  }, []);

as started little in general, does supabase return discord token when authorized using oauth? im looking forward to use that token to do authenticated request to discord API

I think that's as good as it gets

Yes, the session includes the provider token

hm, gonna need to figure out why discord returns me unauthorized but at least i know now where token is 😄

is there a way to get more than just the ID of the row I'm deleting via the Realtime listener

?

Hii all Can someone guide me with the policie 1. post owner can CRUD works

auth.uid() = author_id

2. public can read published posts works is_published = true 3. authenticated user can read all his posts How to achive this? I can only see published post

even when you're authenticated in?

yes

is there any ordering of the policy.? after setting

select is_published = true

even loggedin i cant view the post

Probably want an OR as the condition for the select (read) policy. (is_published = true OR auth.uid() = auther_id)

Does anyone have more information on memory % usage? We are at 70% and don't know if that's good or bad. From my perspective it's bad but I wonder what does everyone else look like?

Hello! I'm trying to create a oauth login on a flutter app using supabase, but it keeps returning me this ⤵️ "Kong Error" screen

this is the code

Hi, does Supabase has DDoS protection? since PostgreSQL is charged by usage, I'm a little bit worried

Kong has the ability to rate-limit using a built-in plugin and I'd be willing to bet that the default Supabase deploy has the plugin installed otherwise Supabase projects in general would be vulnerable to that kind of abuse. Supabase uses Kong as a gateway for all API requests to any Supabase service in your project https://docs.konghq.com/hub/kong-inc/rate-limiting/ Also PostgreSQL is charged only by database space, you should have unlimited API requests so the only threat from a DDOS attack would be slowing down your DB. If they did end up forcing your egress usage (2GB) the Supabase team would reach out to you about the limit being met and you could figure out how to mitigate against that attack, but your services would remain online. https://supabase.com/pricing

is there a way to get more than just the ID of the row I'm deleting via the Realtime listener?

I suppose u call supabase createClient with the anon key already.

Can someone shed some light on the ability to choose a cloud provider or region/data center for supabase cloud deploys. Currently I only notice Aws in thr Us region and would like to deploy to gcp in frankfurt region with GDPR regulatory requirements. I don't want to self host.

See Notes and Listening to deletes: https://supabase.com/docs/reference/javascript/subscribe

Is there a downside for using it? Like performance?

U may ask supabase team...

Bet

And thank you very much

Hi gang! Is it possible to generate a signedURL from an rpc call? I'm making an rpc call in JS to get a record, but I'd also like the ability to return the signedURL of an image in my bucket associated with that record. Is that possible? Thanks!

You could check how the storage api creates a signed URL in PostgreSQL and recreate it in the RPC function. You'd need to create a signed URL using the normal API and then just check the storage schema in the supabase dashboard to see what data is being stored and such.