Supabase

S

Supabase

Join the community to ask questions about Supabase and get answers from other members.

Join

Architecture Q: we use per-customer schema. Can supabase scale to 100s of schemas?

For separating customer data we use a per-customer schema approach. So far we have 20 schemas and our system has no issues so far. Are there any limits or scaling concerns if we were to scale to 100s of schemas?

postgrest exception: Function is restricted to service role

I'm currently using supabase-py version 2.18 and with the following setup: ``` url = os.environ["SUPABASE_URL"] key = os.environ["SUPABASE_SERVICE_ROLE_KEY"] ...

Loveable to Local Environment -- Need help migration Supabase

Hi there! I am a Supabase noob, but have engineering and local environment experience. I am picking up an app that was created in Lovable with Supabase, Typescript, React, and Vite. My first goal is to create a local environment, as some of the features aren't really working well in the Loveable environment (for example, testing password reset emails). Here is what I have done so far:...

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Getting Error:
Function uuid_generate_v4() does not exist (SQLSTATE 42883)
Function uuid_generate_v4() does not exist (SQLSTATE 42883)
Is this just that we need add extensions before our use of uuid_generate_v4()?
extensions.uuid_generate_v4()
extensions.uuid_generate_v4()
...

E-mail sign in vs Magic link - the user object

Hello, I'm trying to add Magic link sign in to my app, however a session created from a magic link does not contain the user object and therefore I can't get user ID (from auth.users) which my app needs. Here's an example: ```kt og.error { "Fetch test: session: ${supabaseClient.auth.currentSessionOrNull()}" } ...

Realtime only getting DELETE events

I've found many cases of this happening to others, but in all cases, as far as I can tell, it's been because the user is doing something unusual/custom. In my case I have a very simple setup. Just a single "shopping" table in my public schema. The only thing I can think that might be wrong is the RLS policy I set on the table. Since I wanted only authenticated users to use my app, but all authenticated users should have access to everything in the "shopping" table, I made a policy like this:...
No description

Google signs in automatically on android, even when signed out?

Hi! I have implemented Sign In using Supabase C# on android. Magic Link and passwords work as expected, but when I'm signing in with Google in the browser, after the first initial sign in, I am immediately signed in without getting the chance to select another account, even if signing out. Would anyone know if this is an issue with my Supabase settings, or rather something to do with cookies or Google settings or something?...

Invitation link Error

Hi there, any idea how to fix this? This is my config and when receiving a invite link I'm getting this error {"error":"requested path is invalid"}...
No description

New Branch Question

After creating a new branch (development) I want it to be identical to the current production branch (main) but the data is not required only the schemas, tables, functions, triggers, etc...

Branching and how migrations are handled.

I created a persistent branch called "staging" that is linked to a branch in Github called "staging". I commit to the branch and this triggers the changes to be pulled and applied on Supabase for the "staging" branch. However if I add a new migration it is not picked up when the branch is updated. Is that expected behaviour?

Supabase Auth /token API 429 rate limit reached

summary I'm getting a rate limit error with the superbase auth API. I'd like to resolve this, so any information would be greatly appreciated. ...
No description

Stripe Sync & FDW co-existence

I have a project that was configured to use the Stripe FDW and I now want to exploit the Stripe Sync Engine (https://supabase.com/blog/stripe-engine-as-sync-library), do I need to remove FDW & tables or will Stripe Sync engine co-exist with FDW?

Upgrading from nano to micro

I am considering upgrading from nano to micro. What is the length of downtime? Do I need to make backups beforehand?...

Can I use PostgREST api directly with fetch?

This isn't so much a help request as a curious question. I learned from perusing github that supabase's js client for the postgres db is based on PostgREST. So that made me curious if it is possible to access the PostgREST api "directly" – which is to say, in the manner I would normally use a REST API, with fetch() and http-urls, as described in PostgREST docs. I didn't see any mention of it in the supabase docs, but I imagine it would be possible. If it is, could someone give me a quick rundown of how? And also: which version of the PostgREST docs should I be looking at? As to why I would want to do this – I have no need at the moment but I notice there are some things possible through PostgREST that aren't (apparently) possible via supabase's js client. Notably aggregate functions and transactions. So I was curious if it was possible to still use those features of postgres just in a more cumbersome way....

Paypal client id and secret key can't be connected

Also, one more I put paypal client id, and secret id to edge function secret, but it does not work at all. Is there anyway that I follow to solve it? I am really confused now....

Edgefunction Secret key

I’m encountering a problem in Settings > Secrets where different environment variables for PayPal Sandbox and Live end up showing the same value, even though I entered different ones. Steps to reproduce: In Settings > Secrets, enter a unique value for PAYPAL_LIVE_CLIENT_ID and PAYPAL_LIVE_CLIENT_SECRET....

Connection pooler aws-0-us-east-2 unreachable Prisma - P1001 error

Hi! Having connection issues with our project that uses prisma to interface with the databse. We pay for the the pro plan and are new to supabase. The application on our local dev machines cannot connect or test the application it was completely functional and then suddenly P1001. Its been working for days no code changes on our side. Supabase has no IP Bans either visible in our Supabase Dashboard Error: P1001 - Can't reach database server at aws-0-us-east-2.pooler.supabase.com:5432 Region: US East 2...

Searched for a foreign key relationship between 'autosend' and 'profile' in the schema 'autosend'

Hi! Having a supabase issue, I have two schemas. One called public and another called autosend I have a table in the autosend schema that references a FK profiles.id in the public schema, for some reason when trying to access it through supabase-js I get this error ```js {...
No description

Fixed IP - Supabase

I need Supabase to have a Fixed IP address. All request that I make, have a differente IP address. So I'd Like to use a Fixed IP. How can I do this?...
No description

Squash Expected Behavior

I just tried squashing. My result was this: Local | Remote | Time (UTC)
[lots...]. times.... [squashed]. ...