Supabase

S

Supabase

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

Join

electron auth session persistence

I'm working on an electron app using nextjs and supabase auth, how do we set it up such that the user is always logged into the app when they open it? particularly, how do we ensure that the refresh token gets refreshed properly? I feel like I keep seeing it kicking me out randomly due to the refresh token getting invalidated, mainly when I reopen the app after the computer's been closed/asleep for a while. I'm storing the session tokens in electron encrypted safeStorage.

Problem with supabase dashboard

Hi, I'm having problems when I try to go on my project. The page keeps loading until I receive this pop up...
No description

Using Supabase MCP Server in ChatGPT

I am trying to connect ChatGPT to Supabase MCP server Doing it with codex was easy because all I had to do was adding this code in Codex config file: ```...
No description

Did Supabase Change Auth Hooks?

I have been using auth hooks for a while now based on the supabase documentation. https://supabase.com/docs/guides/auth/auth-hooks/custom-access-token-hook All of a sudden, users logging into our application were getting errors related to the "custom_access_token_hook" despite no changes to either our codebase or supabase configuration....

Auth Failed to delete selected users: User not found

Hi everyone, I’m having trouble deleting a user directly from the Supabase dashboard (Auth > Users). When I select the user and try to delete, I get a “User not found” error, even though the user is clearly listed in the dashboard with a valid UUID and email. ...
No description

How to configure fly.io with supabase realtime?

I am using y.js with socket.io (fly.io) and trying to implement it on supabase

How difficult is it to enforce data residency using Supabase self-hosting?

I'm talking to a potential client about building a platform using low-code technologies. One of their technical requirements is that their data must be stored in a particular country in the MENA region. Since the country/region is not listed in Supabase's available regions, I presume that I must self-host the back-end on a server physically located in the country of choice (but please tell me otherwise). Has anyone encountered the same issue, and, if so, how did you solve it? P.S. - I haven't self-hosted Supabase before, so any tips/things to look out for for my specific use case would be very appreciated!...

Account consolidation

Hi everyone, new here and have a basic question regarding account consolidation. I have an existing account on Supabase; and then Vercel/v0 created another Supabase account for me with a different email. I would like to merge/consolidate the two account to the original one I created; alternatively update Vercel’s installation with my own. What’s the best way to do that?

Slow Queries

I can see i have some slow queries on supabase but i cant filter to see only them in the Query Performance. Am i just missing something?

Should you ever use RealtimeClient.channel.unsubscribe()?

I had been "cleaning up" my realtime subscriptions by calling unsubscribe(), but it looks to me like that's not the intended flow? I thought if I called unsubscribe() on the channel object, I could call subscribe() later to resubscribe, but that fails since unsubscribe() doesn't set this.joinedOnce = false There's also removeChannel(), which seems like it must be the intended way to do this? I wasn't using it because it has the side effect of closing the websocket if the number of channels reaches zero which I was finding annoying in React Strict mode (my app always needs the socket open), but if that's the correct way to clean up realtime subscriptions then I'd rather deal with fixing those issues. I just wanted to understand the intent of channel.unsubscribe() when RealtimeClient.removeChannel seems like the only "correct" way to do this!...

Can't create a project

Even though i have only 1 project currently(it was 2 but i deleted them), i am unable to create a new database. I can't understand why. Is there anyone to help me ?
No description

multi tenant auth

Hey everybody. I am trying to implement multi tenant auth where isntead of supabase's implementation of the email being the key, I have a subdomain + email as a composite primary key. I don't think this is built into supabase, but please correct me if I am wrong. If it's not built in, anyone got some pointers? Haha. Was looking into 3rd party auth that supports idp, but if I can stay with supabase that would be great. Thanks....

Can't access project after upgrade completion

Can't access project after upgrade completion Hi! I'm stuck on the "Upgrade completed!" screen and can't access my project. The page shows: "Your project has been successfully upgraded to Postgres 17 and is now back online" "Return to project" button doesn't work ...
No description

Declarative DB - Trigger isn't written into migration file

Good morning! I'm using declarative database, and then creating the migration files following the steps in https://supabase.com/docs/guides/local-development/declarative-database-schemas. I was successful with initially setting up a table, and now I'm adding RLS and a trigger function on the table. RLS alteration and policy looks good in the migration script, but then I had some issues with the trigger function. 1) Before defining the function, set check_function_bodies = off; was set. Makes general sense to set this, but then it isn't turned back to on in the migration script. Based on my limited research, this seems like something that should be reset - does Supabase do this silently, or does it have a different approach here? 2) The trigger wasn't written at all. The function looks good (Separately, the $$; at the end is replaced with $function$; with a new line before the semi-colon, but I assume this is WAI) --- but the trigger isn't written at all. https://supabase.com/docs/guides/local-development/declarative-database-schemas#known-caveats doesn't list anything about issues with triggers, so I don't know if this is a glitch. For the format of a migration file, I assume I paste the trigger as it's written in the *.sql, but no idea how alterations will be written in the future. Any advice?...

CLI type generation and UUIDs

When I run npx supabase gen types typescript > database.types.ts, all my primary and foreign keys that are UUIDs in SQL become string in TypeScript. Is there a way to make this a TS UUID type? (Other than redefining all columns in my TS app — not really an option given the amount of foreign keys in use). Or are there good reasons to not want this? I guess the query itself also results in type string? Do we know if there is a specific reason for that?...

Timeouts when running simple queries, fixed for a little when restarting supabase project

Hey, For some reason my supabase is getting a lot of timeouts after a while (less then an hour) and its fixed again when i restart my project. I switched from Neon to Supabase, where this wasnt happening....

Guest users not able to place an order from the website. Also, signed in user

1. I have check out as a guest option where any customer can place an order without sign in. I'm facing below error for the same.Supabase error, it would be greate if anyone helps as my system is currently in prod. Fetch error from https://wnocqkyhnsckgpyzmgsj.supabase.co/rest/v1/orders?columns=%22user_id%22%2C%22cart_items%22%2C%22subtotal%22%2C%22delivery_fee%22%2C%22hst%22%2C%22total%22%2C%22delivery_info%22%2C%22payment_info%22%2C%22status%22&select=*: { "code": "42501", "details": null, "hint": null,...
No description

🚀 Optimizing Text Search in PostgreSQL (Supabase) – Looking for Suggestions

Hey everyone, We’re working on a proof of concept where we need to search through millions of messages efficiently. Our main goal is to enable searching based on the text content itself (not semantic meaning). We first tried using vector embeddings with Supabase’s native support, but the results weren’t ideal — embeddings returned unexpected matches like “goodbye” or “greetings” when searching for “hello.”...

Problem the web charge

I´ve a website with supabase and react, and have problem the charge, reload the website Where the page reload, it´s a bug charge it´s by supabase o te website?...
No description

Any article link to check the breaking changes of the @supabase/ssr 0.7

hey guys my next app is using 0.6.1 version of the @supabase/ssr library, so before upgrading to 0.7 or to latest version, where I can check the breaking changes, or its completely safe to upgrade it to the latest version.