Hi everyone, I'm wondering if there's a way to run snippets from one project to another. Basically I have ProjectA in prod, and have other data that I have uploaded in ProjectB that are on a different schema (and split in a differnt way of organizing tables) so will need some transformation to populate this data into ProjectA. So is there a way to work cross-project in the SQL Editor in my dashboard? As in duplicate a table, or fill some rows? Or would the way to go be to either: - replicate my ProjectB tables into ProjectA and run the SQL queries there - or build a simple Node App that would fetch data from ProjectB, do the transformation in the app and then write into ProjectA ? thanks !

I use the @nuxtjs/supabase module. I have a table "challenges" and two join tables "profile_challenge" (to assign the challenge to a profile) and "challenge_category" (to assign categories to the challenge). Both of these join tables are identical and store only the respective ID's of both reference tables. The respective tables "categories" and "profiles" are very simplistic and only contain an id and some text columns. I make a request like this:

.from('challenges').select('*, profiles(id, username), categories(title, image_url)')

While I get the correct category data, the profile data is somehow wrong. For all 5 challenges i** get the same profile data**, even when 2 challenges are assigned (through the join table) to a different profile. How could it be that the categories work fine, and an identical table & request does not? Thanks for your help 🙂 Simon

Hi, I made a mistake one of my functions (sql), I wonder is it possible to bring that back ?

I am building a mobile app with React Native and using Supabase as my backend. The problem I am facing is the expiration of the JWT token, since the longest is a week its causing users to have to relogin to refresh the access token. Is there anything I can do to improve this?

Working on setting up hCaptcha, but I keep getting "request disallowed". When I look at the hCaptcha site it shows that the captchas are being delivered and solved, but they are **not **being verified. I can see that the captcha token is being generated and sent with the signUp info to supabase.

const { error, user } = await supabase.auth.signUp(
      {
        email: data.email,
        password: data.password,
      },
      { data: { username: data.username, team: data.team }, 
        captchaToken: captchaToken  }
    );

everything else is set up exactly as shown in the guide here: https://supabase.com/docs/guides/auth/auth-captcha Sign ups work just fine with out captcha. Any suggestions? And yes..I have checked the secret key, several times=)

Is it also possible to do a backup on the freetier? This would be the inly feature I need from the Pro-Tier but 25$ is quite a big jump in my eyes.

Hello, I'm seeing odd behavior when using the Supabase js client from inside an api page in NextJS. When calling the NextJS api route, I get stale query data. Does anybody know if there is caching happening on the NextJS side or on the Supabase REST API side, which would cause stale data? Thank you very much!

Hello everyone! I'm currently trying to subscribe to events and broadcast them on the same page ! but seems like not working , so is this a limitation on supabase ? or should I handle that differently thanks in advance!

Keep getting API key not found when trying to insert into supabase. I am certian my token is correct.

Hello, for context I'm currently using the svelte-kit auth helper 0.7.1 I know that Supabase suggests creating a public.profiles table to manage additional user data. However, one thing I'm confused on. The

LayoutServerLoad

only pulls back the

auth.user

as far as I understand. -- I want to grab additional properties like

theme

so that I can have that user's theme during SSR.

LayoutServerLoad

blocks rendering the corresponding svelte layout/page until it completes. Wouldn't hitting the supabase API to grab profiles add to this time to finish? i.e. I'm looking for a way to grab custom fields/columns from the user without having to make a second trip to the server. More context, this is essentially what I'm trying to achieve:

ts
export const load: LayoutServerLoad = async ({ locals }) => {
        // locals.session.user <-- Already has user's data.
    return {
        session: locals.session,
        theme: 'night' // <-- Get user's theme from locals.session.user
    };
};

Hello, I have a situation where I need to fetch recipes 1 by 1. Correct me if I'm wrong but so far it seems that If was to fetch unique recipes like this:

supabase
    .from('recipes')
    .select(
      `*`,
      { count: 'exact' }
    )
    .limit(1)
    .not('id', 'in', `(${fetchedRecipeIds})`);

10 queries would simply return results in this id sequence - 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 correct? As you can see from the picture first 4 results are recipes with tuna, which would result in bad UX for users who want to fetch recipes 1 by 1. How can I make it random or at least group them so that I know that the next recipe user fetches won't be from the same "group". Ideally result sequence would looks something like this: Tuna..., chicken..., pizza..., tuna..., chicken and so forth...

Hi! What's the best way to update all values in a db from a user? Imagine a DB with a person and the amount of fruits they hold. John holds 100 apples and 10 bananas. I want to update all of John's records to be 1/2 such that the records say John holds 50 apples and 5 bananas. Is this easily possible without looping requests? ex:

