Does supabase rely on snap for anything?

I deleted all my existing projects in order to create another (Free tier) but I still get the "Limit projects" error, this happened to anyone before? How much time do I need to wait? I tried to contact the support team but the contact form gets me a 500 error.

\password postgres

< is this possible? I'm getting

ERROR:  42501: must be superuser to alter replication roles or change replication attribute

when I try

Also, does the UI allow editing records? Or just the table attributes?

Postgres user is not a superuser

Unexpected token < in JSON bug is still persistent, how to fix?

I believe this is connected to the Cloudflare loading page.

Any idea on if it's possible to copy an existing Supabase project into a

supabase init

based local development instance?

Supabase project to local development

Hi there, I'm using Sequin.io to sync airtable to a postgres hosted on Supabase. Now as part of the sync process, I believe Sequin.io made some permissions configs. As a result, realtime API does not seem to work for the schema / tables that Sequin.io created as part of the sync. Realtime API works for other normal tables created via Supabase's dashboard however. My question is – do I need to do some kind of co-ownership assignment or some kind of role permissions in order for Realtime API to work?

Hey there, are we able to use Twitters OAuth 2.0 with supabase? I want to reduce the number of scopes the connection asks for, as it prevents many users from authenticating with me. Thanks in advance!

supabase storage

.from.download()

returns old file after

.from.update()

. the supabase ui shows the newly updated image, but on my client side the image is still the old one. has anyone had this problem before?

Someone has experience/opinionated articles about how to structure a database with internationalisation in mind in the case of a multi language web app? (happy new year to all 😉 )

Hi all! I have a database on supabase, access it using prisma. Everything was working, but suddently it started not working anymore giving me this error Error: Invalid

prisma.texture.findMany()

invocation: Can't reach database server at `my credentials`:`5432` Please make sure your database server is running at `my credentials`:`5432`. The databse is not paused. Someone know why this happen?

Hello, I have a following question: How should I create an index on my column when I'm using the supabase javascript sdk? I have a following query:

let query = this.supabase.from<SupabaseMessage>('request').select('*').order('created_at', { ascending: false }).limit(limit);

Then I created index in supabase's SQL editor:

CREATE INDEX idx_request_created_at 
ON request(created_at);

It works well in the SQL editor, however it looks like it doesn't work when I'm querying data via the sdk (the index is not used, it takes ages to fetch these data).

using discord oauth with supabase why isn't the access_token being sent as a query param?

fragment vs query

Index not used when using supabase js client

Anyone know how you can enable multi organisations/projects with self-host?

Hi, If I have a date column and want to get anniversary/birthday (i.e. day and month match but not year) how can I do it with the Supabase API? The filters I have tried haven't worked This works in the supabase UI sql editor:

SELECT
  dob
FROM bday
WHERE date_part('day', dob) = date_part('day', CURRENT_DATE)
  AND date_part('month', dob) = date_part('month', CURRENT_DATE)

birthday column

Hey folks, yesterday I posted this little SQL function snippet:

create or replace function get_or_create_api_key(user_id uuid) 
returns varchar
language plpgsql
security definer
as $$
declare 
  kk varchar;
begin
  select key from api_keys into kk where api_keys.user_id = get_or_create_api_key.user_id;

  if not found then
      select encode(digest(gen_random_bytes(32), 'sha256'), 'hex') into kk;

      insert into api_keys(key, user_id)
      values (kk, get_or_create_api_key.user_id);
  end if;
  
  return kk;
end;
$$;

I added the line

security definer

with some help from another user in here because I was hitting a row level security violation without it, but I've realized, I think I do want row level security. Ideally, only the currently logged in user can fetch their API key or insert a new one. How would I do that?

Without reading your entire function, you can use auth.uid() in a test or to provide the users real uid to selects and such.

Oh interesting... so I could basically remove the function parameter then and just use

auth.uid()

everywhere there?

and that would work with RLS?

Your function is ignoring RLS, you are basically doing the same thing RLS does by using auth.uid(). If you want to use RLS then you have to not use security definer and get the function to work with it. Once again I'm not looking at what you are actually doing in the function.

Ok, I see. And what does auth.uid() yield when there is no logged-in user?

null

great, thanks

Hm ok another question. I'm trying to build out my sign up page with https://supabase.com/docs/reference/javascript/auth-signup. I don't understand the flow for the case where a user tries to create an account that already exists... it seems that the user object for the existing user is returned, and no session