Supabase

S

Supabase

Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.

Join

Supabase seemingly prevents viewTransitions

Hi there! So basically I had a little SvelteKit website, nothing fancy, but with viewTransitions enabled and working. But since I added login with password and logged in to a test acount (following this guide my viewTransition stopped working. Now the page freezes for a few seconds and then display the destination page. It feels odd and unrelated but I just tested and am now sure that somehow Supabase (and/or its SSR integration with SvelteKit at least) causes this. I believe it is known, but is it fixable somehow..? Thanks in advance 🙂...

Invalid hook call with the supabase Getting started code

Hi! Wanted to try out the auth and got stuck. I followed the Getting started docs at https://supabase.com/docs/guides/auth/quickstarts/react (except the Step 2: Create react app) and got the following error and cannot figure out why. Can someone help me what can be the problem?...
No description

How to Protect Base Tables with Views? (view, security_invoker, authenticated user)

Hi guys. I'm a making a FlutterFlow app and use Supabase as backend. I'm not sure how to best protect my base tables and some of the columns. Here's my setup: - Users have to log into the app, so I guess only authenticated users are at play. - I have, for example, a reviews table with RLS policies (all tables have policies), for reviews table authenticated users can SELECT, INSERT, UPDATE, DELETE, but only their own rows as I use (( SELECT auth.uid() AS uid) = user_id) / (auth.uid() = user_id). I don't know what's the difference. - I created a reviews_view as suggested by the Supabase AI with security_invoker = on and I was also suggested to REVOKE SELECT on the base table FROM public, anon, authenticated; and GRANT SELECT on the new view TO authenticated. However, when I REVOKE SELECT on base table FROM authenticated, I can't load data. From what I have gathered, it's because security_invoker = on does it from the point of view of the caller, and the authenticated user does not have SELECT on the base table to load anything. - Then suggestions were to either 1) use security_barrier, security_invoker = off so it's done from view owner perspective (supabase admin) and it can be OK if RLS policies are correct. Is that true? or 2) write some helper function and the view should use the helper function to gather the data and then I have to restrict execute or something on the function (this is more complicated for me)....

Stripe wrapper support

Hi Supabase team, I’m trying to use the wrappers extension in my project. It installs successfully and shows up in pg_extension, but it never registers itself as a foreign data wrapper. • select extname from pg_extension; → shows wrappers installed. • select fdwname from pg_foreign_data_wrapper; → only shows postgres_fdw....

Viewing and quickly applying migrations from dev to prod.

I cloned my prod db into dev and ran some migrations against it. Now I want to apply those migrations to Prod in my actual application. What's the quickest and simplest way to do it? Preferably through the web app/web SQL editor.

I cant create Accounts

Hello dear Community, I am a newbie in Programming so I dont know much, im creating a App with the help of lovable but everytime I try to create a Account in supabase or in loveable it Doesnt work; Database error creating new user. I tried with some sql Commands with the help of Chat gpt: • Created profiles table with id, user_id, full_name, created_at • Enabled RLS on profiles • Deleted old overlapping policies; added clean INSERT, SELECT, UPDATE policies • Tried trigger on auth.users to auto-create profile → failed due to NOT NULL columns • Removed trigger; kept only SELECT/UPDATE policies → still “Database error creating new user”...

Database upgrade stuck

Hi all, I have upgraded the database to the new version and the upgrade is stuck at the phase "shutting down API" (it has been more than 2 days already). I have opened a ticket SU-247752 with no response for now. Does anybody have any suggestions? Thanks so much...
No description

Too many clients already, Supabase + Drizzle

An engineer helping me on an OSS project is running into
[Error [PostgresError]: remaining connection slots are reserved for non-replication superuser connections]
[Error [PostgresError]: remaining connection slots are reserved for non-replication superuser connections]
...

how do I see my total ingress / egress cached or not data usage per project?

Curently on a free tier... willing to upgrade when needed, but I need to see how much data I am using. where is GUI can I see this, or what is the apropiate SQL command to connect to this?...

safeGetSession() useless with getClaims() ?

Hi there! I'm currently following this guide and this video to use the new JWT Signing Keys. But since they verify the signature locally or else from Supabase's servers, safeGetSession() that calls getUser() (so from Supabase's servers) is basically useless, no? And same with getSession, it's pretty much useless, no?...

API Key shows in Request Headers

Please see the image, our API Key is exposed via network calls Request Headers. I'm using Supabase Library only. import { createClient } from '@supabase/supabase-js'; const supabaseUrl = import.meta.env.VITE_SUPABASE_URL;...
No description

PostgresError: Tenant or user not found

I am experiencing a connection/authentication issue with our staging database and would appreciate your help. One of our developers is consistently receiving the error "PostgresError: Tenant or user not found" when trying to connect to the database from their local environment. This is blocking their development work on our staging setup. We are trying to determine if this is a fundamental database credential/network issue or an error coming from our application's logic (like a database function). ...
No description

Azure auth (social/OAuth2) - getting email from a different field

One of the external organization we are working with is using a different field than the email as the reliable identifier. Basically, their reliable user identifier that has an email pattern is under another attribute (upn - or userPreferredName). Is there any known way of dealing with these things? Because the Azure auth provider is first looking into the email field that is return (which causes an issue because sometimes the email field is empty). I was thinking of the auth hooks, but there doesn't seem to be anything that would enable mapping the email to a different field returned (or a function that would get it using the azure token). We are able to get this info using the /me endpoint with the microsoft graph. Thanks for any help!...

Web hook

Does supabase always need athentication for webhooks. can we create public webhook that can be access or ????

Error on storage Search

Hi everyone, an error just happened in production 'randomly' because no changes have been done, but I now can't see the storage content in the app but also in the supabase dashboard:
Failed to retrieve folder contents from "documents": select * from storage.search($1,$2,$3,$4,$5,$6,$7,$8) - function storage.search_v1_optimised(text, text, integer, integer, integer, text, text, text) does not exist
Failed to retrieve folder contents from "documents": select * from storage.search($1,$2,$3,$4,$5,$6,$7,$8) - function storage.search_v1_optimised(text, text, integer, integer, integer, text, text, text) does not exist
...

Migration from one region to another for compliance

Hi, i want to migrate the supabase dashboars from one region to another, can some one help me with the process ? Is it going to be straigtforward or does it needs to be complex steps? Please suggest...

Supabase SSR + Middleware + HttpOnly Cookies?

Hello I’m currently working on my thesis project, it’s a patient record management system with appointment scheduling (using Next.js + Supabase). I ran into an issue: the Supabase cookies aren’t set as HttpOnly, which makes me worried about security....

Zapier and Supabase Postgres

I’m trying to have clients have real time data exchange with xero and sage through my saas but I only find zapier to allow me to connect those to loveable via supabase but I’ve been stuck with the Postgres SQL. It keeps giving me a error Can anyone advise please...

Database trigger

I created a database trigger that triggers my edge function whenever there is a change in the table to send the email notification to my client when their task is completed I tested my edge function and everything is working great there but there is something wrong with the database trigger While brainstorming with Claude, we experienced some issue with service role key being false when running a value details check SQL ...
No description

Realtime Subscriptions Timeout in Docker

I am new to supabase realtime connection. Recently I had hit a rly strange issue. TL;DR: NestJS backend apps use realtime for simple broadcasting (no database changes). When I ran and tested locally on my Mac, it works flawlessly. Same code inside Docker , getting subscription timeout errors. I tried with two of my colleagues , one is working and another one is having the same issue as Docker....