Greetings, we are considering migrating a customer's app from Firebase to Supabase. But we couldn't find a tool to migrate functions. Is there any documentation or any tool about this?

Hi! Interested in using Supabase for a (hopefully-one-day-large) startup. Are there examples of larger companies using it in prod? Thank you.

I'm creating an app and currently planning and building the SQL database (tables/views/functions). I want to know the best practise to build my database. What I was thinking, is to have all my tables as private and only expose Views and functions publicly. Do you think it will work and better for security purposes?

Hi, in this case i am doing all my filtrations in js side ( inside payload fn ) , i know that filter is not accepting multiple keys. Is it possible to do multiple filtering with custom sql and how ? i will be very thankful for the links.

room = await supabase
              .channel('messages')
              .on(
                'postgres_changes',
                {
                  event: 'INSERT',
                  schema: 'public',
                  table: 'messages',
                  filter: user_id=eq.${user.id}
                },
                (payload) => {
                  console.log('sender');
                }
              )
              .on(
                'postgres_changes',
                {
                  event: 'INSERT',
                  schema: 'public',
                  table: 'messages',
                  filter: user_receiver_id=eq.${user.id}
                },
                (payload) => {
                  console.log('receiver');
                }
              )
              .subscribe();

I have been setting up Supabase for my new projects, and it seems that there is some error fetching data in these new projects as Type error occurs. What can be done to solve this? Please guide. Thanks

Is there any event/hook i can listen to when the user first signs in? I'm looking for some event where i can save the provider refresh and access tokens I've already tried

ts
supabaseClient.auth.onAuthStateChange((event, session) => {
  // either event.SIGNED_IN or event.INITIAL_SESSION
})

but they fired too often I'm only looking to save the tokens to an HTTP only cookie on that event, from there on, i'll handle the refreshing part. (this is for a spotify app)

Just looking to sort some data by the id of foreign data. Any idea how to do it?? I've tried: _supabase .from('exam<>student') .select('exam(*), score, studied, cheated, student(year)') .eq('student', sid) .order('exam(id)', { ascending: true })

Hello, for better maintainability I was trying to nest my functions base on business logic but it wont let me. currently the only allowed folder structure is so -

|- supabase
|   |- functions
|-  |-  |-_shared (shared .ts files)
|   |-  |- <function-name>
    |   |-  |- index.ts
|-  |-  |-import_map.json
|-  .env.local
|-  .env
|-  .gitignore
|-  config.toml
|-  seed.sql

is it possible to created business logic base nested folders inside of /supabase/functions ? tia

When I use the JavaScript library to embed another table the embedded document is always type as

OtherType | OtherType[]

Is there a way to specify that the embedded document can only be a single row?

I'm just trying to log into the app on app.supabase.com and it won't load my projects. If I use the URL to get direct to a project I get a permissions error page. But I am the owner of the project so I'm not sure what else to do, been experiencing this since last night (almost 12 hours now) I've tried logging out and back in ~5 times now

Hi, has anyone implemented unit tests within Edge Functions, could not find examples in the Supabase Documentation and I am getting some issues executing the function scripts due to incorrect env variables etc. And what testing libraries worked best, using the standard deno testing functions or an alternative? Also looking for the best way to mock the API / Database calls in Deno testing.

Is there any way to obtain Supabase access tokens that are scoped to an organization? I have several clients and access tokens are used in CI (Github Actions). It's pretty easy to extract Github Action secrets. Ideally I'd be able to specify fine grained permissions for my access tokens, but I'd settle for being able to limit them to a Supabase organization. Is the only solution to create a new Supabase account per client (even if only used for access token generation)?

I used these functions https://github.com/burggraf/supabase-mailer/blob/main/Mail_Providers/Sendgrid.md Struggling to use my sql function in my trigger. I can use it directly though. it works, any idea? code: https://gist.github.com/louis030195/4d8ede553b6068f978bdd72ede6e5151

Hi, does anyone if it is possible to inspect Local Edge function logs with ChromeTools, similar as how you would add --inspect to Deno? Or is there another workaround possible? https://deno.com/manual@v1.33.0/basics/debugging_your_code

