I have a tables in my supabase database called properties, profile and saved. The schema for the tables looks like this: properties id int8 (pk), created_at timestamptz, description text, price text, address text, profiles id uuid (pk), updated_at timestamptz, username…
If already authenticated, i can access and call supabase.auth.currentUser to retrieve some user data like full_name, email, avatar_url, etc. But how to modify the data inside it?, so when i login and authenticated, i can call supabase.auth.currentUser that contains my…
I am trying to listen to supabase realtime changes when parentTodos is null. How can I do that? const { createClient } = require('@supabase/supabase-js') const supabase = createClient(process.env.SUPABASE_URL, process.env.SUPABASE_KEY, {}) // Set your custom JWT here supabase.realtime.setAuth('your-custom-jwt') const channel =…
For authorization flow, in middleware, I want to equal any value in a .eq statement. A normal user should only see a post if they created it. An admin should see any post though. const userMatcher = user.role === "admin"…
so i have created this method that does 2 things, one after another, the first thing this method does is sign up the user using supabase, the second thing is it saves the users info on a table, here is…
What I'm trying to do is to have a table that assigns a subscription to a user. All the samples I found so far do this via: (auth.uid() = user_id) However I would like to keep track of reassignments. With…
Trying to run an embeddings query on data stored from openAI. Currently using Supabase functions, using the following library. Any ideas on how to fix this? OpenAI Embeddings response is successful - const [{ embedding }] = embeddingResponse.data.data; const query_embedding…
I am trying to add raw_user_metadata on the auth.users table when a new user creates an account. However, I'm unable to find the documentation for how to do so in Flutter. The documentation exists for the Javascript client library so…
I have a Postgres function to find the top 10 most relevant vectors. I called this function from a supabase serverless function, but logs returned 500. The error I get is related to the <#> operator. It seems that PostgreSQL…
how to connect node js and supabase .I have completed front end using react . I need to get image as input from the user and store it in the DB.I need to fetch those images and display it in…