Hi everyone, pretty new to Supabase & PostGres, I'm trying to create policies... I have a

post

table,

user

table and a

user_role

table. I want all user with

admin

role to see all posts but

default

user can see only the post they have created... I'm not sure how to write that, if you have any doc or example, I will be keen to have a look. Cheers 🙂

hey, im thinking about using Supabase for my next project but im wondering how it works because I was thinking to write my Backend as a REST API Service in Go and use Vue.js as the FrontEnd since i need some more backend functionality rather than just creating accoutns etc how would that work together with Supabase?

hi everyone. I'm very much a front end guy so feel free to explain like I'm 5. Anyway I have a users table and a classes table. I need it to be many to many so I made a

users_classes_join

join table. A few weeks ago that worked fine and I left the project alone. Spun it back up and now it doesnt work and I get this error

Could not find a relationship between 'students' and 'classes' in the schema cache

. I cannot seem to find a place to "reset schema cache" as the hint suggests.

How to add some search params in magic link? I noticed that there is a

searchParams

option in

signIn

method, but I don't know what does it mean. I've tried it but it didn't add any search params in the link.

hi

This link used to have the guide to create sql migration file for the changes you have made via dashboard, but now the link is dead. Where can I find the updated instructions. https://github.com/supabase/cli/tree/main/examples/tour

Hi team, i have started getting this error with google auth -

server_error&error_description=Unable+to+exchange+external+code

Hello @Cory! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

hey im currently trying to use Supabase in my Go Backend and Vue Frontend and im wondering how is it possible t use the Discord OAuth2 ? Like how does the Browser know when the User is logged in and that it stays logged in some sort of session? Does supabase handle that with the Vue library or does it not and is it something that need to be done in the backend?

Are there any tools out there for hunting slow queries? If I the magic genie gave me 1 wish - I would ask for something like a sourcemap linking each query executed in the Postgres to the specific place in code it was called from

Does Supabase Auth support something like Auth0 Organizations? (Where connected users belong to an organization for purposes of sign-in.)

I have a project I'm working on and Supabase is the DB and I'm using Prisma Client with it. Everything in dev is functioning as it should. I'm getting my data back from my supabase DB. Now, when trying to deploy it on both Vercel and Netlify, everything is building fine with no errors but I am getting a 500-Failed to load data error when loading the pages consuming the data. I read the supabase docs on adding a shadow DB connection, so I did this and my migration and build was successful and still everything is functioning properly. I updated my ENV vars with the shadow DB and deployed. All deployed without errors except I'm still getting the 500-Failed to load data error. Any insight would be appreciated!

Hey guys, not getting a reply from the support team. I tried pg_graphql and used comments to reflect the name of types and fields. But it failed when I tried to apply into existed DB. Is any way to regenerate schema?

Hey, what is the difference between accessing the user information from the user store like shown here https://supabase.com/docs/guides/with-vue-3#user-store and just getting it by supabase.auth.user() ?

Hey guys. When I try to put a large json object into my table, it doesn't work. The same query works, when the json object is small. Using the studio-GUI, I can input the large size json object into the table no problem. Am I overseeing something here?

Having some trouble with custom auth. We can't use any of the existing providers to authenticate our users bc our login is via a whatsapp chatbot We've been following this article and using

setAuth

to create a user session: https://medium.com/@gracew/using-supabase-rls-with-a-custom-auth-provider-b31564172d5d The problem is that

setAuth

creates a session not a user. Can I

signIn

or

signUp

a user without using a phone/phone provider or email/email provider?

If I need to check whether the user is logged via a SvelteKit endpoint, for example, for POST, would I require auth-helpers-sveltekit? Or do I just need to pass the token?

Every time when I do a request with pagination, the same item is given

Hello, is there any update on when Function Hooks will move beyond alpha? Or a sense of what may change or be unreliable? I'm looking to use Function Hooks to broadcast database changes to n8n for triggering backend workflows. Supabase (with Realtime) + Function Hooks + n8n = an incredibly productive way to build a modern backend!

is there a way to create a user in supabase with just username and password? No email needed or phone confirmation or whatever needed.

Hello, we are trying to find a way to store users images such as - 1.profile images 2. small size profile image thumbnails 3. General instagram type 1080x1080 images. I have 2 questions: 1. Can we limit, the size of an image that is being uploaded to certain folder:

users/{uid}/profilePhotos/

only allow jpeg type files and only if they are less than 100kb in size 2. Firebase has resize images extension that creates a compressed copy of stored image (something that we need for profile thumbnails), I see that supabase has its own

transformations

but it's been saying "coming soon" for a long time. When is it actually releasing and what should we use in the meantime?

i restarted the supabase server and i started getting - https://kxllhojpvujcdnzodrwk.supabase.co/auth/v1/authorize?provider=google

{
  "message": "An invalid response was received from the upstream server"
}

Hey, having some issue with policies. I have this policy on my table

clients

which has a foreign relation with user_id. My policy is

(uid() = user_id)

but it doesn't seem to work. When replacing it by

true

it works. I have checked the uid set is the same one that the user I'm logged in with..

hello anyone know how to setup google auth in react native app ..not expo @User

Is it possible to use

on().subscribe()

only on specific columns of a row and basically set up 2 different subscriptions for the same row which just listen to 2 different columns?

I have a storage policy that only allows authenticated users to upload an image for a profile picture. How would I prevent someone stealing my credentials and uploading images in a malicious attempt to reach storage limits?

I'm trying to set some user_metadata before the row is inserted in the auth.users database. Now I have it working that the data is set with a 'before_insert' trigger, however it is not returned in the response. This means during the first login this data is not usable. Is there anything I can do to fix this?

Hi guys. Can I use something else intead of "eq." ? For example I need "ilike". Thanks for help😄

I'm trying to use a single Stripe payment with the Stripe Card Element. It's supposed to request a secret key from a payment intent to the Stripe servers. It looks like I'm forced to build a little node.js server to handle that payment intent call and can't do it through supabase?

I want to enable

UPDATE

RLS access based on my

created_at

column (ex. value: 2022-07-06 13:56:30.622451+00)... has somebody made something like that work? So the user can edit their own db entry for 20 minutes and after that, the RLS access expires.