Uploading a file returns the filepath as response. How do I get the associated uuid of the file details being written in storage.objects?

Did I see some one on here talk about a Nextjs x Supabase context provider component that shipped as a package??

Hey all! Is there any way to install the new pg_graphql extension on a cloud database instance like an AWS RDS postgres instance? There was some message on one day supporting this in the doc when the extension was in alpha, but it's not there anymore. Is it still something that will get supported at one point? 🙂

Hi, I've been reading a lot of the messages regarding Auth and they all say that the acess & refresh token is stored in local storage with the

supabase.auth.token

key. Indeed supabase.io does the same. But in my NextJS app with auth-helpers I'm not seeing anything in local storage but two cookies with the name

sb-access-token

and

sb-refresh-token

. Can someone please explain why it's different for my app?

How do you query another table using the foreign keys? I have some information in my profiles table and resources table. The below doesn't seem to work.

const {data: resources} = await supabase.from('resources').select("*",`profiles(*)`)

hi @User, I'm trying to run supabase.auth.setAuth(token) on a sveltekit endpoint. The token is valid (via jwt.io) and it's getting passed to the endpoint. Though when I console log supabase, I get the following output (with sensitive data replaced):

supabase :>>  SupabaseClient {
  ...
  headers: {
    'X-Client-Info': 'supabase-js/1.32.2',
    apikey: 'apikey',
    Authorization: 'Bearer apikey'
  },
  shouldThrowOnError: false,
  auth: SupabaseAuthClient {
    stateChangeEmitters: Map(50) {
        ...
    },
    currentUser: null,
    currentSession: {
      access_token: 'valid access token',
      token_type: 'bearer',
      user: null
    },
    autoRefreshToken: true,
    persistSession: true,
    multiTab: true,
    localStorage: undefined,
    api: GoTrueApi {
      url: 'my endpoint',
      headers: [Object],
      cookieOptions: [Object],
      fetch: [Function (anonymous)]
    }
  },
  realtime: RealtimeClient {
    accessToken: null,
    channels: [],
    endPoint: 'my wss endpoint',
    headers: { 'X-Client-Info': 'supabase-js/1.32.2' },
    params: {
      apikey: 'correct api key'
    },
    timeout: 10000,
    ...
  }
}

As you can see the tokens and keys are correct, but I don't get user info back. Is this expected or the reason I'm getting 406 error?

I mistakenly attempted to use a magic link and custom data for the signUp field, and discovered signUp without password is not allowed. If the user will always use a magic link to signIn, can I work around this by generating a random password in the background and passing that instead? Does this have any vulnerabilities or disadvantages? Is there a better way to achieve this goal (registration page with added data, verification of email, signin only via magic link?)

Hmm can't seem to get it to work, tried a few different variations as well.

@User please create a thread on your original message and as its easier to keep track of conversations there

Foreign key relationship

is there any way to use RLS without using the auth object? Why? because I'm building a store... so users don't want to sign up, they want to see all the products (table products is free to read) and add those products to the cart (table cart ??? ) this table cart is what I don't know how to do it, because at first I was giving the user a uuid through a cookie, and then using that cookie in every call but I realized that anyone with my public supabase key could start reading / deleting others people cart because I don't have a policy in the cart because I don't have signed users yet... any ideas?

The Free tier doesn't mention any regions - when I'm ready to move to the Pro tier, can I select a different region?

How can I determine user to upload/update ONLY image files?

I am working with ngrok to create a tunnel for my local environment the problem is I have to create a whole new function hook each time I run ngrok to update the url. Is there a better way?

Is there any way to send push notifications via Supabase? What would be the best way?

How can I implement invite team member functionality in supabase? Lets say I am using paid application that has limit fo 5 team members which I can add remove and invite how can I handle this functionality in supabase?

Is there a way to only accept auth from users that before I have invited?

Hi, is there a way to implement a

withoutAuthRequired

? My logic is- -

/login

should be shown only if a user is not authenticated - If a user is authenticated then

/login

should redirect to

/home

-

/home

should be shown only if a user is authenticated - If a user is not authenticated then

/home

should redirect to

/login

The last two points can use

withAuthRequired

. How can the first two points be implemented?

Hey Martin. Did you can an answer to this question...I'm having the same problem.

why storing an image object in supabase is stored as text? "{"size":5849107,"mimetype":"text/plain;charset=UTF-8","cacheControl":"max-age=3600"}" If I store it directly on the client it works and stores it as "image/png" but if I store it though my /api/file.js and then to Supabase it stores it as text, check out my code: //index.svelte

async function handleFile(){
    const formData = new FormData();
    formData.append("file", file);
    let resp = await fetch( '/api/file', {
      method: 'POST',
      body: formData,
    })
    console.log(resp)
  }

//api/file.js

import {supabase} from '/src/lib/supabaseClient'

export async function post(event) {
  const data = await event.request.formData();
  const fichero = data.get('file')

  const {data: imageData, error:imageError} = await supabase
  .storage
  .from('images')
  .upload("algomio/"+Date.now(),fichero,{
    cacheControl: '3600',
    upsert: false
  })
  if(imageData){
    console.log("imageData: ",imageData)
  }
  if(imageError){
    console.log("imageError:", imageError)
    
  }

  return {
    body: {algo:"algo"}
  }
}

Anyone know how to change this with Supabase auth discord login? users think the site has been hacked..

Hello Everyone. I can't get user metadata to save in Supabase when creating the user using supabase.auth.api.createUser().

const { data: user, error } = await supabase.auth.api.createUser({
    email: username,
    password: password,
    data: {
      first_name: first,
      last_name: last,
      address: address
    }
  });

This always ends up having the user_metadata as a blank object.

console.log(user);
{
  id: 'deg84a9f-334e-8v6s-81bd-87dd864e0t187',
  aud: 'authenticated',
  role: 'authenticated',
  email: 'email@email.com',
  phone: '',
  app_metadata: { provider: 'email', providers: [ 'email' ] },
  user_metadata: {},
  identities: null,
  created_at: '2022-04-04T19:14:21.704112Z',
  updated_at: '2022-04-04T19:14:21.705655Z'
}

Do someon3 know how to have typing work in supabase deno?

Is it possible to link additional (social) providers to an existing user (email, password) when they are already logged in AND the email address isn't the same?

Hello, is it possible to access Supabaes Storage REST Apis through curl? All the documentation i saw was on Javascript and I´m on an environment that wont allow me to use createClient

Hey guys. My project just got randomly deleted when I logged into my Supabase account this evening. I don't know what to do.

How do I handle

Foreign keys between database schemas are not supported in Prisma.

to use both supabase and prisma in a project? Or is it just not really possible? I'm okay with organizing my database differently if I can use both tools, but I'm curious if I have to be choosey

How do you increase speed in loading of data in Supabase? We have noticed that it takes a long time to load the db. I don't know if it's cause by vercel or by supabase but most probably supabase because it's just waiting for data to load. Stack use: Nuxtjs, Supabase, Vercel Thanks 🙂

I'm asking myself on how to integrate the whole supabase setup in my codebase and was just wondering about how to keep migrations etc on the code side of things. Is there a recommended way to integrate that or am I supposed to just keep it all on the supabase website interface?

Are there any options to add custom payload if the user signs up? I have basic users and I have business users (distinction is just a boolean in a mapping table that the user can't edit). The usecase is, that If a business user registers, I'd like to redirect him somewhere else to finish the signup. (I'm using nextjs, so I could have a custom API register route that adds the data to the mapping table, once the user invite was created, but maybe there is a more elegant solution. Vercel functions are incredible slow ^^ (1-2seconds to boot up))