Hey there guys, I want every auth user to be able to delete images, sadly that doesn't work. My knowledge about supabase and sql is limited. I would really appreciate help!💚

have created table called chat_message in supabase and written code to get read message while inserting the message in it.the channel gets subscribed but payload not showing while console logging .My code var supabase = supabase.createClient(SUPABASE_URL, SUPABASE_KEY) async function login_supabase() { var sp_email=$('.spa_email').val(); console.log(sp_email); var spa_ps=$('.spa_ps').val(); console.log(spa_ps); if (sp_email) { const { data: { user }, error } = await supabase.auth.signInWithPassword({ email:sp_email, password:spa_ps, }) } } async function get_user() { // const user1 = supabase.auth.user() const datas= await supabase.auth.getSession(); console.log(datas); if (datas) { window.userToken=datas.data.session.user.id; console.log(datas.data.session.user.id); } } async function read_message() { console.log(loged_user_common); const userListener = supabase.channel('chat_messages:receiver_id=eq.'+loged_user_common+'') .on( 'postgres_changes', { event: '*', schema: 'public', table: 'chat_messages',filter:'receiver_id=eq.'+loged_user_common+'' }, (payload) => { // console.log('Change received!', payload) console.log(payload); }) .subscribe() } login_supabase().then(function() { get_user(); read_message(); })

Hello, does anyone have experience with this? If i want to upload openstreetmaps data from germany for example, is this possible? Or will i run into major issues?

It looks like the Twitter Login doesn't seem to work anymore even if I added the API Key and Secrets in the provider and added the callback URI on Twitter Dev Tools.

Has anyone managed to get Inngest endpoints to run in Supabase edge functions? They have examples for running it in various frameworks, including Deno Fresh so it should be able to run ok on Supabase edge functions as they also run in Deno. I just don't know the magic incantation to convert their "handler" function to a server loop that uses it. I'm interested to use it to run step functions to process larger backend data jobs.

Dear Supabase Support Team and community. I have been encountering an issue with my stored procedure, delete_user, when trying to delete a user and their related records in my application. I am using Supabase for my backend and Next.js for my frontend. Here is the stored procedure I created: CREATE OR REPLACE FUNCTION delete_user(p_user_id uuid) RETURNS void AS $$ BEGIN DELETE FROM appointments WHERE appointments.user_id = p_user_id; DELETE FROM tasks WHERE tasks.user_id = p_user_id; DELETE FROM documents WHERE documents.user_id = p_user_id; DELETE FROM auth.users WHERE id = p_user_id; END; $$ LANGUAGE plpgsql; When I call this stored procedure from my Next.js API route, I receive the following error message: Error while calling the delete_user stored procedure: { code: '42501', details: null, hint: null, message: 'permission denied for table users' } I have tried creating and altering policies to grant the necessary permissions but the issue persists. Additionally, I encountered a foreign key constraint violation error when attempting to delete a user, which I have not been able to resolve: Error while calling the delete_user stored procedure: { code: '23503', details: 'Key (id)=(543081e0-ed71-4553-994f-64b850c736a8) is still referenced from table "objects".', hint: null, message: 'update or delete on table "users" violates foreign key constraint "objects_owner_fkey" on table "objects"' } I will very much appreciate your guidance

I have a service depending on the web hook from Postgres on Supabase cloud. I wanna configure a firewall that only allow the incomming request from supabase ip . Thanks

I am having trouble uploading and fetching files by Id I am using nextjs 13.3.1 below is the link to how i implemented it https://stackoverflow.com/questions/76147557/fetching-data-in-nextjs-13-3-1-using-supabase

Hi, would like to an

or

operation for

ilike

supabaseClient.from('analyzers').select('id,name,imgUrl,manufacturers(name),departments(name,labs(name)),tests(count)').or('name.ilike.%org%,manufacturers.name.ilike.%org%')

hi guys, i'm pretty stuck with a small issue with the dashboard.. when I delete an user, I want to delete all it's own files in a bucket but I can't figure out how

On my NextJS project I'm using the

useUser

function and it is causing my component to infinitely re-render. I've attached an image with an example component. I verified the loop by adding a

console.log("hello")

and when I comment out the

useUser()

call it does not loop infinitely but when I remove the comment it does cause an infinite loop. Is there something that I'm missing that is causing this infinite loop? I've never had this issue in other projects that I've used Supabase for.

I am trying to run Supabase locally with the CLI. I have the latest version of the CLI. I am not sure what to do. I have searched the web for this error and I can't find any documentation around it. Thank you in advance for any help 🙂

Originally I didn't use db, but I'm using supabase for the first time. studied for a week 1. If you look at the usage, if you do not create a schema, the default value is set, so select 'public' as the schema. There are other schemas, and it seems that you can put an arbitrary schema into the database with a command, but I don't think this is a recommended usage. Is it right? 2. I want to change the role given to a user. try to give more ratings The interface doesn't seem to be provided what to do Which roles are already designed for use? 2-1. I tested it manually When an anonymous connection matches anon, it is processed as anon. When I logged in, it seemed to treat it as authenticated if the address was the same as the preset address. I figured it out manually. Is there a document that organizes this? 3. I want to speed up the logout cycle Do you have logout logic? If not, should I just clear local storage and cookies?

sql
CREATE OR REPLACE FUNCTION check_duplicate_product() RETURNS TRIGGER AS $$
BEGIN
  IF EXISTS (
    SELECT 1 FROM products WHERE name = NEW.name AND size = NEW.size AND (id IS DISTINCT FROM NEW.id)
  ) THEN
    RAISE EXCEPTION 'Product with same name and size already exists';
  ELSE
    RETURN NEW;
  END IF;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER check_duplicate_product_trigger
BEFORE INSERT OR UPDATE ON public.products
FOR EACH ROW
EXECUTE FUNCTION check_duplicate_product();

Basically what I want is when a new Product row is inserted I want to verify that the name and size arent the same as any other row So if my existing table has a product with name: 'test' and size: 'small' The function should trigger when another product is insert where the name is 'test' and the size is 'small' if any of these 2 do not match, then there shouldn't be any exception. When I tested my above sql it does create the function and trigger but does not raise an exception when I tried to raise one by giving a duplicate record (except id)

Hey fam. I think I have found a bug. On my Develop & Production (Not on my Local Development Environment) db environment the following is occurring. There are a few duplicate columns on my profile table which can only be seen in the Database view of the dashboard. However, there are no duplicate columns in the Table Editor. This is causing the issue of duplicate keys & value for when I run

npx supabase gen types typescript --project-id \"SOME_ID\" > src/types/supabase-types.ts

Is there a way I can resolve this?

Hi, I'm at a wits end here. I've implemented auth a while ago, and randomly customers would copmlain about OTP not working for them. For me it works every time I try. Recently on a customer call someone was trying to register and it failed for them. and today someone reach out, claiming they tried 3 times from different browsers etc. I've reached out to support, they claimed this could be because I've added the URL to the email, some clients prefetch the link. I've since then created a JS redirect. So it can't be that the OTP is invalidated. I would love any ideas of how I could even test this please. Versions of packages

├─┬ @nuxtjs/supabase@0.3.5
│ ├─┬ @supabase/supabase-js@2.13.1
│ │ ├── @supabase/functions-js@2.1.1
│ │ ├── @supabase/gotrue-js@2.24.0
│ │ ├── @supabase/postgrest-js@1.6.0
│ │ ├── @supabase/realtime-js@2.7.2
│ │ ├── @supabase/storage-js@2.5.1

Implementation: Code that sends the OTP (and magic link)

const { error } = await supabase.auth.signInWithOtp(
    { email: email },
    {
      redirectTo: `${window.location.origin}${redirect || '/dashboard'}`
    })

Code that verifies (and fails) when user enters it

const { data, error } = await supabase.auth.verifyOtp({ email: otpModalOptions.value.email, token: code.value, type: 'magiclink'})
  if (error){
    code.value = ''
    errorOtp.value = true

Is there a way to filter using an array of strings with the

.ilike

function from js? I know that i can accomplish it with sql if I do something like the following

select * from some_table where column ilike all(array['val_1', 'val_2'])

what I want to do is something like the following

supabase.from('some_table').select().ilike('column', '%['val_1', 'val_2']%')

Is this possible or would I have to us

.or()

and do lots of string concatenations for each element in an array to look like

column.ilike.${array_entry_value}

What I am trying to achieve is to do a case insensitive search for multiple text values in a table. If I use a filter like

.in()

it will do exact matches, but that is not ideal so

ilike

is the best option

The supabase docs (https://supabase.com/docs/guides/auth/auth-helpers/nextjs-server-components) gives an example for middleware but doesn't have any redirect logic in it. Does someone have a good example of middleware for the Next App dir that contains standard (if user authenticated continue, else bounce to home page)? I see the Next Pages example has middleware with this, but I'm not sure if that's best practice for App dir. I'm assuming there will be a very standardized best practice for not letting unauthorized users wonder around your app.

I have been reading Supabase-py's docs for a while and I noticed that it doesn't seem to have async support. I am wondering if this is true and if so, why? Additionally, what are some recommended approaches for making async calls to Supabase in Python?

Not sure whats going on here, await supabase .from('company') .update({'schedule': schedule}); ive made sure that there is a schedule column in the company table but i am getting this error, PostgrestException(message: , code: 404, details: Not Found, hint: null). Any ideas?

I saw the Management API isn't available at all on the self hosted version. Is it possible to work around this issue, and use a GitHub action to automatically deploy migrations aswell as Edge Functions?

I'm trying to accept an invite but it redirects me to a localhost with this path:

http://localhost:3000/#access_token=[token]&expires_in=3600&refresh_token=[token]&token_type=bearer&type=invite

You can see the user created in authentication from the screenshot, and i guess signin method should not create users that does not exists

A quick summary of my current setup: When a user signs up or logs into the app I save the access token and refresh token in the iOS native keychain, then to not require the user to login again after every relaunch, every time the user launches the app I call the setSession() function, inputting the access and refresh tokens from the keychain in the function call, then using the returned session to update the tokens in the keychain. When I use the sign out function I assumed it would invalidate the existing tokens and require a new sign in to get new tokens but it does not seem to do this, as the setSession() still validates the session with the old tokens after calling signOut(). So what exactly is the signOut() function supposed to do? I am not sure if I am misunderstanding the use case of signOut(), setSession() or both here. Any clarifications would be greatly appreciated.

Trying to access user session from a nextjs api endpoint. Not sure how to actually make it work. Would really appreciate a quick bit of insight.

// Define the API route handler
export default async (req, res) => {
  // Check if the request method is POST
  if (req.method === 'POST') {
    // Extract the message from the request body
    const { message, chatHistory } = req.body;
    const supabaseServerClient = createServerSupabaseClient<Database>({
      req,
      res,
    });
    const {
      data: { session },
    } = await supabaseServerClient.auth.getSession();

    const {
      data: { user },
    } = await supabaseServerClient.auth.getUser();

    console.log('session', session, 'user', user);

This is how I'm invoking the nextjs API:

import { supabase } from 'lib/Store';

export const apiCall = async (endpoint, method, payload) => {
  const session = await supabase.auth.getSession();
  const options = {
    method: method.toUpperCase(),
    headers: {
      'Content-Type': 'application/json',
      Authorization: `Bearer ${session.data.session.access_token}`,
    },
    body: '',
  };
  console.log

  if (payload) {
    options.body = JSON.stringify(payload);
  }

  const response = await fetch(endpoint, options);
  const data = await response.json();
  return data;
};

export default apiCall;

Working based off of the slack clone starter.

This is the bit of code, basically I'm trying to query the user's profile if it exists & if it doesn't that redirect them to the

/register-form

, unless I'm already on the

/register-form

page: This works, however it still logs

PGRST116

errors to the console:

javascript
try {
  const { data: profile, error } = await supabase
    .from('profiles')
    .select('*')
    .eq('id', userResponse.data.user.id)
    .single();
  if (error) {
    throw error;
  }
  return profile;
} catch (e) {
  if (e.code && e.code == 'PGRST116') {
    if (pathname !== '/register-form') {
      router.push('/register-form');
    }
    return null;
  }
  throw e;
}

What am I doing wrong here?

Hi, I have an edge function that is being invoked as a webhook from a third party service (GCP). In the payload of the request, the email address of a supabase user is provided. I now would like to run database requests assuming the user as identified via the email address, so that RLS gets respected, e.g. Webhook payload:

{
  "email": "iamasupabase@user.com"
}

and then do something like

supabaseServiceRole.from("user_emails").select("user_id").eq("email":email)

supabaseServiceRole.assumeRole(user_id);

// continue requests in the same way as if coming from the logged in client

It seems like most solutions I found rely on a JWT being passed, but I cannot do that.

My selfhosted supabase db works alright but when I go to the supabase website I see for a split second the login and the get logged in but I want it so I can host my supabase url on my domain and dont want anyone to access it

Logging in isn't working When checking the accounts after I login, it shows that I last signed in at the correct time. So I know that the signing in is working fine. But I cannot get sessions I know I needed to use

getSession()

instead of

getUser()

, but that was returning null too. So I used

setSession()

The session I use to set it has valid information in, but the next line i get the session to check its been set, and its null again. Whats going wrong?