well i have been using typescript for 5 months only so perhaps there is a way I am not familiar with

Is there a way to do a select & update atomically with the client?

As far as I can see, upsert won't allow you to get the data first to use it in the update. (aka insert balance + 5)

hello! I've been running into some trouble with storage uploads. Everything works fine running locally, but when I deploy to vercel I get RLS errors on any uploads. I double checked the policy on the bucket and it should be fine, and uploads from localhost to the bucket work just fine. Thanks in advance!

Isn't it vulnerable against XSS attacks?

Depends on how you make your app

Did you update the redirect url in the api settings? It's set to localhost:3000 by default

I don't know if that's the cause of your issues but it might be

@User I thought to try that too, thanks. Actually I'm thinking this could have all been user error on my part... I moved on to something else and deployed to another branch url on vercel and now it's working so IDK

I've been trying to play around with supabase all day via vanilla JavaScript. I can connect to the database, however I cannot do CRUD operations (because I don't see any documentation for CRUD in vanilla JS). Is there anyone who can give me an example of any CRUD function using vanilla JS? p.s. Since my files aren't modular, I think I have to use fetch functions.

@User https://supabase.io/docs/reference/javascript/select on the left sidebar under

data

has documentation for crud actions

and @User not exactly what you are looking for but here is an example repo for trying authentication out in a vanilla js app

It's a push in the right direction, so I am thankful.

Hey I was wondering if anyone would be able to point me in the right direction to debugging a long query. I am running my app with redwoodjs/prisma & supabase and I host it on netlify. I noticed on my production site that my query seems to be running really slow. TTFB on prod is 3.5s. Connecting my local environment to my productions database TTFB is less than 1s. I know this query is a larger query with nested models. I didn’t want to rely on the browser to check out the request so added some tracing to monitor the request. When running the request locally to my production database is roughly 365ms
 
 running the same query on production database from production serverless function is roughly 2584ms which is 7x slower
 One thought that came to mind is the potentially the serverless function is hosted by default on us-east, where my supabase instance is on us-west any other thoughts why I might be hitting a bottleneck?

localhost with prod db

production app with prod db

is postgres support full text search on json? or if ever is it not recommended as it is not efficient as simple column like text/varchar

So after doing some digging and experimentation I have noticed that my performance significantly gets degraded when using the pg_bouncer connection string and that using the normal database connection the long requests were cut by more than half. Has anyone from the supabase team had a similar experience?

is supabase api down ? i cant acess it from my app or even the website

please someone do reply , i have an app running in production which uses supabase as backend

Does the SQL server respond?

Via api? no. But i tried a select query on supabase control panel sql and it works fine from there

The console works for me

Should

pg_net

requests be able to be performed inside loops?

i contacted

beta@supabase.io

, It was some internal error due to they rolling some upgrades and they fixed it for me when i mailed. ♥️

Awesome

Why can't I create a trigger on

auth.users

with the

postgres

user from a third party tool, but with the

supabase_admin

user from

app.supabase.io

hey all, having a hard time finding docs about this or i'm searching wrong. how can i create a new role in the roles table and associate it to a user? for now i created my own roles table for custom roles

Hi, if I want to prevent a column from being updated, is the best approach to use a trigger or configure roles? I have an updated_at column that automatically get set to the current time, but I want to prevent someone from passing through a value when updating a row.