With the transition to cloud, will self-hosted supabase images still be updated every now and then? Especially, the UI; as right now there still exists a couple of bugs.

Hi all, I can't seem to add a new schema in self-hosted supabase environment. I ended up doing this via postgres directly but now the api isnt updated accordingly. Any clue how this can be done? {'message': 'The schema must be one of the following: public, storage, graphql_public'} Is my studio perhaps outdated? as i read there should be a settings wheel in the bottom left. I did try to pull latest studio version from github though.

Been trying to connect to database from my svelte project and couldn't managed to

I have a plpgsql function that returns jsonb, when I call it in the sql editor of the studio, it works fine, but when I call it from the js client, it doesn't return some values, I wonder what's wrong.

This is the python code I'm using:

py
supabase.storage().from_('avatars').upload(filepath, filepath, file_options={"upsert":"true", "contentType":"image/jpeg"})

However, the file is still being uploaded as a plain/text file and does not overwrite existing files.

Has anyone build a facet search with supabase? I'm looking for a brief tutorial. My issue is that if I have 6-10 filters (e.g. price, date from, to, relations (countries), ...) I have to fetch the results and the updated filters which results in like 10 queries. I'm used to do that with algolia, but it would be nice to use supabase as well 🙂 I haven't tried GraphQL with supabase, but I guess this would be a usecase!

I would like to have a mirror version of my DB locally during development. I've set up a local DB but when I try to link my DB on supabase with my local docker ist just throws an error: I find it very strange that there is no mention of how to achieve this in the docs, is it not common practice to have a local version when developing and then migrate/push changes?

bash
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x2 addr=0x8 pc=0x104c32bdc]

So, I recently learned that I can decide the URLs that the application is allowed to redirect, after authentication (Pic related). But if I am trying to authenticate inside a Chrome extension... does anyone know what URL I should input, to allow this?

i have typesafety for almost everything but the realtime subscription. am i doing something wrong or that just the way it is? is there a solution to that? i want to use the type generated by supabase so its sync but idk if its possible

I created two policies for a table. In the first, I restricted all users for all types of operations using (false) with check(false). In the second, I allowed authorised users to select. Now supabase only allow authorised users to only select from the table and all other operations are restricted. So my question is how policy override works.

Hi, I am trying to authenticate a user on the client with a custom jwt. but session is always null.

ts
export const supabase = createClient(supabaseUrl, supabaseAnonKey, {
    global: {
      headers: {
        Authorization: `Bearer ${test_token}`,
      },
    },
  })

firebase version```js signInWithCustomToken(auth, token)

my payload 
```json
{
  "sub": "e6870286-5378-4cc5-8641-af2b60051b56",
  "exp": 1674570524,
  "role": "anon",
  "iat": 1674566924
}

With the third party auth providers you limit which domains can authorise against your website through the redirect url list. Is there any way to do this for password authentication? I checked, and a signed up user can login via username/password with public api key client library from a non registered domain.

supabase link --project-ref ********************

Results in:

bash
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x2 addr=0x8 pc=0x104bdabdc]

goroutine 1 [running]:
github.com/jackc/pgx/v4.(*Conn).Config(0x1054ff2b8?)
    /home/runner/go/pkg/mod/github.com/jackc/pgx/v4@v4.17.2/conn.go:382 +0x1c
github.com/supabase/cli/internal/utils.ConnectRemotePostgres({0x105506720, 0x140006a88c0}, {0x1050bd92b, 0x8}, {0x14000350010, 0x10}, {0x1050bd92b, 0x8}, {0x14000432810, 0x23}, ...)
    /home/runner/work/cli/cli/internal/utils/connect.go:39 +0x234
github.com/supabase/cli/internal/link.linkDatabase({0x105506720, 0x140006a88c0}, {0x1050bd92b?, 0x14?}, {0x14000350010?, 0x10545ae60?}, {0x1050bd92b?, 0x10478ac28?}, {0x14000432810?, 0x1050a170c?}, ...)
    /home/runner/work/cli/cli/internal/link/link.go:123 +0x48
