With any jwt library like passport

You just need the secret key from@supabase Dashboard

It would be using gotrue too?

Can you explain a bit ehat is your usecase

So, you have another custom server?

And you eant to generate the token there and send to frontend?

So I make Twitch extensions. Twitch extension front-end are hosted by Twitch and displayed in iframes When they load they provide a JWT token to the user that can be validated using a secret key, this JWT contains the userId. So the idea is to call an endpoint with this JWT token. The endpoint validates the token with the secret Twitch provided, if it's valid it either create the user in supabase (without an email), or return a supabase token created using supabase secret Then the front-end can auth to supabase and use it

Got it

Im not sure you can create it without the email

Thats the tricky part

I dont know a way. Maybe someone else knows if this is possible

You can for sure generate the tokens yourself

Eith jwt and supabase secret

But i dont think you can add the user

Without email

Ho I see 🙂 firestore allow

anonymous

auth, so that's what I used but I'll look around or submit fetaure requests 😄

Supabase keeps throwing a 500 error when I try to change the primary key column's data type.

Anyone experience this?

I'm based in the Central time zone in the US. Which one of these should I create my supabase project in?

Is Canada the okay region to go with here? Idk how that might work with most of my requests coming from the US

I get a toast that shows up in the UI that says,

Is it possible to make supabase use

https

instead of

http

on docker?

zones

@User @User Thanks for the help! I'll give that a shot 🙂

hey! Apologies if this isn't an appropriate channel. What's the best resource to learn postgres? I already know SQL but would like to learn about migrations, best practices for table design, migrations, etc 🙂

Should supabase be used to make graphql api's? I'm wondering how my Next app should work, right now I use supabase inside api routes to do queries/mutations, but fetching it on the client with SWR is a little unintuitive imo. Wondering what's the best way to update data on the client side with supabase, maybe I just drop in supabase and skip SWR altogether?

How to insert data to multiple tables? Hi Im trying to add ID to the related tables, since I have multiple tables, I need to insert/upsert into multiple tables. I don't know if this is the right pattern. Let me know ie user has one to one relationship profile user has one to many relationship to address

Using a Postgres trigger (https://www.postgresqltutorial.com/postgresql-triggers/) might work. For example, when you insert data to 1 table, the trigger will run and insert data on another table. Alternatively, a Postgres function (https://www.postgresqltutorial.com/postgresql-create-function/) could be used. You'd then call the function with the

.rpc()

method, passing the function name and parameters.

@User How to call function in runtime?

How to right function here?