Context: I'm building an app that lets you know when your friends are starting a spotify listen session. The way it works is that you'd sign in + give us permission to your information with Spotify OAuth and the app's server will ping the Spotify API regularly to notify your friends if you start listening to music. **Question**: We need the user's access token in the backend in order to send the get requests. To my understanding, I can't just give supabase auth a user ID and have supabase return an auth token. Does that mean I need to store the user access token + refresh token in a database? For some reason that doesn't seem to be right... Would love some input on this!

Hello I implemented Apple social login with "Login with Apple" in Supabase OAuth. I want to unlink user and our app when user wants to withdrawal, so I was searching how to do it and finally I got it that I can do it using "Revoke tokens API" in Apple documentation. The API requires 'token' field in HTTP Body to revoke tokens, so I used provider_token from Supabase to this field. But it didn't work well. I don't think provider_token is the value that this field requires. Then what is the value that goes into this field? Thanks in advance. This is url of "Revoke tokens API" https://developer.apple.com/documentation/sign_in_with_apple/revoke_tokens/

My Code as below:

Is this possible in the supabase sdk without using rpc?

Hi All. I've been working on a chrome extension and trying to use Supabase with it to set up Auth and to later store and retrieve data from supabase. Given MV3's constraints, there is essentially no way for me to import the supabase client into the chrome extension, and therefore have no way to interact with it. Here is what I want to do: 1a. Sign in/Sign up new users, triggered from Chrome Extension ✅ 1b. Validate the user's token for future sessions 🚫 2. Send data from chrome extension to supabase 🚫 3. Retrieve data from supabase to chrome extension 🚫 Essentially, I'm just trying to interact with the supabase client or my instance one way or another. Here are some potential solutions I can think of... 1. find some compressed supabase.js script that I can import locally (In chrome extensions, you can import local scripts, just nothing from the internet) - I saw this on an article on the same issue regarding firebase (https://dev.to/swimmingkiim/chrome-extension-with-firebase-manifest-v3-27gc) 2. Somehow make calls to [...].supabase.co through rest calls (ex. fetch('http://example.com/movies.json');) I've been stuck on this today and am not sure where to go. Any advice would be greatly appreciated!

I'm following this video from Jon Meyers where he creates a trigger, to insert into the profiles table when a new user is created. After creating this trigger, when I try to sign up, I get an error "Database error saving new user"

Since I've updated my npm packages, this error appears when I'm trying to launch my local Supabase instance :

$ pnpm supabase start
Applying migration 20230127002643_locations.sql...
Seeding data supabase/seed.sql...
Error: Error response from daemon: unable to find user kong: no matching entries in passwd file
Try rerunning the command with --debug to troubleshoot the error.

How I can fix this ?

Hey all, I am using the build in Auth component from the tutorial and the redirectTo doesn't seem to do anything:

<Auth redirectTo={'http://localhost:3000'} supabaseClient={supabase} appearance={{ theme: ThemeSupa }} />

It just goes to a blank page. The only thing that works is to redirect to another component. As in the tutorial, they intend you do redirect to the account edit page but who really wants to do this in practice? I just want to redirect back to the home page:

{!session ? (
      <Auth redirectTo={'http://localhost:3000'} supabaseClient={supabase} appearance={{ theme: ThemeSupa }} />
    ) : (
      <Account />
    )}

Any thoughts? I was going to go the route of building my own login/logout/forgot password but that seems like so much extra work to get right, when I would rather focus on the app build and come back to this later if I want a more custom solution.

Is it possible to encrypt a realtime database?

Hi I was looking for a way to query all the tables in database and also how to query what columns are present in a particular table.

Can anyone help me to figure out how to upload multiple images to storage or point me to the right resources if any? I will really appreciate any help.

Hello, I'm working on an app currently where users can gain coins. The coins can be gained, and lost while playing various games. I'm wondering how such feature best can be implemented. some requirements: - each user has a balance of coins - when playing a game the balance is updated depending on the outcome. - users can claim new coins every 24/h Since I'm very new to supabase (and BE for that matter) I'm not entirely sure how I can prevent users from updating their own balance, or how I can add coins to their balance depending on the outcome of a game etc. Thanks

Hi guys , I have an ImageUrl , I want a way to store the image of it.

or are they different? if its possible how?

Hi, I might be blind but I can't find where you get your service role key from? I've got the Authentication working in my vuejs frontend but I was planning on using the service role for my python backend, but I don't where to find it in the Dashboard? I was trying to follow this tutorial: https://egghead.io/lessons/supabase-use-the-supabase-service-key-to-bypass-row-level-security And I am just a bit confused as to the new location of the service role key is in the new Dashboard

i have a supabase instance the hosted option, i'm trying to invite someone to work with me on the database but whenever i do they receive an email directing them to the localhost, how can i fix that?

As per subject, regardless of whether the record exists or not, the upsert method always returns status=201 and statusText=Created Is this a bug or intentional?

I am trying to build an infrastructure that allows an user to have a personal file system where they can create files, issue common bash commands and use common tools to interact with the file in the file system, like creating columns and rows in a database using SQLite and similar. I am thinking of self-hosting a supabase system for each collection of user (for example a company), where each collection of user has its own file system. I would like to use supabase to wrap around this file system as it would provide help with tasks such as authentication. I cannot use the built-in Postgres database as I would like to make it possible to have multiple databases in each storage instance. Is this possible with Supabase? I am pretty new to the backend world, so I apologize in advance in case I was not clear.

the postgresql is like this:

sql
SELECT id, title, created_at AS note_date FROM notes ORDER BY note_date DESC;

I want to alias the note_tag field in response:

javascript
const result = await supabaseServerClient
    .from('note')
    .select(`
      *,
      note_tag as tags (
        id,
        title
      )
    `, { count: 'exact' })

but the

note_tag as tags

not work

Hi, I’m currently working on a Supabase+Nextjs project. My supabase instance is hosted on a ec2 instance, I’d like to generate types using the Supabase CLI in my nextjs project. Could you help me with that please ?

Hi, i try the define as array option for a text type but how does this work? I cant find any docs about it. What is the correct why to file in the value? greetz, jordi

So I understand that supabase is using an older Auth library , but I noticed in this form that the developer has the option to input client id and secret while I have to put in keys. https://github.com/supabase/supabase/discussions/5915. Is there any way currently to get access tokens that work for oauth 2 through the supabase login flow ?

I noticed the other day that joined types are now a thing and not just unknown, which is great! I'm tired of having custom types for every combination of select and foreign key joins. Is there any way to utilize this without dropping down to postgres-js?

type Test = ReturnType<supabaseClient.from('a_table').select('*, a_foreign_row:a_foreign_table!a_foreign_row_id (*)')>;

I've achieved what I want with:

import { GetResult } from 'https://esm.sh/v111/@supabase/postgrest-js@1.4.1/dist/module/select-query-parser';
type Test = GetResult<
  Database['public'],
  Database['public']['Tables']['a_table']['Row'],
  '*, a_foreign_row:a_foreign_table!a_foreign_row_id (*)'
>;

But getting it from our supabase client objects would be nice 👀

I'm wondering how I can add additional data to response objects. Say I have a table with a few fields, and my response object looks like this:

{
  title: 'My Title',
  completed: true,
}

and I want it to look like this:

{
    title: {
      value: 'My Title',
      type: 'text',
    },
    completed: {
      value:  true,
      type: 'checkbox',
    },
  }

Basically, I want to take Supabase's response and map it to represent a form, with additional fields that describe how to build the form on the client...and hopefully still generate types. My fallback plan is to implement the mapping client-side. Not a huge deal, but I'm wondering if this sort of pattern, transforming and extending the data collected from the DB, is supported, and what Supabase calls it.

Running the query returns 1245 results, however when I run the function with supabase.rpc I only get 1000 results returned. Is there a limit of 1000?

I'm building an app where most of the time the users will just be using their own data. So I was thinking if I have a table, let's call it "todos", I'd much rather have a seperate table for each user, rather than a public table where all todos are inserted and marked with a userId column. I haven't found any info on if this is even possible if it is if it's a good idea. Any feedback would be appreciated. Also ready to hop on call if a short discussion with voice is better than writing it out in text. Thanks for the help!

Hey, I get this error if I want to add a column to a table

failed to update pg.tables with the given ID: must be owner of event trigger pgsodium_trg_mask_update

I do not know why this is. The table I want to update is in schema

admin

and is named

marketplaces

. I use pgsodium to protect some tables, but not the one

admin.marketplaces

. Looking forward for some help.

Is there a way to query what tables are in the database? Example: My project has 3 tables Athletes Sports Venues Is there a way to get the list of tables in the database and information of what columns they have?

I recently watched "CRDTs for Mortals" by James Long and was completely fascinated. I'm now trying to implement this in my own app. So far I am stuck on the merkle tree though. If client A and Client B both change the same field, client B being the later write, then only client A would need to sync, right? but then doesn't the merkle tree of A include a hash that is not present in B? Does this mean that client B also needs to donwload the changes A made, even if they are not needed? Now that I say it it kinda makes sense, since the message from A could be for any field, and there's not really a 'only get the latest message per field' thing going on. And I guess if you don't implement something like this you just have to sometimes download old messages as well when they happen. Am I missing something here?

Hi, in this video by Jon, I am wondering what Stripe API was used to automatically create the new customer profile? Was the API Stripe Connect? If so, is it Standard, Express or Custom? Thanks in advanced.