Hello, I'm still in my early steps with supabase, but love it so far. I set up my demo app, and it's mostly working. But I want to log in with email/password or magic link. With other auth providers you can set the redirectTo in the request (https://supabase.com/docs/reference/javascript/auth-signin#sign-in-with-redirect). But for email and magic link you need to directly edit that in the email template. How can I access the

redirectTo

parameter in the template? Currently it's

href="{{ .ConfirmationURL }}"

Hello I try to self host supabase, try in two different machines to prepare things for implementation of custom provider .....with bellow instructions from https://supabase.com/docs/guides/hosting/docker

shell
# Get the code
git clone --depth 1 https://github.com/supabase/supabase

# Go to the docker folder
cd supabase/docker

# Copy the fake env vars
cp .env.example .env

# Start
docker-compose up

go to http://localhost:3000 but this self host is complete different from https://app.supabase.com/ in self host I don't have many things like in https://app.supabase.com/, for example **I can't see the auth providers **like I see in https://app.supabase.com/ screenshot from self signed and from supabase hosted this self hoste, seems more a half part of the, pie the question is how self host supabase with all the feautures, or with oauth features for ex thanks

Hi ! I'm trying to add Discord as auth provider, but when I try to save, I got this error It's not only when I add discord and save, but when I save the conf in general

I will use the supabase as self-hosted ... Does supabase storage feature will use my local machine as the storage provider?

why is magic link not working>

is it possible to redirect to the dashboard after logged in with a Provider like discord for example? instead of showing the login page again

ts
  const { data, error } = await supabase
        .from('hiking')
        .insert([
        { name: _data.name },
        { description: _data.description },
        { image: _data.image },
        { location: _data.location },
        { starting_point: _data.starting_point },
        { duration: _data.duration },
        { altitude: _data.altitude },
        { tip: _data.tip },
    
    ])`

it give me error 400 and they the columns altitude

json
{
    "message": "column \"altitude\" of relation \"hiking\" does not exist",
    "code": "42703",
    "details": null,
    "hint": null
}``

Hey Supabase Team, I'm not sure what happened but I stopped being able to connect to my database (either via Postico, curl, or my ORM which is Prisma). I am getting the following message that the DB Server is unreachable:

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

guys, is there any possibility to put the auth.users table for public? and add new fields in the table?

hey not sure if i understand it correctly from the Docs.. Does the Bearer Key need to be the same as the apikey in the Headers? Or is the apikey always the anon key and the Bearer key the JWT of the specific user that does the request?

Hey guys, is there any way to inform a URL of the mail template instead of the string? I know i can do it on the self host version. It would be perfect to keep all my environments (prod, staging, dev) in sync

is there a way to allow everyone to read data from a bucket, but no let them see all rows? for example, I allow them to look for an specific row by searching by id, but not let them list all rows

Hello I have a project in app.supabase.com that started with site url http://localhost:3000 and work good, but now I change it to http://localhost:3030 and oauth2 redirect always sent me to old site url http://localhost:3000, and this obvious not work. The question why I keep change it and changes not apply? Thanks in advance

why cant I request to my profiles table?

Hi all...trying to get login with google to redirect to the right place: My site url is set to my deployed site, and I have an additional redirect for my localhost after I make my auth request, something like: https://myid.supabase.co/auth/v1/authorize?provider=google&redirect_to=http%3A%2F%2Flocalhost%3A5003 I get taken back to the my deployed url...it's ignoring the redirect_to

Hello @1337! 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.

Hi, I'm trying to update a row on my table through and I keep getting 404 errors, anyone experienced the same?

My selfhosted instance of Supabase postgres is using 80GB in logs?

Looks like I'm not able to create more than 100k entries in table. Is there any limitations?

I need to pull ALL available data at once. What's best way to avoid lenght limit for specific query?

Experiencing a big lag in realtime updates - I'm updating a table with stock prices every few hundred milliseconds and expecting Supabase to relay realtime updates to the UI. The table has over 2000 rows with RLS not enabled and no policy. Currently, I'm on the free tier with 65% CPU and 40% memory usage. Do I need to upgrade or is it Supabase realtime can't guarantee near/ realtime updates with many rows? Thanks

Hi, what's the best way to preserve query parameters when logging someone in via the Goole OAuth provider?

Hello @maiikol1192! 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 am trying to understand the use of the storage with api, and here it asks me for authorization, I have entered the key that the project gives me but I can not make the request, I do not know if someone could give me a little help.

Hello! I am using discord auth in my app, and I'm trying to retrieve username and avatar url. I can see in my network tab that the data is returned during the auth process, but I don't know how to access it from the client-side. User clicks login ->

ts
const data = await supabaseAdmin.auth.signIn(
    {
      provider: "discord",
    },
    {
      redirectTo: `${SERVER_URL}/oauth/callback`,
      scopes: "identify email guilds",
    }
  );

data

returned before auth confirmed on discords portal as:

json
{
  provider: 'discord',
  url: 'https://{supabase_db_id}.supabase.co/auth/v1/authorize?provider=discord&redirect_to=http%3A%2F%2Flocalhost%3A3000%2Foauth%2Fcallback&scopes=identify%20email%20guilds',        
  data: null,
  session: null,
  user: null,
  error: null
}

That redirects me to

http://localhost:3000/games#access_token=...&refresh_token=...&token_type=bearer

Hey! Can we get a foreign table data with realtime table ?

Does anyone know if it's possible to do nested writes using the supabase sdk, similar to how you'd do it with Prisma?

👋 Hello! I am very much enjoying Supabase, but wondering if anyone has any performance tips for the following use case... I am retrieving data across two tables with a foreign key relationship as follows:

supabase.from('events').select('id, event_distances(distance)')

where the

event_distances

table has a column

event_id

which corresponds to the primary key of the

events

table, with a foreign key relationship between them. It works just fine and gives me the correct results, but it is ~really~ slow (~25 secs/query with just a couple of thousand entries in both tables)... on the postgres side it is being executed as

COALESCE((SELECT JSON_AGG(...

. I can write an essentially equivalent direct SQL query that completes in ~300ms (null-handling is ever so slightly different), so I am guessing there must be some way to adjust the

select()

for better performance? I couldn't find much in the docs discussing query performance so any assistance greatly appreciated, thanks!

Hi, is there a way i could access auth() inside a view or function and check if auth().role = 'authenticated'? only authenticated users can view value from column A and if column B is "special value". if column b is "not special value" anyone can access it

Hi! I'm working with NextJS + Supabase. I need to fetch the same data on a lot of pages. for example, country

name

and

id

from the

countries

table. I'm using getServerSideProps or getStaticProps (as appropriate) for this. Wanted to check if it's possible to fetch the data in one location and use it in multiple pages?