I noticed Supabase allows hooks in order to listen to database changes. However is there a feature that would allow Supabase to listen to external incoming webhook in order to trigger database updates?

Hello guys ! I've on question, can i put that in my Site URL ? I used only for signup, login and reset password. I don't have any website for my app and I don't need it. How can I do that ? Ping me if you'll repond me 😉

So I had a client invite me to their supabase DB and when I click on the email it tells me

Your email address [My Email] does not match the email address this invitation was sent to.

Where can I change the email template for magic links on the local environment?

Hi! I tried to host supabase via docker. Everything seems to start up fine and I can access Supabase studio. However it gets stuck in "Connecting to Default Project". In the console it says that all attempts to get data from Rest is unauthorized

hey folks, I'm building a NextJS app and trying to use the Supabase provided auth. I am sending a Sign In request locally and can see it appearing in the Authentication requests, but no email is being received to do the sign in - any idea what might be going wrong here?

Hi! I'm trying to setup OAuth with Gitlab but self-hosted Gitlab instance. Is it possible to set the Gitlab URL in

app.supabase.com

? By default the OAuth takes me directly to

https://gitab.com

Hello. I have a big probleme. Since today, I can no longer access the page allowing me to manage authenticated accounts via your dashboard. When I click on auth, I am redirected to the right link but the page is completely empty and grey.

Hello - I'm trying to list files in a storage bucket, but I'm getting empty results. Wondering if I'm missing something...? I'm calling:

js
const { data, error } = await supabase
.storage
.from('public-assets')
.list('accounts/c36a689f-484b-46fb-aac2-9ad397603009', {
    limit: 16,
    offset: 0,
    sortBy: { column: 'created_at', order: 'desc' },
})
// Data returned is []

I've attached a screenshot of the bucket within the UI (It's set to public and has 4 assets in it) Any ideas on why this may be happening? It appears I'm making the same API call on my app's network tab as the supabase UI's network tab when listing these assets, but the response is different. Is it a permissions/RLS thing?

await supabase.auth.user(jwt)

and

supabase.auth.api.getUser(session.access_token)

both return null and return a "Could not read User ID claim" error. I am using a third party auth provider and manually generating the JWT using the JWT secret. does this mean I'm not actually signing in the users? i followed the instructions from this tutorial https://medium.com/@gracew/using-supabase-rls-with-a-custom-auth-provider-b31564172d5d

is this actually the way to set the value of a key in jsonb...this can't be shortest way but i cant for the life of me figure it out.

_res := jsonb_set(_res, '{myval}', to_jsonb(7.8::float));

like why cant i just do

_res->'myval' := 7.8::float;

or something

I need a help .. i have a games table .. every game has followers so i have game.followers ... followers is array[] string like followers : [ 'user1' ,'user2' ] . i want array of users followes the game or not users list [ 'user1','user2'] .. how can i filter this two .. ??pls help me

Hello @Relisora! 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.

server auth with supabase on Next.js?

hi guys, which storage policy should I use? I want to upload and display the image to public. But only authenticated user can upload.

trying to login with Twitter, this is the error I keep receiving:

supabase-cli

supabase db remote commit

errors with

Error: unexpected end of JSON input

Hello @Mike_! 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.

Hello, I'm getting an error when attempting to update my table to have a compound primary key. I've attached a screenshot. Any ideas on why this may be happening?

is column level security a thing? e.g. I want my users to be able to edit their username but not their age?

Does the database on supabase support creating multiple databases with CREATE DATABASE?

is there a way for authentication user simple username and password? Thanks!

I'm using the Sveltekit Auth Helper and Supabase with RLS. All my GET requests are working, but I keep getting 303 response from the following. Can someone please help me see where I'm going wrong?

..,/endpont.js
    export const post = async ({ locals, request }) =>
    withApiAuth(
        {
            user: locals.user
        },
        async () => {
            const body = await request.formData();
            const bodyObject = setMissing(getFormBody(body));
            const { data: surveyAnswers, error } = await supabaseServerClient(request)
                .from('profile')
                .update({
                    first_name: bodyObject.first_name,
                    family_name: bodyObject.family_name
            if (error) {
                console.log('update error profileCommunity:', error);
                return {
                    status: 400,
                    body: { error }
                };
            }
            console.log('Data:  ', surveyAnswers);
            return {
                status: 200,
                body: { surveyAnswers }
            };
        }
    );

Been banging my head against a wall for some hours, cannot figure out why I'm not able to query my database from my client. Even without RLS, and even with a service role key!!! Ugh. Anyone that could help me out with this?

What's the difference between Using and Check?

Hi all, I'm starting a new project and going through the docs to use supabase + prisma + React but despite following the steps outlined in the quickstart I'm getting an error where I can't reach the db. I thought it might be that there was an outage of some kind, but the status seems fine - https://status.supabase.com/ . Anyone else having this issue? command: npx prisma migrate dev error message: Environment variables loaded from prisma/.env Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "postgres", schema "public" at "db.xxxxxxxxxxxxxxxxxxx.supabase.co:5432" Error: P1001: Can't reach database server at "db.xxxxxxxxxxxxxxxxxxx.supabase.co:5432" Please make sure your database server is running at "db.xxxxxxxxxxxxxxxxxxx.supabase.co:5432". I've run through the obvious steps of checking my environment parameters and password and the connection string. The odd thing is that I can see that there are API calls being made to the db but am unable to access / read / write to it. Could it be a certificate issue? I've seen others mention that it might be that the postgres port has switched to 5433 but no luck there. I've also tried restarting the db in case there was an issue there, but it's unclear where my error is. docs: https://www.prisma.io/docs/getting-started/setup-prisma/start-from-scratch/relational-databases-typescript-postgres https://supabase.com/docs/guides/integrations/prisma

when is an official rust sdk coming?

I am trying to self host supabase with a decoupled database. but i am getting this error from gotrue docker: ERROR: no schema has been selected to create in (SQLSTATE 3F000) and this error from storage: Error: Migration failed. Reason: An error occurred running 'pathtoken-column'. Rolled back this migration. No further migrations were run. Reason: relation "storage.objects" does not exist

Hey 🙂 We develop 2 applications. One of them is B2C, will be open-sourced & free to use. The other is B2B, closed & has costs for usage. The apps share & interact on some of the data, so to enforce consistent and accurate relationships on both sides, we wish to use a single PostgreSQL DB. Can supabase help with generating 2 sets of APIs from the same DB (so private schema is not exposed in the open-sourced API)?

When using

auth.verifyOTP()

in NextJS and subsequently redirecting to the page that you should now have access to, it unfortunately redirects the user straight back to login. Here's the code that I'm using:

ts
  const verifyOTP = async () => {
    const { user, error } = await supabaseClient.auth.verifyOTP({
      email: getValues('email'),
      token: getValues('otp'),
      type: 'magiclink',
    });

    if (error) {
      console.log('Error while verifying OTP', error);
      return;
    }

    if (user) {
      console.log('Logged in');
      setTimeout(() => {
        console.log('redirecting to recipes');
        router.push('/recipes');
      }, 1500);
    }
  };