github.com/supabase/cli/internal/link.Run({0x105506720, 0x140006a88c0}, {0x16b71f7dc, 0x14}, {0x1050bd92b, 0x8}, {0x14000350010, 0x10}, {0x1050bd92b, 0x8}, ...)
    /home/runner/work/cli/cli/internal/link/link.go:43 +0xac
github.com/supabase/cli/cmd.glob..func29(0x105b6a880?, {0x1050a9a1d?, 0x2?, 0x2?})
    /home/runner/work/cli/cli/cmd/link.go:32 +0x10c
github.com/spf13/cobra.(*Command).execute(0x105b6a880, {0x14000880540, 0x2, 0x2})
    /home/runner/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:916 +0x5f4
github.com/spf13/cobra.(*Command).ExecuteC(0x105b6e200)
    /home/runner/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:1044 +0x35c
github.com/spf13/cobra.(*Command).Execute(...)
    /home/runner/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:968
github.com/supabase/cli/cmd.Execute()
    /home/runner/work/cli/cli/cmd/root.go:67 +0x2c
main.main()
    /home/runner/work/cli/cli/main.go:8 +0x20

I'm a bit struggling to understand how to deal with 1 to 1 relations. more specifically parsing the json from supabase to dart objects. I got that I can make a select like this

dart
final response = await _supabaseClient
          .from('gifts')
          .select<List<Map<String, dynamic>>>('*, users:owner(*)')
          .neq(
            'owner',
            _supabaseClient.auth.currentUser?.id,
          )
          .order('created_at', ascending: false);

and then

dart response.map(SupabaseGift.fromJson).toList();

then when using json_serializer i can parse individual fields with specific parsing logic. So I think users in the result will be a list. But I don't want a list of users, I want one user in my gift object. Is there a way to define this in the supabase query? Or this is done automatically? btw owner is a uuid foreign key in the gifts table pointing to users table.

I have a column I previously created as JSON. But when creating/editing in the select area only JSONB is allowed now. When I edit this column it's blank, because JSON isn't in the list anymore.. Is this a bug or intentional?

I am attempting to insert data from a csv file into Supabase via a Python dataframe (read_csv). Has anyone attempted this successfully?

I've followed all the instructions and even read this troubleshoot page for prisma: https://docs-ol21ts3im-supabase.vercel.app/docs/guides/integrations/prisma#troubleshooting but im not receiving any events. * I've enabled Replication to my desired tables * I've enabled Row Level Security to my tables * I also used https://realtime.supabase.co/inspector to see events but still, im not seeing them there this is a snippet of what im trying to do:

const [channel, setChannel] = React.useState<RealtimeChannel>();

  React.useEffect(() => {
    if (channel) {
      return;
    }
    setChannel(
      supabase
        .channel('collections-db-changes')
        .on(
          REALTIME_LISTEN_TYPES.POSTGRES_CHANGES,
          {
            event: REALTIME_POSTGRES_CHANGES_LISTEN_EVENT.ALL,
            schema: 'public',
            table: 'Collection',
            filter: `owner=eq.${uid}`,
          },
          (payload) => {
            console.log({ payload });
            fetchCollections();
          }
        )
        .subscribe()
    );

    return () => {
      if (channel) {
        supabase.removeChannel(channel);
        setChannel(undefined);
      }
    };
  }, [channel, fetchCollections, uid]);

But im not getting any events, even all ws messages seems to be working fine:

{
  "event": "system",
  "payload": {
    "channel": "collections-db-changes",
    "extension": "postgres_changes",
    "message": "Subscribed to PostgreSQL",
    "status": "ok"
  },
  "ref": null,
  "topic": "realtime:collections-db-changes"
}

Am i missing something?

