Hello @gerry! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hello @willm! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

I have table which one of columns is foreign key of

storage.objects.id

. On client-side I want to show list of items with images. What's good practice to get public url of image stored in public bucket?

Is there any reason why supabase CLI uses a deno install at

~/.supabase/deno

instead of the system's deno install? I use nixos and this breaks the CLI.

Any idea why

data

is always null in this edge function? I'm calling it in the browser with

supabase.functions.invoke()

.

ts
serve(async (req: Request) => {
  if (req.method === "OPTIONS") {
    return new Response("ok", { headers: corsHeaders });
  }

  try {
    supabaseClient.auth.setAuth(
      req.headers.get("Authorization")!.replace("Bearer ", "")
    );

    const data = supabaseClient.auth.user();
    return new Response(JSON.stringify({ data }), {
      headers: { ...corsHeaders, "Content-Type": "application/json" },
      status: 200,
    });
  } catch (e) {
    return new Response(JSON.stringify({ error: e.message }), {
      headers: { ...corsHeaders, "Content-Type": "application/json" },
      status: 400,
    });
  }
});

i am trying to setup docs in my localhost. but it gives mei the following error. Steps i followed : 1. cloned the repo 2. cd web 3. npm install 4. npm start

> supabase@0.0.3 start        
> docusaurus start --port 3006

[INFO] Starting the development server...
[ERROR] Loading of version failed for version current
[ERROR] Error: Invalid sidebar file at "sidebars.js".
These sidebar document ids do not exist:
- reference/cli/config-reference
- reference/cli/index
- reference/cli/installing-and-updating
- reference/cli/supabase-db-branch-create
- reference/cli/supabase-db-branch-delete
- reference/cli/supabase-db-branch-list
- reference/cli/supabase-db-changes
- reference/cli/supabase-db-commit
- reference/cli/supabase-db-push
- reference/cli/supabase-db-remote-commit
- reference/cli/supabase-db-remote-set
- reference/cli/supabase-db-reset
- reference/cli/supabase-db-switch
- reference/cli/supabase-functions-delete
- reference/cli/supabase-functions-deploy
- reference/cli/supabase-functions-new
- reference/cli/supabase-functions-serve
- reference/cli/supabase-help
- reference/cli/supabase-init
- reference/cli/supabase-link
- reference/cli/supabase-login
- reference/cli/supabase-migration-new
- reference/cli/supabase-secrets-list
- reference/cli/supabase-secrets-set
- reference/cli/supabase-secrets-unset
- reference/cli/supabase-start
- reference/cli/supabase-stop
- reference/dart/auth-onauthstatechange
- reference/dart/auth-session...

hi how to use a request param in a rls? such as allow select if id present.

is there a way to allow realtime subscriptions to listen to a rpc which bypasses a rls?

hello .. i am using full text search in supabase .. how can i search a sentence with that like .. i have title ' My Home ' i can search this using my or home ..but i cant search 'my home' is that possible to search sentence.

Hi. has anyone encounter a problem "'Unicode low surrogate must follow a high surrogate." when inserting data via supabase

In the screenshot, first object is data I want to insert, second object is error log The problem is in "\ud83c" if I move it, whether in title or in body, it'll show same error results To document this, in case someone has similar problem, I create a discussion on Github here https://github.com/supabase/supabase/discussions/7499

So I'm using Vercel, Alpine and Eleventy with Supabase: I'm trying to implement google auth. How can I create the supabase client from env vars to provide the sign in function to my button? With Vercel and Eleventy, I can have a .env file. But Alpine is clientside code. I'm confused. Please help!

Having some difficulty with Discord OAuth, I don't get any errors but after logging in with Discord, the authorize button just refreshes the page. I see in the authentication database, a user is created but no session is created (to my knowledge) and the page does not redirect. Code is exactly what docs say

js
const { error } = await supabase.auth.signIn({
  provider: "discord",
})

My auth redirect url is

