https://supabase.com/ logo
Join Discord
Powered by
# help
  • g

    giorgio

    07/01/2022, 12:22 PM
    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?
    n
    s
    • 3
    • 2
  • m

    MatB57

    07/01/2022, 12:52 PM
    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 😉
    n
    s
    • 3
    • 3
  • y

    Yeehawlerz101

    07/01/2022, 2:20 PM
    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.
    n
    s
    • 3
    • 5
  • m

    Murkrage

    07/01/2022, 2:25 PM
    Where can I change the email template for magic links on the local environment?
    n
    r
    o
    • 4
    • 7
  • k

    KennyMurders

    07/01/2022, 2:53 PM
    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
    n
    • 2
    • 3
  • n

    NicoNico

    07/01/2022, 3:05 PM
    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?
    n
    • 2
    • 2
  • c

    ccc159

    07/01/2022, 6:52 PM
    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
    n
    j
    • 3
    • 2
  • u

    user

    07/01/2022, 10:54 PM
    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.
    n
    j
    • 2
    • 2
  • m

    Mike_

    07/01/2022, 11:49 PM
    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:
    Copy code
    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?
    n
    • 2
    • 3
  • g

    gerry

    07/02/2022, 2:11 AM
    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
    n
    j
    • 3
    • 5
  • j

    jar

    07/02/2022, 2:38 AM
    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.
    Copy code
    _res := jsonb_set(_res, '{myval}', to_jsonb(7.8::float));
    like why cant i just do
    Copy code
    _res->'myval' := 7.8::float;
    or something
    n
    j
    • 3
    • 3
  • l

    LEGEND

    07/02/2022, 12:11 PM
    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
    n
    g
    • 3
    • 14
  • Relisora (2022-07-02)
    n

    Needle

    07/02/2022, 12:37 PM
    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.
    • 1
    • 1
  • j

    João Vitor

    07/02/2022, 2:54 PM
    server auth with supabase on Next.js?
    n
    g
    • 3
    • 24
  • k

    Kayden

    07/02/2022, 3:45 PM
    hi guys, which storage policy should I use? I want to upload and display the image to public. But only authenticated user can upload.
    n
    g
    • 3
    • 38
  • s

    samjmck

    07/02/2022, 4:27 PM
    trying to login with Twitter, this is the error I keep receiving:
    n
    o
    • 3
    • 9
  • t

    Teiem

    07/02/2022, 5:18 PM
    supabase-cli
    supabase db remote commit
    errors with
    Error: unexpected end of JSON input
    n
    • 2
    • 4
  • Mike_ (2022-07-02)
    n

    Needle

    07/02/2022, 8:08 PM
    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.
    • 1
    • 1
  • m

    Mike_

    07/02/2022, 8:17 PM
    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?
    n
    o
    • 3
    • 2
  • s

    samjmck

    07/02/2022, 10:05 PM
    is column level security a thing? e.g. I want my users to be able to edit their username but not their age?
    n
    g
    • 3
    • 4
  • s

    Salvage_Dev

    07/02/2022, 10:44 PM
    Does the database on supabase support creating multiple databases with CREATE DATABASE?
    n
    s
    • 3
    • 4
  • a

    aulia

    07/02/2022, 10:50 PM
    is there a way for authentication user simple username and password? Thanks!
    n
    s
    • 3
    • 5
  • a

    AlanK

    07/03/2022, 1:48 AM
    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?
    Copy code
    ..,/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 }
                };
            }
        );
    n
    g
    • 3
    • 5
  • s

    sebx

    07/03/2022, 6:39 AM
    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?
    n
    g
    • 3
    • 8
  • v

    VuNguyen

    07/03/2022, 7:35 AM
    What's the difference between Using and Check?
    n
    s
    • 3
    • 4
  • c

    cassideous

    07/03/2022, 9:39 AM
    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
    n
    • 2
    • 1
  • s

    Salvage_Dev

    07/03/2022, 10:40 AM
    when is an official rust sdk coming?
    n
    s
    • 3
    • 11
  • g

    glomyst

    07/03/2022, 10:53 AM
    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
    n
    s
    • 3
    • 6
  • e

    ez-klik

    07/03/2022, 2:41 PM
    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)?
    n
    o
    • 3
    • 2
  • m

    Murkrage

    07/03/2022, 2:59 PM
    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:
    Copy code
    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);
        }
      };
    n
    • 2
    • 3
1...294295296...316Latest