Hello @VM! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User role so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the /title command! We have solved your problem? Click the button below to archive it.

Hi! I've been working with supabase for a bit now and have experienced a first today. One of our clients is using an aggressive spam protection layer (mimecast specifically). This is causing issues with any tokens in links (reset password, magic link, etc) because I think the spam protection layer is hitting the URL before it passes through the email. Anything going through these emails seems to give a 404 user not found error. Any ideas on what can be done? My goal is for them to reset their passwords.

I have this code here:

js
const { data1, error1 } = await supabase
        .from('activationkeys')
        .select("*")
        .eq('key', body.activationKey)

Used to fetch if there is a key in supabase. No matter what I do, no data is returned at all. Any ideas on when this would happen?

I'm new to SupaBase, and want to understand if something's possible. If I write a Database Function in plpython, I need it to make an external HTTP GET request to fetch data from an API, before insert it into a table. Can plpython functions on SupaBase use the requests library to do this? e.g. https://github.com/bryanthowell-tableau/postgresql-plpython-webservice/blob/master/plpython_example_1.py#L25 (not my project, just some example code)

Hi guys, trying to setup https://github.com/supabase/pg_graphql dev environment. Running

docker-compose up

fine, but met with this issue when accessing

localhost:4000

. Anyone aware of the issue? Thanks!

Any idea how I can change the name what's displayed on the Google Auth screen?

Hi everyone, I'm experimenting with the self hosted docker setup and I'm having a problem with signup confirmation emails. The link is either entirely missing, or incorrect. Is there a way to verify or change the link being send in the email? /auth/v1/verify?token=gZ9CE3EL-HlP3eM1WGeY9A&type=magiclink&redirect_to=http://localhost:3000/

How do i reference user id in sql?

hello! Anyone getting error 500 when invite by email? It worked a few times and stopped...

Hello guys ! I'm just starting using Supabase and I got a use case that I'm not sure how to handle it. I would like to update a row in the DB but without passing all values. I.e : Column Article [Id,Title,Rating], I would like to update the Rating without having to pass the value Title . Kind of a patch method. Is that possible ?

Hello @arcavid! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

How to have multiple Google Client IDs? I'm performing Sign in with Google on iOS and Android. But the audience's are different in the idToken due to needing different client IDs.

Is it possible to have "Enable EMail Confirmations" -> ON but sending custom EMails with links i generate with generateLink() ?

Is

@supabase/supabase-auth-helpers

in a transitionary state (read: "Please do not use it" state) from an old implementation to new at the moment? Looks like we can't use

withMiddlewareAuthRequired

at all because it depends on APIs that don't exist in the NextJS Edge Runtime (https://nextjs.org/docs/api-reference/edge-runtime), e.g. `Buffer`:

Hey guys I'm new to SupaBase, does anybody know how to create a query to remove an object from the array by matching an id.

Is it possible to have two websites connected to one supabase project? I have a restaurant website where customers can see their orders and the restaurant owner updates the orders. Thank you.

Hey peeps, I'm building a self-hosted HA and scalable Supabase stack on k8s using StackGres as our postgres controller, how can we split out read and write transactions to the db so that we can balance the read load using our replicas?

I seem to be missing something around the REST API. I've created a new project, created a new table with two fields (id and name) and checked the API documentation for how to use

curl

to access my data. However even a direct copy-paste of the command (with anon key) still returns an empty array. Is there anything else I need to do to enable the REST API?

Hi everyone! I've been trying to set up supabase with prisma and I was able to work with it for a while, now I'm getting

Error: P1001 Can't reach database server at...

even when trying from Beekeeper Studio, I had turned off connection pooling and turned it back on in an attempt to fix a 's3' already exists issue, which I don't find it to be very clear on the Prisma/Supabase docs (this was happening on a regular user create query), anyways, now I'm not able to reach the server 😭 Also I know passwords are not supposed to have any special cahrs, mine doesn't have any

Hi! I have 2 projects with tree tier. Connecting the first database with pgbounce(6543 port) always responds in about 25ms. But connecting the second database with pgbounce responds in about 15secs ping at first. Then it responds in 25ms. However after 10 minutes without any connecting, it is back to respond in 15secs. it acts like a serverless function's cold & hot loading. Can you help me?

Has anybody here got supabase working with prisma client using the rest api? Is that even possible? I need to use the rest api as I'm running on cloudflare, so there's no way to use TCP unfortunately

I've followed the docs on how to connect to prisma but I am having this issue where it says

prepared statement "s0" already exists

I understand this has something to do with connection pooling and pgBouncer, since I am working on a remix project that's being hosted on netlify but as far as I understand my connection string doesn't have the pgbouncer query param in it, also I've tried to change the connection pooling settings but it hasn't helped.

do you use a contextprovider/redux for authentication with routes in nextjs?

so i've got a bit of an odd one here; i'm trying to use Go to authenticate with Supabase, and it's having trouble getting the accessToken (and the rest of the query params, i'm using Mux) because the access token uses an anchor tag (

#

) instead of a query param tag (

?

). is there a way I can fix this, where I can set the tag or something? thanks!

when I ping the graphql endpoint I only get a heartbeat query available in the docs. Is there a permission or something that I'm missing to be able to receive the full docs to build gql queries? I've tested the rest endpoints and those work just fine so I'm not sure how to proceed here

hello! does anyone know if it's possible to bypass the max rows setting? we would like to keep the value low generally, but have a special case where we need to query all rows from a table in a serverless function, and we are hitting time limits due to the pagination, so are looking for a way to dump a table essentially

hi, i have a about 5 tables that has a function that is triggered by an input in table name 'event' in the other tables have a foreign key named 'event_id' how do i delete all rows from all tables that has the event_id of 'number' instead of doing it 1 by 1

Should the

STUDIO_PG_META_URL

and

SUPABASE_URL

in the environment variables for the Supabase Studio be pointing to the internal or public URL? e.g. for

SUPABASE_URL

https://supabase.test.com

or

http://kong:8000

Hello, I'm trying out Supabase for the first time and I've run into an issue... I have a function that I want to do database manipulation from, like this example but an insert() instead of a select(): https://github.com/supabase/supabase/blob/master/examples/edge-functions/supabase/functions/select-from-table-with-auth-rls/index.ts But running locally I get

error: Module not found "file:///home/deno/functions/_shared/cors.ts".

is there any sort of elegant way to handle environments (dev, staging, prod)? i am dreading having to set all of this up again now that i am about to deploy to a staging app and then eventually production.