(CPU)

Even though I don't do anything. I've inserted around 70 records with big JSONB. So maybe there is something going on in the background

Just removed the json column, and now data loads fine

any @User members about?

just trying to create a new project and it's been hanging for nearly ten mins now

it's alive! 🎉

yeah, our infra is slightly clogged up due to some upgrades we are doing internally..so new projects might be delayed a bit!

yes clogged up seems to be accurate - everything is coming along slowly but surely

existing projects should be fine though

for others, if your existing project is stuck, delete it and please launch again or reach out to support@supabase.io (any issues with our hosted offering reach out here)

are nested queries possible with the supabase js client?

Yes

is it possible to insert a row with just one call without the need to use “remote procedure call” when you need to fetch the right foreign key id first ? I have multiple foreign key so it will mean one additional call for each fk.

Out of the blue i'm getting this error, whllst it's working fine before. Any idea how I should fix this? I'm using autogenerated uuid v4 for my primary key

code: "23505"
details: null
hint: null
message: "duplicate key value violates unique constraint \"watchlists_pkey\""

Or should you avoid using

uuid_generate_v4()

as your primary key? And just count normally

Insert into multiple tables with one query

What exactly should you do when your JWT has expired? How do you go about fetching a new one? EDIT: There's an undocumented method called refreshAccessToken, but how would I go about detecting that my current JWT has expired, so i can refresh my JWT silently?

Recommended reading on having multiple 0Auth logins that point to the same user if they have the same email?

Refresh token

is there a prisma connectOrCreate alternative in the js client?

I subscribed to a table, inside a Vuex module. I'm using SSR but it seems like no changes are being received. s there something about SSR and the

.subscribe()

method I'm missing? I'm kinda new to this. Thanks!

You need to enable subscribe for that specific table from supabase ui

I think is under the authentication Tab or something

1. Go to the "Database" section. 2. Click on "Replication" in the sidebar. 3. Control which database events are sent by toggling the Insert/Update/Delete toggles. 4. Control which tables broadcast changes by clicking into the "Source" and toggling the tables.

I'm working on a project that includes account creation with SMS and a password. But if the users forget their password in the future, how do they reset it? I'm not seeing a function that can be called to send an SMS password reset code or something.

From what I understand, SMS doesn't have password authentication. When the user logs in with a phone number, they'll be sent an SMS with a code that they use to authenticate.

@User From this link: https://supabase.io/docs/guides/auth/auth-twilio - Auth flow can be set up to include both phone number and a password. The first time the user logs in it sends the OTP message. In future logins, the OTP code will not be necessary and the phone number/password will suffice. But the scenario where the user forgets this password, there seems to be no way currently to reset it.

Phone Auth

Has anyone successfully used Supabase w/ Deno? I'm using Deno Deploy for API endpoints and would like to be able to make use of the Supabase client library with that. Edit: just ended up using the REST api with fetch()

I have a question regarding authentification with supabase goTrue. I need to support a third party provider which offers oAuth2 and OpenID connect. Unfortunately it is not yet directly supported by supabase. What do I need to do to integrate an unsupported auth provider in my supabase project? Firebase does support a general oAuth2 authentication flow but I would prefer not to go back to Firebase. Related github issue (not by me): https://github.com/supabase/gotrue/issues/159