Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

e.g.```ts
supabase.auth.signin({
email: "email@example.com"
}, {
redirectTo: "aaaaaaaa.com"
})
```

I see, I'll try it out! Thanks 🙂
Also, what does the `Additional Redirect URLs` is used for? In the Auth -> Settings?

If you read under it there is a description.

If the EXACT URL isn't there it won't work in the redirectTo

How would you handle an in-app password reset without having to send a password reset link to a user? I'm referring to a user that has logged in. Typically, you'd want to know their current password as a way of authorizing a reset

<@281314080923320321> are you still waiting on guidance from the Supabase team to work on the TikTok OAuth provider?

<@&844001800214020128> <@!414972572732489748> there was a question concerning how to handle social OAuth providers that do not include emails, such as TikTok.

Its a filed github issue and will be sorted by the relevant people. You have dragged 20+ extra people into this whom didn't need to be involved

My apologies, the issue has been out there for a while so I was just drawing visibility

It was not needed. The relevant people already know about it

can anyone help me remove duplicated rows?

Are you looking to remove them from the database or from your query?

Here are some options for you https://www.postgresqltutorial.com/how-to-delete-duplicate-rows-in-postgresql/

umm when i'm using upsert, how can I avoid duplicate?

like can i use multiple columns in `onConflict`?

I'm having some trouble with .neq() in my nodejs server, I'm trying to find all users except for a certain user type and I have the query set up with a couple of paramters in there, like a .eq(), and a .gt(), is there a specific order that I have to input these as or am I missing something?

I doubt there is any order of queries that matter on way to database and once there Postgres will order them as it thinks best for performance.

Okay, thanks for the tip. Any idea why .neq() wouldn’t work? I have the column name in quotation marks, and the string in quotation marks separated by a comma. Is it supposed to be set up different?

If you do just that query do you get the right answer?

Also if you have nulls in the field, it will not return those either.

yes, if i do just that query i get the correct list of responses, but when I add the other 2 it doesn't seem to work

Just remember all 3 have to be have be met by some record to be returned (assuming you are chaining them and not putting them in the .or filter)

so I have the queries set up as follows: 
.eq('invitedBy', ${invitedByID in params})
.neq("userType", "partner")
.neq('dateSubscribed', 0)
if I use the  second .neq filter, It comes back correct, if I use the first .neq filter with the .eq filter, it comes back correct, but when i use all 3 it doesn't return anything

the error seems to happen when i use 2 .neq filters. is that not possible?

So if I remember my logic that would be NOT(Partner or 0) so you have to have some records that have neither set that way.  Unless you have nulls in either then it won't work right.  I've not heard of any problem with multiple .neq and postgres supports it.

ohhh i see, so it would throw errors if there are some rows with null value in those specific columns?

No it will just not include them at all.   I was working on a 10 or so optional filter part of my code today, so just stuck in two .neq for "fun" and they worked.

Okay, thank you for the tip, I’m going to try that now

So just a quick question, do you mean any null values in the row, or just in each specific column I’m querying through

phew, ok so i came here to ask if anyone has seen there data disappear in the db ui tool

Try clearing your cache, local storage and logging in again to see if that helps

thankfully it's just the ui, manually querying the data shows it actually exists

Hello Supabase community. I see generateLink being mentioned on github and even here as well but I can't seem to find (like others as well) any docs on this. Is there? I would like to use this option since the supabase password recovery emails get sent to spam for many of my users.

Unfortunately this is not documented as yet, if you are up for the task you can add it to the documentation as the Supabase website is open source

I would happily but I don't know the function or its parameters...

I found the commit on it, I will try to get it working and then try to add docs after.
(https://github.com/supabase/gotrue-js/commit/9c542595fabc6006cff4d2206fdadfe318cbd9f2)

hi, i use Supabase for a project that I coded, but my database is apparently 'restoring..'
my uptime monitor say that the problem is here since nine hours

This shouldn't take that long, please use the feedback widget to drop a message to the Supabase team about this or alternatively email them on support@supabase.io with your project id

what can cause that and is the restore process gonna end 😭

https://tenor.com/view/kermit-frog-panic-frantic-yay-gif-16814992

It's a huge part of my app so I'm super excited for it being finished 🙂

Me too 🔥 rls real-time opens up so many possibilities.

You can follow the progress on this repo https://github.com/supabase/walrus

im using this to delete duplicate rows, also delete expired rows depending on `airing_at` column by compare it to current timestamp