https://qhikrendhqaxakizeybi.supabase.co/auth/v1/callback

and my app is hosted at

localhost:3000

Is there any documentation on the email templates? I can't seem to find any. I'm looking for a reference of the types of variables we can use in the templates. Like

{{ .Code }}

and

{{ .ConfirmationURL }}

I have been reading through the HN posts and this comment struck me https://news.ycombinator.com/item?id=31329304 > The defaults don’t seem super sane either, by default an anonymous user can read your entire public database schema via OpenAPI (which is turned on by default as well), including any RPC’s. That alongside the fact that Postgres grants RPC execute to public by default means that if someone isn’t paying attention they can easily expose execute permissions to the outside world on functions in their public schema to unauthenticated users, and tell them exactly what functions are exposed! > which brings me to my question. Are there ways to show what anon/authenticated user sees/can execute so you can eyeball it/write some tests against it?

I'm not able to connect to my database with psql (or any other client for that matter). I always get:

psql: error: connection to server at "db.v*************c.supabase.co" (35.158.98.251), port 5432 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?

Is it possible this is currently down?

hey, since when inserting we have to do it via id, but my actual dto type is a whole object

Hello! Pretty new user to Supabase and Postgresql here (I'm mostly a FE), so I'm a bit stuck with a problem which cannot be that difficult: I have a table called

places

and another

tags

. A place can have multiple tags and a tag can be in multiple places, so a n-n relation. I have a bridge table to connect both of them called

places_tags

which has the columns

id

,

place_id

,

tag_id

(FK to the id column on places and id column on tags tables). Now when I try to get all the places and their tags I try to do the following:

await supabase.from("places").select(`
    id,
    name,
    tags:tag_id(*)
`)

But I'm getting the following error:

Could not find a relationship between 'places' and 'tag_id' in the schema cache

What am I doing wrong? What I'm missing? Thanks in advance!

Anyone is getting also from time to time this error:

EPROTO 140471606753216:error:14094410:SSL routines:ssl3_read_bytes:sslv3 alert handshake failure

with supabase.co ? This error appears rarely, but I have just noted it. I had round about 800k requests and it happend on 8. Does anyone know a solution for this? This mostly looks like a server-side issue, not something i might be able to fix.

Anyone manage to insert user data when using signUp() and a trigger? I only manage to do it with oauth providers and raw_user_meta_data

How can I delete my first database and start from scratch again?

When "Authorize" is clicked in Discord Oauth, it shows waiting for discord.com and doesn't redirect to the supabase callback link. Is this a supabase or discord issue?

How can I tell the client what field to use for a relation in a select ? My

deal

table looks like :

| client_a | client_b | ... |

They both have a link to the

client

table. However, when I do:

js
supabase
  .from(`deal`)
  .select(
    `
      *,
      client!inner(*)
    `
  )

I sometimes get client_a, and sometimes client_b. But I always want client_b in this case. How can I specify this in my request?

Hi guys, I'm using Azure Single Tenant for Authentication. In the cloud version of Supabase, I can specify the Azure Tenant URL. However, I'm not sure what the corresponding config.toml key is for local development purposes?

Hey folks, am wanting to edit the auth templates on my selfhosted instance but seem to be unable to do so via the UI?

Hello @sean123! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hello @sean123! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Is the

pgadmin-schema-diff

up to date? comparing two databases with pgadmin4 gui and using the docker image yields different diffs. Last build was 8 months ago https://hub.docker.com/r/supabase/pgadmin-schema-diff/tags and I havent found the dockerfile for the image so thinking if that could be an issue

Hey guys, is it possible to forward logs from supabase to a standard syslog endpoint?

Hi guys! Ive been loving Supabase for a few months. I have an app where we have lots of forms and I would like to add functionality to download a part of a table (filtered) as .csv file. Is there a way supabase can help me with this, since it is already possible in the supabase UI? or should I just code it myself ? Thanks!!