Where can I find a proper changelog for the

supabase

repo? https://github.com/supabase/supabase

It looks like the delete button in the webapp is not taking care of all the foreign keys when removing an auth user. Should the UI button take care of all that for us?

I'd like for new ones to continue on from the previous row, but there seems to be a hidden counter thats incremented. How can I reset this?

js
  const reqData = await req.json()
  let { id, url } = reqData.record;

    const { data: urlExist } = await supabase
    .from('url_data')
    .select('id')
    .ilike('url', `%${url}%`)

it getting empty array, but there is a item with url with that value, for example

https://supabase.com/docs/guides/database/webhooks

Hello folks

A new site we are working on seems to be operating fine, but once every couple minutes a random web request we will see that there is a cold reboot taking place. We haven't run into this in previous projects and are paying for the pro tiers on Vercel. The cold boots take around 15 seconds to resolve. Without coldboots, the pages resolve in a couple hundred MS. We aren't sure whats causing the very slow cold boots OR why it's happening so often. The PGBouncer, Postgres & Vercel logs are attached. We are wondering if we misconfigured PG Bouncer? There are several errors/alerts from Supabase and we aren't sure if our supabase is causing the issues OR those are happening as a result of the coldboots.. Any help would be greatly appreciated!

With Next js I am getting unauthorized exception when trying to use nextjs custom loader. But works fine if i just download it with supabaseclient. appreciate any help

I'm working on an online board game akin to chess of sorts and I want to have as low latency as possible in UI changes between users when they make updates. I've been using "postgres_changes" as the source of truth to sync UI state between clients. There's definitely a bit of delay when there's multiple updates firing so I'm starting to toy with Broadcast as a faster layer to sync updates and make DB changes in the background but I'm scared it might lead to issues with syncing state. Curious what the Supa team or anyone else's thoughts are for improvements.

Just as the title says, specifically speaking, would it be possible to invoke an edge function everytime an data base change occurs on say a table?

I have a function that uploads an image to a storage bucket and then returns a publicURL so the front end can use it. When I deployed to vercel the function does not upload the file. I have logs to detect errors but my vercel server logs don't show the error but shows the success What would cause it to work in one environment and not the other? RLS turned off, env variables are correct and set on vercel

We have a Prisma schema that includes a profile model with an id, uid, email, firstname, lastname, and roles field. The roles field is an enum with values ADMIN, GUEST, and MEMBER. We want to create a rule that allows users to get only their own profile data unless they have the ADMIN role, in which case they should be able to get all profile data. Here's the rule we came up with:

sql
sql
Copy code
((auth.uid() = uid) OR (EXISTS ( SELECT 1
   FROM profile profile_1
  WHERE ((profile_1.uid = auth.uid()) AND ('ADMIN'::roles = ANY (profile_1.roles))))))

The first part of the rule (auth.uid() = uid) works fine and gets the user's own profile data, but we're having trouble with the second part. We want users with the ADMIN role to be able to get all profile data, but this part of the rule doesn't seem to be working. Can you help us figure out what's wrong with the rule or suggest a better way to implement this functionality?

Greeting Everyone, Can I use supabase auth into my server, pass the whole payload to supabase client, and start using the normally. If yes, then in which function can I pass the whole payload? The reason for doing that is that we want to use other phone auth providers currently not supported by supabase. It will be easy to use this with RLS. Thanks

the database which i generated using supabase command cause problems with my deployment

Anyone run into this notification using auth-ui-react when a user is signing up?? Can't seem to find anything in the documentation and I'm trying to better understand what causes it

Are there any resources or examples available that demonstrate support for RLS (Row-Level Security) in a server-side environment? Our current fetching method is failing when Next.js runs it on the server, but it works fine when we fetch it on the client side. We suspect that the issue may be related to cookies, headers, or authentication. If anyone has a working example that we could check, it would be greatly appreciated.

What's up everyone - I'm building a to-do list app and want users to sign in with google before being able to create their lists. When I was using the

/pages

router I would just use

session

from the

useSession

hook to determine weather or not to render the login page - but i'm not sure if this is the same case when using the

/app

router. There's a page(https://supabase.com/docs/guides/auth/auth-helpers/nextjs-server-components) in the docs on building auth flows with nextjs 13 but on the repo it seems that the

Login

client component is rendered regardless of the user's auth status. Can I use the

useSession

hook in

page.tsx

?

I'm using svelte auth-ui in my application. There's many features missing in auth-ui library and I was thinking of contributing. I tried to make a feature request but the issue chooser takes me to the supabase discussions. What's the right way to move forward? CC: @silentworks (since they've contributed heavily to the repo; hope it's fine to ping)

I've made a QStash receiver in Supabase but it's not playing nice. This is my code:

import { serve } from "https://deno.land/std@0.187.0/http/server.ts";
import { Receiver } from "https://deno.land/x/upstash_qstash@v0.3.7-canary.0/mod.ts";
import supabase from "../_shared/supabase.ts";

serve(async (req: Request) => {
  const r = new Receiver({
    currentSigningKey: Deno.env.get("QSTASH_CURRENT_SIGNING_KEY")!,
    nextSigningKey: Deno.env.get("QSTASH_NEXT_SIGNING_KEY")!,
  });

  const payload = await req.json();

  const isValid = await r
    .verify({
      signature: req.headers.get("Upstash-Signature")!,
      body: payload,
      clockTolerance: 5,
    })
    .catch((err: Error) => {
      console.error(err);
      return false;
    });

  if (!isValid) {
    return new Response("Invalid signature", { status: 401 });
  }

  console.log(JSON.stringify(isValid));

  console.log("The signature was valid");

  return new Response("OK", { status: 200 });
});

When a message comes in, this is what my console sputters:

