Hey guys, I'm having an issue where I am mapping a many to many relationship in the database between books and genres. However, when I filter this data, it'll return multiple instances of the same book if I query two genres that the book has. How do I stop this? Thanks!

@User Hi! I've tried contacting the administrators but didn't get any response. I wonder if it would be possible to contribute to the Supabase Community organization on Github, submitting my Supabase SDK for Godot Engine. Currently the SDK contains the features alltogether, but can be already separated in feature-repositories like it is already done in the Supabase Community org. Here's the SDK: https://github.com/fenix-hub/godot-engine.supabase The SDK is going to be updated following the most recent Supabase updates, and also a new version will be coming during the next month for Godot Engine 4.x, since the syntax is pretty much different.

I am getting the following error

Property 'signIn' does not exist on type 'SupabaseAuthClient'.

for this code:

export async function signInWithGoogle() {
  const { user, session, error } = await supabase.auth.signIn({
    provider: "google",
  });
}

I'm currently trying to use the pg_cron extension. However when I try to enable it in a migration using

CREATE EXTENSION pg_cron;

I get the following error:

Error: Error starting database: ERROR:  can only create extension in database postgres
DETAIL:  Jobs must be scheduled from the database configured in cron.database_name, since the pg_cron background worker reads job de
scriptions from this database.
HINT:  Add cron.database_name = 'main' in postgresql.conf to use the current database.
CONTEXT:  PL/pgSQL function inline_code_block line 4 at RAISE

It's probably because the Supabase CLI creates a database named after the current branch (default

main

) and only later renames it to

postgres

. Is there a way around this? If I try to enable the extension after I started the server it does work however I need to be able to use it in migrations.

flags means Reference ID, right? If my Reference ID is ABCD, This is https://app.supabase.com/project/ABCD. So I entered the command 'supabase link --ABCD', It doesn't work. There is no guide on this. Existing guides are too short of explanation. No consideration for newbies at all. What should I do?

I am building something that needs a server since it handles exchange of access and refresh tokens with Google and Microsoft. I decided to use Supabase for handling user signup / login to have one less thing to think about. But now I am faced with the following problems that makes me question whether I am using Supabase correctly and whether it fits my needs. The scenario I am facing is the following:

A client logs in and then requests some information from the server. 
The server retrieves the `access_token` for the user and gets the information
The server sends the information back to the client

A few questions: 1. How does the client makes an authenticated request to the server? From [this](https://github.com/supabase/supabase/discussions/1094) thread, my understanding is that I need to send a JWT to the server, and then the server needs to create a new Client (via

supabase-js

for example) and that will tell me which user is making the request. 2. Once I know the user that is making the request, I want to retrieve her tokens from the database. From my googling, it doesn't look like I can modify the table where the user information is stored

auth.users

, so what is the best way to go about this? Should I create a new table that contains the

id

of the user and the relative tokens? Do I do this from the web console of Supabase?

Hi, i've just started using supabase with nextjs. I have i simple function that retrieve user data from 'profiles'

let { data, error, status } = await supabase
          .from("profiles")
          .select(`username`)
          .eq("id", id)
          .single();

        if (error && status !== 406) {
          throw error;
        }

        if (data?.username) {
          router.push({ pathname: "/[account]", query: { account: id } });
          return;
        }

At the [account].tsx page i'm receiving the id and making another query to 'profiles' to get user data, but this time i'm also getting the property avatar, which in my schema is defined as 'text'. But i'm receiving this error when i try to retrieve the avatar. The "4bc97434-c7a5-4a5e-a32d-e1c66a6a588e" is my user.id. After i uploaded the image to storage i retrieve it's url by getPublicUrl and updated the avatar property of the user. I don't understand what am i doing wrong here.

Hey guys, In my Supabase Auth settings I have

localhost:3000

as my site URL and my apps deeplink url has been added to the

Redirect URLs

list. When a user verifies their email, they're currently sent to

localhost:3000/...

I imagine ill change this to my website url when i go live. But im wondering how I would handle sending the user back to the mobile app instead of my website url, if they signed up from there?

Hi, I am implementing the JWT token flow from SupaBase into my REST API written in DotNet 6 Historically you always needed a "Authority" (Issuer) field to pass into your configuration of the JWT authenticationScheme. However it seems that SupaBase do not pass it into their tokens. What is the default authority or issuer in SupaBase?

I can't find

supabase.channels

method

Hello, I am trying to authenticate a user from a backend that is written in rust. Basically all what I need is to verify credentials and get user's uuid. How can I do this?

Ive followed both the apple implementation and the older one from #885237287280070708 and still cant make it work, im getting [Unhandled promise rejection: TypeError: undefined is not an object (evaluating 'window.location.href = url')]

So I have a table with user profiles that contains basic user data like username, email, uid, etc. Now I have RLS enabled for this table to allow only user's profile to be edited. The thing is I want to get access to user's email from

SELECT

only if it's his profile. Anybody know how can I do that by RLS Policy?

I used the table editor on the supabase website to create a schema, and now I have supabase running locally. Is there a way to dump the remote schema onto my local database? I tried this after linking the project:

supabase db remote changes

But it just sits there with this message at 0% forever:

Generating changes on the remote database since the last migration...

I have no local schemas or migrations. There doesn't seem to be anything in the docs about doing this; the local development page (https://supabase.com/docs/guides/cli/local-development) only seems to have instructions for pushing changes from local -> remote

I have a vocabulary table and want to create many to many relationships between words like synonyms, antonyms, homophones, etc. Currently I have created a table called "antonyms" with an ID column, column A referencing one word, and column B referencing another word, however when I query this in supabase js I get an error "code: "42703", details: null, hint: null, message: "column vocabulary.antonyms does not exist" Does anyone have a working solution for many to many within the same table?