Hello! One of my four Supabase projects (one I have recently created) is missing the "version" column in my storage.objects table. As a consequence, all requests to storage fail with a 500 error. Has anybody else experienced that error?

I'm trying to generate magiclink via supabase's rest api, which I believe uses gotrue under the hood. As per documentation I found here: https://github.com/supabase/gotrue#post-admingenerate_link I am calling

/admin/generate_link

endpoint via fetch request below:

const response = await fetch(`${this.#apiUrl}/admin/generate_link`, {
      headers: {
        apikey: this.#apiKey,
        Authorization: `Bearer ${this.#serviceRoleKey}`,
         'Content-Type': 'application/json'
      },
      method: 'POST',
      body: JSON.stringify({
        type: 'magiclink',
        redirect_to: 'https://mysite.app',
        email: 'myemail@gmail.com'
      })
    })

But I am getting an error response with following data. Really not sure what is wrong, all those secret

this.

values are correct when logged.

{
  "message": "no Route matched with those values"
}

I am on the free plan. Have been doing some data analysis using python and sql inside Jupyter notebook by connecting to my Supabase postgres database. As of last night I started getting the following errors when I run queries. Is my issue that im on the free plan or is there another reason why this started to occur?

Hello there, I'm building a project with some friends to learn the basics of Svelte/Sveltekit, Prisma and Supabase. We want to have some auth logic, but nothing convoluted. I have been trying to set up the project, but I'm encountering several problems with the auth-helper-sveltekit, and I am now wondering if it's really necessary.

I have a users table and a people table. A person belongs belongs to a user. The foreign key in people tables is named "auth_id" I need to search a user filtering by the name, last_name (presents in people table) or by email (present in users table). I thought two solutions but neither works: First option: using an "Or()" function: let { data, error, count } = await supabase .from("users") .select(

*,
          people:auth_id!inner(*)

, { count: "exact", } ) .or("name.ilike.%ar%,last_name.ilike.%ur%,users.email.ilike.%aur%", { foreignTable: "people", }); this way, supabase responses: failed to parse logic tree ((name.ilike.%ar%,last_name.ilike.%ur%,users.email.ilike.%aur%)). Second option: adding other "or()" function under existent or() function, like this: .or("email.ilike.%aur%", { foreignTable: "people.system_users", }); but using the second "or()", supabase does not response with any item [], even though the firs or() could match.

Hey everyone! I'm currently working on implementing phone authentication in my app, and facing a challenge in determining whether a user is new or already exists in the auth.users table based on their phone number. My current approach is to run a RPC in the auth.users table, searching for the user's phone number. Depending on the result, I would either call the

signUp

or

signInWithOtp

method. Once I have identified the user's status (new or existing), I'd like to show different onboarding screens tailored to their experience. In short, is running an RPC in the auth.users table for the phone number an appropriate way to check if the user is new or existing? Appreciate any guidance or alternative suggestions on how to handle this situation.

When I edit the data in my table rows, it reflects the change on the Supabase dashboard. However, when fetching in my app, it returns the old data from before. I've restarted my server, nothing seems to work. Help appreciated, thanks!

I have a trigger that runs before updates on the profiles table to ensure some columns can not be changed:

CREATE OR REPLACE FUNCTION prevent_profile_updates()
RETURNS TRIGGER AS $$
BEGIN
  IF NEW.profile_id != OLD.profile_id OR
     NEW.joined != OLD.joined OR
     NEW.follower_count != OLD.follower_count OR
     NEW.following_count != OLD.following_count OR
     NEW.post_count != OLD.post_count THEN
    RAISE EXCEPTION 'You are not allowed to update this column.';
  END IF;

  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER prevent_profile_updates_trigger
BEFORE UPDATE ON profiles
FOR EACH ROW
EXECUTE FUNCTION prevent_profile_updates();

I also have this trigger to update those columns +1 / - 1 whenever there are inserts or deletes. I created it as a SECURITY DEFINER but it seems even this can not bypass the previous trigger. What are my options?

