anyone know how to make push notification possible with supabase and react native

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 🙂

can i return a table from a procedure insert like this?

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;

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

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

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 ?

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.

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 ..

Hi! How do you fetch the public url of image together with the data in tables ?

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 :

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.

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

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?

Is there a way to get the Full URL of a Public Image in the Storage from a PSQL Function?

Does supabase auth support for "teams" authentication grouping?

hey, newbie here, what's the easiest way to autoincrement the ID when trying to insert a row?

const { data, error } = await supabase
  .from('studios')
  .insert([
    { id: letMeHandleTheIncrementForYouFunction(), other_column: 'otherValue' },
  ])

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.

What would the benefit of using authentication on backend with SSR? As opposed to doing things strictly from client side?

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.

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. 🙂

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?

Hi. Got a question about Edge Functions: I tried to use Eta package to return "string" (not html), but failed. I also tried:

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?

Deleting a file does not work

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.

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:

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

.

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? 🤓

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.

hello team.. need a quick help I am trying to call the table via curl command

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?

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.

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.

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?