const { data, error, status } = await supabase
    .from("user_apples")
    .update({ // multiply by 0.5?? // })
    .match({ name: "john" });

is there any way to count rows by group? I want something returning like this: { “Group_1”: 38, “Group_2”: 19, “Group_3”: 20 }

When I sever another one, the other one stops automatically. I wanted to test multiple functions but it seems tedious to jump back and forth. Any help is appreciated. ♥️

Trying to insert the following function and getting syntax errors

sql

create or replace function "CreateScrapedUpload" (
  _filename text,
  _record_count int,
) returns table (
  id uuid,
  filename text,
  storage_key text
  record_count int,
  notes text,
  checkbox boolean
) as $$
  insert into rr_upload (
    filename,
    storage_key,
    record_count,
    notes,
    checkbox,
  )
  select
    filename,
    extensions.uuid_generate_v4()
    _record_count
    _filename,
    "",
    false
  from public.rr_upload rr
  returning id, filename, storage_key;
$$ language sql volatile;

Error:

Failed to create function: failed to create pg.functions: syntax error at or near ")"

Hey all. I'm having some trouble deploying a function onto Vercel. It seems like the issue is Deno cannot be found. Has anyone experienced something similar?

When uploading the function it gives me an error which in local does not happen to me

Hey there supabasians is it possible to change auth email templates via api?

Just curious what is the general synopsis of architecture that Supabase sitting on and how secure is it when it comes to individual instances? If I were to transfer my app to use this BaaS (supabase), how "secure" is it?

(for reference, I'm using overseedio/realtime-go) Hey there! I'm having an issue where if I update a row, it only triggers my OnUpdate function once. It doesn't continue to trigger the functions. I've confirmed heartbeats are still sent. Not sure if this is something with my code, or if Supabase is having issues with realtime. (willing to bet its my code but i can't see anything wrong with it)

Is there a base64url encode available in supabase postgres? I tried looking online, and could only find a base64 encode one using the encode function. Thanks!

Following this doc https://supabase.com/docs/guides/cli/cicd-workflow#configure-github-actions Where do I get the

SUPABASE_ACCESS_TOKEN

from?

return is only like this one

I want to be able to publish events that edge functions would react too like AWS SNS and SQS I feel I could in theory write to DB and react to the write, but that feels like reinventing a Log Based Message Broker ie. and inefficient Kafka

Hello everone, I want to join two tables in different schemas. Creating a reference works fine but querying the table from the js client doesn't really work. The docs don't mention anything about schemas https://supabase.com/docs/reference/javascript/select#query-foreign-tables I'm getting this error: "Verify that 'table1' and 'table2' exist in the schema 'schema1' and that there is a foreign key relationship between them." I could probably use rpc instead of select but I have the same problem with subscribing to events, I only get data from table1.

I am getting an error in my browser address bar from supabase when I try to use the invite link that I sent myself from the supabase console. I invited my email address from the Supabase console and when I open the link I get this attached to the end of my url [image1]. I have disabled the email confirmation in the dashboard, but I still keep getting this error and can't see anything that would resemble a solution. Any ideas? Help would be very much appreciated.

Hi. My production PostgreSQL version is 14.1, while the local instance is 14.3. I want my local to be 14.1 as well. There is a setting for the major version number in

/supabase/config.toml

but no setting for the minor. How can I specify a minor version there as well? I tried adding

minor_version = 1

but it didn't work

The csv getting exported is generating a new row due to the the text within a specific column.

In react native, I need to login via redirect and with a token.

Linking.addEventListener('url', event => {
    let urlString = event.url.replace('app#', 'app?');
    let url = new URL(urlString);
    console.log({url});
    let refreshToken = url.searchParams.get('refresh_token');
    console.log({refreshToken});
    if (refreshToken) {
      supabase.auth.getUser(refreshToken).then(res => {
        setCurrentUser(res.data.user);
      });
    }
  });

I don't think

getUser

is the right thing to be using here? This is using the Google provider btw. It worked using

1.5

but auth has obviously changed and the docs aren't completed yet.

Hello, I'm following the 0.7.0+ Svelte-Kit Auth implementation and I've followed this documentation quite closely: https://supabase.com/docs/guides/auth/auth-helpers/sveltekit#client-side-data-fetching-with-rls ^^ Even though I check for

user

and it is populated, the

supabaseClient

call will still make my call with my

anon

key and not the user's token. Thus, every time I refresh the page, all queries return an empty array.

typescript
async function loadData() {
  const { data } = await supabaseClient
           .from('test')
           .select('*');
  loadedData = data;
}

$: if ($page.data.session.user) {
  loadData(); // <-- This returns [] on load
}

Unless, I wrap the supabaseClient call in

setTimeout(()=>{},0)

. This feels like a hack and I'm wondering what I'm missing?

typescript
$: if ($page.data.session.user) {
  setTimeout(() => loadData(), 1);
  // ^^ -- This works but feels hacky
}

--- I saw someone made a similar post but using nextjs, that post said not only do you have to look for the user, but also

isLoadingUser

. Looking through the documentation I don't see any mention of that or understand if that's a purely nextjs/react thing?