realtime filters

@User @User @User @User @User I'm having an issue while creating a new project: > Your account has reached its free project limit > > Your account can only have up to 2 free projects - to create another free project, you'll need to delete an existing free project first. Otherwise, you may create a project on the Pro tier instead. So, I deleted all of my projects except one:

But I'm still not able to create a new project:

Hey, do you have projects in other orgs?

No, I don't think so. These are all the orgs that I belong to in that SS.

If there are projects in another org (e.g. there might have been a "Hammock" org that I no longer have access to), feel free to delete them if you're able to on your end.

So I am trying to append a data to my database and have the database create the ID. this is the error that we are getting: {message: 'duplicate key value violates unique constraint "workoutDetail_pkey"', code: '23505', details: 'Key (id)=(3) already exists.', hint: null} in workoutDetail table i checked 'Is Identity' for column id

how can I get supabase to ID itself while I'm inserting the data

I guess my question is how to set a table to have an auto increment for the ID column in a table

Unique key constraint violation

I was hoping to set up a trigger to delete storage objects when related records are deleted. There is some discussion here of the topic: https://github.com/supabase/supabase/discussions/3124 My question is: is it possible for a postgres function in Supabase to have access to environment variables, so I don't need to hardcode my API service key into a database function?

Hey, I have a performance related question regarding the eu-central-1 region. We are currently experiencing some delays in our app but also in the supabase portal: - The token grant took more than a minute and single queries take also 30+ seconds for resolving - In the portal I get notified Error 504: Connection terminated due to connection timeout Is this a current issue or are we the only ones experiencing it? Looking forward ! Update: We are currently not able to login and receive "The upstream server is timing out" for the token grant. Is there anything we can do to resolve this? We have customers running on it

how to i secure the database from the client side if i am not authenticating users? is this possible? all i have to do is check the network tab to see the PostgREST url and i can make requests as if i was in the browser

this is in a serverless environment. without a server i can't use a JWT otherwise it woudl be visible on the front end

Security

Performance Issues

Hey all, very relevant survey for this group: https://www.stateofdb.com/ We've been working on it for the last few weeks and wanted to make sure that we hear from as many devs as possible so our sample size is big enough. Obviously, I'm interested to see how Supabase stacks up against some of the other older DB offerings in the space. Be sure to fill it out so you can see the results once we share them in about a month.

I'm trying to write an RLS policy for my storage.objects table to restrict access--I get the following error, running the SQL as user `postgres`:

ERROR: must be owner of table objects (SQLSTATE 42501)

Is the

postgres

user restricted from modifying that table for some reason?

It seems the owner of that table is

supabase_storage_admin

Connection timeout

Hello I am using supabase and trying to push some video on bucket but it is showing me the error code 401 which is invalid JWT

Someone please help me with that?

Error when pushing to a bucket

Folks, is it normal dor the supabase studio to keep asking you to relogin? I signed up with github and am on a free tier

studio login

hello guys, I would like to ask in relation to the pricing. storage. the 1 GB transfer limit, when will that reset? per day? or per month?

Hey guys! I have a question regarding the XP you can gain by contributing with PRs. Are all repos counted? I have 1 accepted PR and one more i am working on for storage-js and i didn't gain any xp

i trying to connect my supabase db via pgadmin but getting

could not connect to server: No route to host Is the server running on host "db.lksadjflksadjfsad.supabase.co" (54.159.187.247) and accepting TCP/IP connections on port 5432?

I have postgres running locally and I was able to connect to my supabase db yesterday and no changes were made. any ideas?

XPs