TypeError: Failed to execute 'digest' on 'SubtleCrypto': Argument 2 is not an ArrayBuffer or a view on one
    at makeException (ext:deno_webidl/00_webidl.js:88:10)
    at Array.converters.BufferSource (ext:deno_webidl/00_webidl.js:564:11)
    at SubtleCrypto.digest (ext:deno_crypto/00_crypto.js:458:30)
    at Receiver.verifyWithKey (https://deno.land/x/upstash_qstash@v0.3.7-canary.0/pkg/receiver.ts:73:50)
    at async Receiver.verify (https://deno.land/x/upstash_qstash@v0.3.7-canary.0/pkg/receiver.ts:28:25)
    at async Server.<anonymous> (file:///home/deno/functions/hex-explored/index.ts:10:21)
    at async Server.#respond (https://deno.land/std@0.187.0/http/server.ts:220:24)

When reaching out to QStash they made an example on Deno which was working fine. Anyone has an idea?

I'm running into an

"invalid json response body at https://<project-id>.supabase.co/rest/v1/rpc/update_embeddings reason: Unexpected end of JSON input

error when making a bulk update on a table using an rpc:

ts
interface allEmbeddings {
ada_002_embeddings: number[];
ada_002_total_tokens: number;
ada_002_prompt_tokens: number;
id: string;
}[]
const supabaseHeaders = {
    "Content-Type": "application/json",
    apikey: supabaseKey,
    Authorization: `Bearer ${supabaseKey}`,
  };
const updateEmbeddingResponse = await fetch(
      `${supabaseUrl}/rest/v1/rpc/update_embeddings`,
      {
        method: "POST",
        headers: { ...supabaseHeaders },
        body: JSON.stringify({
          json_array: allEmbeddings,
        }),
      }
    );

The Postgres function code:

sql
CREATE OR REPLACE FUNCTION public.update_embeddings(json_array jsonb)
    RETURNS VOID
    LANGUAGE plpgsql
AS $$
DECLARE
    _record public.search_dataset;
BEGIN
    FOR _record IN
        SELECT * FROM json_populate_recordset(null::public.search_dataset, json_array::jsonb)
    LOOP
        UPDATE public.search_dataset
            SET ada_002_embeddings = _record.ada_002_embeddings,
                ada_002_total_tokens = _record.ada_002_total_tokens,
                ada_002_prompt_tokens = _record.ada_002_prompt_tokens
        WHERE id = _record.id;
    END LOOP;
EXCEPTION
    WHEN others THEN
        RAISE NOTICE 'Error occurred: %', SQLERRM;
END;
$$;

If I use a simple

update

on the table, I'm able to update date, but I want to call the rpc to bulk update. No issues with RLS here.

Hi, Is there any way we can allow users to sign up for an account without forcing them to verify their email address but once they are inside the application to generate a link that allows the users verify their account? React Remix + Supabase (Stack) Thank you!

I meant Airbyte. I don't see Supabase in the Airbyte list here (https://airbyte.com/connectors). Is there a different connector that Supabase is available to? Thanks

Hey so i am trying to create a webhook that calls my edge function. I've made it so it gets called everytime there is an UPDATE or INSERT in my table. How do i actually get a certain columns value from the row that got inserted into the table? like what would i put for value here?

I ask this to supabase documentation AI, but it has answered three diferent think, so, here I am... Talking about web apps... If I as user of a chat app, if I suscribe to a channel and i close the browser tab (never execute an unsuscribe() function), and i dont enter to that app anymore, my channel will be active forever?

cannot cast type bigint[] to uuid[] when i try to link user schema to another schema through the unique indentifier?..

When using useSession() from the auth-helpers-react, how do I wait for the session to be loaded? I am trying to redirect the user to sign in page, if there is no session. But it seems that the session is always NULL before the session is set to the session value or NULL. How do I make sure whether the session is actually null, and no just loading?

ignore this question, my issue was that I didn't have

proxy_cache off;

set on my nginx instance that was in front of my local supabase 😩

File "C:\Users\alpla\Desktop\SUIFrogs\Chatter-Project\ChatImposter\main.py", line 30, in <module>
    from supabase import create_client, Client
  File "C:\Users\alpla\AppData\Local\Programs\Python\Python311\Lib\site-packages\supabase\__init__.py", line 1, in <module>
    from postgrest import APIError as PostgrestAPIError
ModuleNotFoundError: No module named 'postgrest'

I have been working with supabase for a week or so now and after some package conflicts I wanted to make a new venv and Docker later, but this error appears everytime. I've installed everything I can think of from supabase, supabase-py, postgrest, postgres, postgrest-py and a couple other ones. Any help is appreciated.

Hello, I am using Draftbit and Supabase to create a social media app and I am struggling with uploading images to my buckets. I am using base64 and struggling to make a post request. Does Supabase storage accept base64 format? If so how do I send it to buckets?

I see the Hcaptcha integration with auth endpoints, however is it possible to use Hcaptcha with SQL inserts as well? I have a contact form that uses a sql insert when the form is submitted, and I'd like to have a captcha before the user submits the form. Any ideas?

Hello everybody, I have been playing around with supabase recently and very new to all of it. I have been making a website that gives the user CRUD functionality on Items, I have the create and delete working fine but saldy the update is not working probably now I have been looking through my code and haven't seen a reason why it won't work but then I have realised that it could be the Policy on Supabase it's self. This is my code in the itemsClient.ts file for updating items

ts

const updateItem = async (id: string, item: Partial<IItemRemote>) => {
        const update = await client.from('items').update({
            ...item,
            id,
        }).eq('id', id)
    }

and in images you will find the policy how it stands now I do have users has one of the columns in the items table and it works with uuid Hope anybody can give me some pointers on this issue Thank you in advance!