I have a PostgreSQL trigger that fires after an INSERT on the auth.users table, calling a function handle_new_user() which, in turn, calls insert_into_profiles() to add user data to another table. The insert_into_profiles function is defined as follows: CREATE OR REPLACE…
I want to identify who is on my app so I can place green badges as indicators. I logged into my app (which I have not deployed) through Google OAuth, so the session is stored. However, I left days ago…
I'm working on a Next.js project where I want to conditionally render navigation links in the header based on user authentication. I have a NavBar that handles the rendering of links. For authenticated users, I want to display the links…
I have the issue that some files, for example many videos seemingly cannot be properly uploaded with base64 encoding, but with React Native the update function of supabase only works with base64 encoding, i can't upload them. Is there any…
I have this user_id which works as a FK for both tables of station and types . Data definition: create table public.types ( id uuid not null default uuid_generate_v4 (), name text not null, price numeric(10, 2) not null, user_id…
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'm having an issue when in my Next.js application when trying to fetch data via a route handler. My database has a users table that contains an ID called user_id that matches the uid of the authenticated user, and aps_id…
I have this /app/auth/login/route.ts import { createRouteHandlerClient } from '@supabase/auth-helpers-nextjs' import { cookies } from 'next/headers' import { NextResponse } from 'next/server' export async function POST(request: Request) { const requestUrl = new URL(request.url) const formData = await request.formData() const email…
I ran this query REVOKE SELECT ON services_connected FROM anon; and added this policy create policy "workspace_only" on "public"."services_connected" for all to anon using ((workspace_id = (((current_setting('request.jwt.claims'::text, true))::json ->> 'workspace_id'::text))::bigint)); My Expectation was that this would restrict select operation but…
I'm working on a React + Node application where users fill out a form on a web page and receive a Discord role. I've been advised to store the Discord API key on the Node server rather than in the…