What's the easiest way to create an optimistic UI with Supabase in React?

I want to build link share feature. That is, the row can be read only if auth.uid()=row’s profile id or Row is read by shared link. How can i implement “Row is read by shared link” feature in RLS policy? Or is there any other way to implement this feature?

I cannot find any documentation around the endpoints for storage and the entire API in general - any tips?

Hello, I feel like I simply don't know the words to search for this solution so I am asking here. Apologies in advance if this is obvious! I'm trying to return results based on querying a join table. I have a recipe that joins an ingredients table and I want to write a query that can filter out the recipe based on the existence of multiple ingredients only (if both ingredients are not in the recipe, do not return it). My query (after following this -> https://github.com/supabase/supabase/discussions/6587) to get a result back if it has one ingredient by id looks like this :

js
let query = supabase
     .from('recipes')
     .select(
       '*, ingredients:recipe_ingredients(*, ingredient:ingredients(name)), qry:recipe_ingredients!inner(*, ingredient:ingredients(name))'
     )
     .eq('qry.ingredient_id', 1)

For now my data structure of a single recipe looks something like this :

js
{
  "id": "17805382-150d-4dad-842a-15905f03c732",
  "name": "recipe name",
  "ingredients": [
    {
      "recipe_id": "17805382-150d-4dad-842a-15905f03c732",
      "ingredient_id": 1,
      "quantity": 6,
    },
    {
      "recipe_id": "17805382-150d-4dad-842a-15905f03c732",
      "ingredient_id": 10,
      "quantity": 5,
    }
  ]
}

I tried combining queries from an array in a for loop, but this doesn't return any results when more than one item query is added :

js
let query = supabase
    .from('recipes')
    .select(
       '*, ingredients:recipe_ingredients(*, ingredient:ingredients(name)), qry:recipe_ingredients!inner(*, ingredient:ingredients(name))'
    )

for (let f of filter) {
    query = query.eq('qry.ingredient_id', f)
}

const { data, error } = await query

Any assistance would be most welcome. 😖

Hi, just started using Supabase. When the user uploads a photo, i retrieve it's public URL and add that to the avatar_url property of 'profiles' table row. And then at the account page i display it using that url as the img source. But i'm getting a GET 400 error. Am i doing it the wrong way? Should i create an object url like ?

const { data, error } = await supabase.storage
        .from('avatars')
        .download(path)
      if (error) {
        throw error
      }
      const url = URL.createObjectURL(data)

I'm currently using Twilio's Conversations API, where they allow a webhook to react to different things happening. I'd love to send some hooks back over to my Edge Functions to handle them but it seems I cannot Invoke them without any Auth header. Twilio doesn't seem to give me that option to add headers. Would Supabase recognise Auth params? in the url?

Hi, am trying to update the user avatar photo but am stuck and what the doc says is not working, it returns a response that says "resource not found" maybe there's something wrong with the file path to be modified but don't know how to correct that other than what is given in docs.

is it possible to configure cli (local development) for an already hosted project?

is there a way to generate types for hosted db?

I've been attempting to put supabase on my server self hosted, everything works fine (including when the db and supabase aren't decoupled), but when I decouple them and use the locally hosted postgresql, it won't connect. I can connect through dbeaver fine, I tried with installing postgresql myself, and then deleted postgresql and the supabase folder. I reinstalled supabase from scratch, as well as installing https://github.com/supabase/postgres instead for the postgresql. However still no luck...

10/Oct/2022:16:03:13 +0000: {"details":"connection to server at \"0.0.0.0\", port 5432 failed: Connection refused\n\tIs the server running on that host and accepting TCP/IP connections?\n","code":"","message":"Database connection error. Retrying the connection."}

time="2022-10-10T16:03:15Z" level=fatal msg="running db migrations: Migrator: problem creating schema migrations: couldn't start a new transaction: could not create new transaction: failed to connect to `host=0.0.0.0 user=postgres database=postgres`: dial error (dial tcp 0.0.0.0:5432: connect: connection refused)"

I've tried different host names and ports. Eg.

localhost

,

0.0.0.0

,

127.0.0.1

, and

54322

, but to no avail. On the previous install of postgres I created a new superuser with password etc. to see if it was a problem with that, but it wasn't, as well as creating a new database (editing env etc.) Anyone have any ideas?

I already have an account on s3

So I have table with user profiles and I want to restrict some features only to specific users with specific int value

role

if role is

1

INSERT

request will be allowed. Anybody knows how can I do that with policies?

Is there some setting for this? I keep getting an SSL error. Is this on google OAuth or supabase? Thanks 🙂

Is there a way to change a id column that has an identify type that increments each time a new row is inserted. For example if its a prior table with 50,000 rows can i have it start at 50,000 and increment to 50,001 on the next insert? Is there a sql query i could write for this or a way in the GUI to fix this?

I have a web app using Vue 3 with custom account management pages: email verification page and password reset page. The problem is this: 1) User creates account / requests password reset email 2) User clicks email link to go to custom account management page 3) User is redirected to account management page for a split second 4) User is authenticated immediately thereafter and therefore redirected to a page requiring authentication With this setup, the user is unable to reset their password, and I'm unable to use the custom pages. Important notes: - I'm using redirectTo inside the "resetPasswordForEmail" method, and I'm using it correctly. - I have the proper localhost URL inside the Supabase auth dashboard - I'm using Vue router and doing all routing inside App.vue Please help me resolve this