Hi I need some guidance I’m trying to implement resetpasswordforemail in Nextjs Currently user opens the /forgotpassword route and enters email and submits then I call “resetpasswordforemail” and then email is received and when I click the link I’m ideally suppose to be redirected to “https://localhost:3000/resetpassword” but it redirects to /resetpassword#access…. Is there something I’m missing ? Or methods missing ?

Once a user is registered, a confirmation email is set. Is it possible to send those to Mailtrap.io?

Hi is it possible to insert a row if it doesn't already exist. I.E. insert a user ({username, name, email}) if it that combination does not exist in the users table already? Would that be through an upsert?

seems counterintuitive, but just wanted to ask. same way we use

{ data, error}

when inserting or updating a row

I have a flutter app with >10k sign ups currently using firebase auth. Now I want to add functionality to the app using Supabase. Long term I am planning to migrate everything. But for now, I would like to sign in the users to both Firebase and Supabase so that I can use both in the Flutter app. Has anyone done something like that? A stupid & simple idea would be to create a Supabase account when a user signs in for the first time with the new app version using email+password: {FIREBASE_USER_ID}@dummyemail.com, PW: randomPW (stored in Firestore) Is it possible to synchronize both auth systems? Or is it possible to tell supabase: "Here is a user with the following UserID that's already authenticated using firebase. Please let me use him"?

Using the latest versions of everything in Svelte Kit and getting the following error in the console:

bash
Error: The "host" request header is not available
    at isSecureEnvironment (/Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/auth-helpers-shared/dist/index.js:226:11)
    at Object.setItem (/Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/auth-helpers-shared/dist/index.js:404:47)
    at /Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/gotrue-js/dist/main/lib/helpers.js:89:19
    at Generator.next (<anonymous>)
    at /Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/gotrue-js/dist/main/lib/helpers.js:31:71
    at new Promise (<anonymous>)
    at __awaiter (/Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/gotrue-js/dist/main/lib/helpers.js:27:12)
    at setItemAsync (/Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/gotrue-js/dist/main/lib/helpers.js:88:46)
    at SupabaseAuthClient._persistSession (/Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/gotrue-js/dist/main/GoTrueClient.js:894:43)
    at SupabaseAuthClient.<anonymous> (/Users/rchrdnsh/Code/Svelte/RYKR-kit/node_modules/@supabase/gotrue-js/dist/main/GoTrueClient.js:889:28)

...any thoughts as to why this is happening? Thanks XD

Can you connect Supabase/Hasura to Wordpress? I don't mean just GET requests but the other stuff too like delete and create?

Using the javascript library, it's very easy to do a 

not('columnName', 'in', '(values)')

 to perform a 

not in

 query, however, I haven't been able to do so using the python client. I know that we can perform an 

in

 query using 

in_

, but I would love to be able to perform a not in query too so that our users can query more easily. Any ideas?

I have integrated the Supabase auth in my website, but the authentication mails take time to be delivered to the user mail inbox. However I checked through the logs and auth database also, confirmation mails are sent immediately from Supabase but doesn't get shown in the inbox. Also the time of receiving in the gmail inbox shows the same as Supabase but it doesn't show upto 3 mins after sending the confirmation link to the user. I also checked signing up in other template applications hosted by Supabase, they appear immediately in my mail but only my website auth mails delays. Any help would be appreciated. Thank you

Ideally, I'd like to redirect from my root property to a multi-tenant subdomain. In my mind, if I can get auth approval, then route to a custom subdomain based on the data retrieved from the authentication, I can solve this pretty easily. However, you have to provide the

redirectTo

options property ahead of the auth request. Anyone have any ideas on how to build this into one function?

What would be a good way for the user to customize their Display Name and Avatar if they log in with an OAuth provider like GitHub? It seems that users who use a provider like GitHub do not get added to the profiles database.

How do I join tables in a real time query? I'm looking for a realtime equivalent of this..

Hello, I was wondering if there are any barriers to developing on macOS? My main concern would be supabase cli and whether the Docker containers can be deployed. I saw that postgres has to be manually built in Raspberry arm, so how about macos?