Supabase

S

Supabase

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

Join

About testing database function

Hello I was checking the documentation and I saw that it's suggested to use pgTAP to write tests, but I'm not used to that dev experience. Using the pg client with node-tap would work too? Is there any case which only pgTAP is supported for testing?

Best Practice for dev database

Hi there! I'm developing an app that will be deployed via a Vercel/Supabase/NextJS stack. So far, I've created a basic schema for my db and written a seed.ts script using Snaplet, which generates a seed.sql file that populates test data for all of my tables. This is neat, and offers a quick way to test my app locally, or even on Supabase preview branches, since I've integrated with Git and enabled automatic branching. However, what I really want is a functional dev database that contains real data pulled from the API provider I am using. I probably won't be working with huge volumes of data, so even a clone of the production database would be fine. I've read through many posts here and seen a few people with similar use cases, but it's still pretty unclear to me what the best development pattern for this is....

Cronjobs dont run

For some reason cronjobs dont run. It says next job will be next minute but that minute passes but nothing runs. No record of a job not even with failed status. When i click the 3 dots and run job manually then it does run.
No description

Retrive annonmous user after session clear and make session again

Hello I'm using nextjs with api routes with supabase, I want users annonmously sign-in with supabase annonmous sign-in and I am also generating device_id if user clear session and come back to app again instead of creating new user I again establish session

Unable to Sign In to Supabase Dashboard

I’m unable to sign in to the Supabase Dashboard. After signing out and trying again, I get stuck at the 2FA step since there’s no option to enter the code from my authenticator app. I also checked your Status page but didn’t see any reported incidents. Could you please let me know if this is a known issue, or if it might be specific to my account?...

`update().select().limit(1).single()` behavior not consistent

Hi we have two supabase projects. One's on postgres v15.1.1.73, the other is on v17.4.1.069. on the v17, this works, on v15 it doesn't ``` await supabase...

Race condition in insert

Hello, I have the following snippet: ``` const { data: prompt, error } = await supabase .from("prompts")...

How to add mTLS in calling a oauth2.0 api in Edge Functions

I'm calling a api of a bank, which the api method is by oauth2.0 and a digital certificate TLS. How can I call that api by that certificate, I have added the .pfx certificate as base64 to the supabase secrets for after reading it and generating the token but It doesn't work. Someone can help me?...

I’m running into an issue with reCAPTCHA validation inside a Supabase Edge Function.

I’ve registered all my domains in the Google reCAPTCHA admin console (including localhost, lovableproject.com, etc.). On the frontend I’m using the site key with grecaptcha.execute(). On the backend (Edge Function) I’m verifying the token with the secret key via Google’s https://www.google.com/recaptcha/api/siteverify....

purchased pro last night, realized storage too expensive for my needs, canceled, asking for refund

last night i signed up for the Pro Plan because i was thinking I would use the Supabase Storage. but today I was doing the math and realized it would be way more expensive for what I need at the moment and am instead just going to upload all my videos to youtube unlisted and have people that join my site also do something similar. as I didn't even use the Pro Plan and canceled basically right after subscribing, i was wondering if it were reasonable to ask for a refund? i wasn't sure where to reach out to ask for this, so I apologize if this is the wrong place to ask....

Failed to load function code - Unknown error (URGENT)

Almost all of my edge function are showing this now. Some function (even though i can't see the code) other's don't. I have contact support but not had a response. My whole application is down and I literally have no idea what to do...
No description

Registered without email confirmation

When a user creates an account, it is created without an email confirmation, even if email confirmation is turned on in the dashboard. Im using the default SMTP service. Any ideas?

Project-specific PostgREST schema cache stuck – PGRST002 errors

Here’s a fully Markdown-formatted version you can copy-paste directly: ````markdown PostgREST Schema Cache Issue – PGRST002 ...

Set lower Maximum Duration (Wall clock limit) for edge functions

Does anyone know if this is possible? There is no docs about this.

Avoid remote migrations being created when branching?

I use Drizzle to manage my migrations so I don't need to run any migrations with Supabase. I'm trying to create a staging branch, but every time I do Supabase runs its own migrations, even when I revert any existing ones that get added. Screenshot is me running supabase migration list before and after creating the staging branch. How can I avoid this remote migration from being created + run? What I've tried:...
No description

[Help] Supabase Realtime stuck on joining when using multiple components in Next.js

i’m building a cursor map game where when you enter the site your cursor shows to other players. i want to split logic into two components: - Room → handles showing other players - MainPlayer → handles movement + sending my position ...

Self-Hosted Supabase constant 100% CPU usage

Hello, I’ve been testing Supabase as a replacement for another self-hosted BaaS. I set it up on my VPS (8 vCPU cores, 24GB RAM) using Docker, following the official documentation. Everything runs without errors, but I noticed that all CPU cores stay at 100% usage constantly. It’s been several hours since starting Supabase, and the CPU load hasn’t gone down....
No description

Supabase MCP dont Work in my Cursor

I have an error when implementing the MCP in the cursor. I get an error that I have not been able to resolve. I connect the MCP as the Supabase documentation asks me to and it does not work. I tried with other colleagues' accounts and it works normally for them. { "mcpServers": { "supabase": {...
No description

Unexpected hard deletes happening on table (even after direct SQL inserts)

Hi, I’m running into a critical issue with my Supabase Postgres database. We continuously insert rows into a table, and the id column is an auto-incrementing primary key. What I noticed is that rows are suddenly deleted from the table, even though: • Our application logic never calls DELETE. • We only implement soft deletes (UPDATE is_deleted = true) in both server and client code....

Server side auth setup help needed

Hello, I am trying to set up a node.js and express REST api. I am currently generating the token client side via supabase auth, and attaching it to all api requests. I then validate it via the service role on my server, and pass it to a user client, in order to take advantage of RLS. Every time I try this, it returns 0 rows, or throws some other error (yes, im not dumb, the rows exist)...