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

    LEGEND

    07/03/2022, 3:07 PM
    anyone know how to make push notification possible with supabase and react native
    n
    • 2
    • 1
  • k

    Kelaos

    07/03/2022, 3:27 PM
    Is there any "native" way currently to run Python ML models (training and predicting) with Supabase? Or do I need to run that somewhere else like serverless functions/docker and talk to Supabase with the SDK? One person suggested PostgresML, but I don't see it in the list of Extensions and it seems Postgres Extensions are restricted to the approved list. I was hoping to avoid anothing box on my architecture diagram EDIT: Also hope this is the right channel for this sort of thing πŸ™‚
    n
    s
    • 3
    • 4
  • o

    omar

    07/03/2022, 5:25 PM
    can i return a table from a procedure insert like this?
    Copy code
    declare test_table(payment_id integer, booking_id integer);
    begin
      INSERT INTO public.payment(user_id, session_id, amount, status)
        VALUES (userid, sessionid, price, event_status)
        RETURNING id into test_table;
    
      INSERT INTO public.booking(user_id, session_id)
        VALUES (userid, sessionid)
        RETURNING id into test_table;
        
        return test_table;
    end;
    n
    g
    • 3
    • 3
  • r

    React noob

    07/03/2022, 6:13 PM
    Let's say i wanna make a blog and i want connect myself on the client side to add a new post. It is possible to let's only 1 person connect itself. if yes how can i do it ? i don't want other user able to create a account. and i want to avoid to go to supabase table to add a new post
    n
    k
    • 3
    • 3
  • c

    Cory

    07/03/2022, 11:25 PM
    I am running SvelteKit - and had a question. Would it be possible to use another services Edge Functions instead of relying on Supabases? How difficult would that be to work out? I word much prefer to write my code directly in SK, instead of having to keep try of Supabase Edge function deploys
    n
    s
    • 3
    • 6
  • l

    LEGEND

    07/04/2022, 3:40 AM
    i need a help ..i am devloping supabase with react native .so im done authentication .the problem is confirmation email link is localhost link ...how to fix that ?
    n
    o
    • 3
    • 14
  • i

    InASunshineState

    07/04/2022, 4:38 AM
    How might I protect someone from seeing a password reset screen if the password wasn't relevant to them, like if they're a social auth or magic link user? I thought about checking the auth table and I can obtain their uuid but I think it's said the auth table isn't exposed (where the password is) I can't see if it's set or not.
    n
    j
    • 3
    • 6
  • l

    LEGEND

    07/04/2022, 8:17 AM
    anyone to know how to write supabase function for sending push notifications .. i have firebase tokens of every users. but i dont know how to write supabase function for that please help me ..
    n
    o
    +3
    • 6
    • 18
  • k

    Kayden

    07/04/2022, 12:50 PM
    Hi! How do you fetch the public url of image together with the data in tables ?
    n
    g
    • 3
    • 4
  • k

    kbsali

    07/04/2022, 2:03 PM
    Hello everyone ! πŸ‘‹ I am having an issue with resetpassword email : once the user opens the link from the email, he is ALWAYS redirected to
    https://OUR_URL/redir#error_code=404&error_description=User+not+found
    This is a sveltekit project. Here is the code snipper used to generate the password reset flow which used to work as expected :
    Copy code
    js
    export const post: RequestHandler = async ({ request, url }) => {
      const { email } = await request.json();
      const body = await supabase.auth.api.resetPasswordForEmail(email, { redirectTo: `${url.origin}/redir` });
      
      return { body };
    };
    Any help appreciated, this is very annoying for our members.
    n
    s
    o
    • 4
    • 18
  • k

    Kelaos

    07/04/2022, 4:17 PM
    Are the
    config.toml
    ever pushed to the Supabase cloud instance or are the values purely for local dev? In particular the site_url and external OAuth secrets being in there made my want to be extra careful
    n
    s
    • 3
    • 2
  • g

    Gitanes

    07/04/2022, 4:35 PM
    so I'm trying to add comments to my blog, I have the users table with an id and the email is also a primary key. I have the comments table with a column author that contains email. I'm trying to create a foreign key but I get an error both ways
    There is no unique constraint matching given keys for referenced table
    . How should I do it?
    n
    o
    s
    • 4
    • 25
  • n

    NARCISO

    07/04/2022, 4:38 PM
    Is there a way to get the Full URL of a Public Image in the Storage from a PSQL Function?
    n
    g
    • 3
    • 19
  • c

    Cory

    07/04/2022, 7:00 PM
    Does supabase auth support for "teams" authentication grouping?
    n
    o
    +2
    • 5
    • 16
  • w

    weilzuvielgewalt

    07/04/2022, 8:23 PM
    hey, newbie here, what's the easiest way to autoincrement the ID when trying to insert a row?
    Copy code
    const { data, error } = await supabase
      .from('studios')
      .insert([
        { id: letMeHandleTheIncrementForYouFunction(), other_column: 'otherValue' },
      ])
    n
    o
    • 3
    • 8
  • πŸ†• benjaminbialy (2022-07-05)
    n

    Needle

    07/05/2022, 12:25 AM
    Hello @benjaminbialy! 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.
  • c

    Cory

    07/05/2022, 4:08 AM
    What would the benefit of using authentication on backend with SSR? As opposed to doing things strictly from client side?
    n
    b
    o
    • 4
    • 9
  • InASunshineState (2022-07-05)
    n

    Needle

    07/05/2022, 5:50 AM
    Hello @InASunshineState! 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
  • e

    eqoram

    07/05/2022, 10:06 AM
    Is there an ETA for when Supabase is coming out of beta? We really love the product and would like it in our company but still hesitate because of the beta status. πŸ™‚
    n
    o
    • 3
    • 4
  • z

    Zedem2437

    07/05/2022, 12:06 PM
    Hi guys! am new to supabase. I plan to register users with name, email, address, gender and password unfortunately I don't care know how to pass all these parameters in the signup() method. can you help me?
    n
    o
    • 3
    • 6
  • e

    Edditoria

    07/05/2022, 12:44 PM
    Hi. Got a question about Edge Functions: I tried to use Eta package to return "string" (not html), but failed. I also tried:
    Copy code
    let sum = new Function('a', 'b', 'return a + b');
    console.log(sum(1, 2));
    I think Edge Functions won't allow this. Can I overcome this problem?
    n
    j
    • 3
    • 13
  • k

    Kayden

    07/05/2022, 2:09 PM
    Deleting a file does not work
    n
    g
    • 3
    • 15
  • n

    nischal012

    07/05/2022, 2:53 PM
    hey guys i want to implement auth and have two profile owner and enduser how do i implement , this would be decided based on the URL they signup through, how do i implement this. any help would be appreciated. basically i want to auto fill the ownerprofile or enduserprofile based on the route they signup from.
    n
    • 2
    • 1
  • c

    cy

    07/05/2022, 3:34 PM
    Hi πŸ‘‹ Very new to Supabase too ☺️ I need to clear records from a table on a regular basis. I want to "reset" my
    id
    column before inserting the new data batch. I created a SQL function:
    Copy code
    CREATE OR REPLACE FUNCTION truncate_xoxo()
    RETURNS void
    LANGUAGE sql
    AS $$
      TRUNCATE xoxo RESTART IDENTITY;
    $$;
    Unfortunately, when I call
    supabase.rpc("truncate_xoxo")
    I get an error: "must be owner of sequence xoxo_id_seq". I checked the
    pg_sequences
    table and the
    xoxo_id_seq
    is owned by
    supabse_admin
    .
    n
    g
    o
    • 4
    • 5
  • w

    wiesson

    07/05/2022, 3:39 PM
    Hello, I just learned the hard way that
    on delete cascade
    actually works and I needed to restore a backup from yesterday. Does anyone know if I filter the supabase logs so that I could retrieve some data from inserts and updates that happened today? πŸ€“
    n
    o
    • 3
    • 6
  • b

    Blade

    07/05/2022, 4:45 PM
    Hello! I'm having issues with
    supabase-community/auth-helpers
    for SvelteKit. It doesn't seem to ever resolve the callback fetch call and I don't know why. I followed the example (https://github.com/supabase-community/auth-helpers/tree/main/examples/sveltekit) but to no avail.
    n
    • 2
    • 3
  • a

    amitmirgal

    07/05/2022, 5:07 PM
    hello team.. need a quick help I am trying to call the table via curl command
    Copy code
    curl '<SUPABASE_URL>' \
    -H "apikey: SUPABASE_KEY" \
    -H "Authorization: Bearer SUPABASE_KEY"
    I am getting the below data in response {"message":"permission denied for schema public","code":"42501","details":null,"hint":null} Do I need to turn on any config?
    n
    o
    • 3
    • 21
  • πŸ†• big2tiny (2022-07-05)
    n

    Needle

    07/05/2022, 7:31 PM
    Hello @big2tiny! 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.
    b
    • 2
    • 1
  • a

    abaum

    07/05/2022, 7:36 PM
    is there any documentation around the
    edge_logs
    and
    postgres_logs
    tables in the Logs Explorer? we've been trying to reconcile some requests that are failing, and so far it seems that the response code lives in the edge_logs, and the authorization/header data lives in the postgres_logs, and I haven't found a clean way to connect them other than by timestamp.
    n
    • 2
    • 1
  • l

    liljamesjohn

    07/05/2022, 7:51 PM
    I have a profiles table that is being shown publicly when viewing a users profile. But using RLS, I have a user_id column with the owners user_id. Anyone can see this column as it gets sent with the request to view a users profile. If I have RLS that only allows Insert/ Update and Delete if the auth.uid === user_id; Can someone who is not the user perform these tasks?
    n
    g
    • 3
    • 5
1...295296297...316Latest