CREATE OR REPLACE FUNCTION update_profile_counts()
RETURNS TRIGGER AS $$
BEGIN
  IF TG_OP = 'INSERT' THEN
    UPDATE profiles SET follower_count = follower_count + 1 WHERE profile_id = NEW.user_id;
    UPDATE profiles SET following_count = following_count + 1 WHERE profile_id = NEW.followee_id;
  ELSIF TG_OP = 'DELETE' THEN
    UPDATE profiles SET follower_count = follower_count - 1 WHERE profile_id = OLD.user_id;
    UPDATE profiles SET following_count = following_count - 1 WHERE profile_id = OLD.followee_id;
  END IF;

  RETURN NULL;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;

CREATE TRIGGER update_profile_counts_trigger
  AFTER INSERT OR DELETE ON relationships
  FOR EACH ROW
  EXECUTE FUNCTION update_profile_counts();

Hi, today we've started receiving a lot of P1002 errors from Supabase when migrating + building a NextJS 12 app with Prisma deployed thru Vercel, and just resolved a

pg_advisory_lock

that we believe was caused by a broken migration routine... maybe? Might be coming from pgbounce or something, but we have only just run into this issue today, long after setting up pgbouncer... Posting here in case there is something on the Supabase side or Postgres we should be aware of

Currently it's capped at 1 filter, but I need to add more. Is there any way that we can bypass this?

Hi there. Supabase customer here. I understand edge functions don't work with custom domains, given the namespaced nature of the subdomains that functions live on, it's clear why, but I like having a custom domain for my oauth logins, and all other calls to supabase. That being said, I've noticed that setting a custom domain for initializing the supabase client (in a react native app) has the side effect of also trying to call edge functions against that domain, which clearly doesn't work. In order to use the client for edge function I've extended

SupabaseClient

class in typescript and overridden the

functionsUrl

property to point to the correct functions domain. Not the end of the world, but it's a bit verbose in typescript and was wondering: 1. Is there a better way to use a custom domain with a Supabase client instance along with functions? 2. Am I risking something silly extending the class like this? Thanks!

I just upgraded my cli (1.52.2). I am trying to deploy some functions and i am not able to paste the token at the command prompt. I am stuck! 😦

Have attached Deno docker error logs.

Hi! I'm planning to use a table in supabase to store multiple embeddings that may vary of different embedding providers, whether thats cohere, openAI, something from huggingface etc. Is it possible to have in a table, the vector allowed to have any dimension size? Instead of specifying, or is it something that we have to specify? (And then have a table for each provider of embeddings)

Hey all, I have to be missing something but every attempt I make at debugging, everything seems fine to me. Additionally, I could of swore I've been using this same rule for weeks but I guess not. Here is my RLS on Delete

sql
(EXISTS ( SELECT 1
   FROM decks
  WHERE ((decks.id = notebook_users.notebook_id) AND (decks.user_id = auth.uid()))))

Here is my service call

notebook_users?notebook_id=eq.9c8f537d-2347-40ea-ad92-5866f04f0599&user_id=eq.090dca08-c31e-4fbb-8513-f96690c5263a

This is my current users id

7eefb80e-b6b1-4681-821c-b6fc713b3153

Thus when I manually write the RLS rule into a select statement I get

sql
select * from notebook_users where notebook_id = '9c8f537d-2347-40ea-ad92-5866f04f0599' and user_id = '090dca08-c31e-4fbb-8513-f96690c5263a'
and exists(select 1 from decks where id = '9c8f537d-2347-40ea-ad92-5866f04f0599' and user_id = '7eefb80e-b6b1-4681-821c-b6fc713b3153')

Which returns the row I'm trying to delete. -- However, I get a 204 success response, and the row does not get deleted. - Also, I confirmed this is RLS, because if I disable RLS, I can remove the row. Any ideas? Or suggestions to further debug this?

How do I stop making API calls when a user refocuses on the tab of the site. I've like memoized everything but im 90% sure the context is the main problem. I'm using the code in the docs for NextJS App directory

Supabase Provider

thing.