Supabase #help

Kosh

08/08/2021, 8:56 PM

truncate auth.users cascade; if your tables has a foreign key on users table and have a cascade delete, then that's all u have to do :)

loser78

08/08/2021, 10:23 PM

Did adding additional redirect URLs work?

loser78

08/08/2021, 10:40 PM

hey guys, so I managed to set up Github OAuth and Google OAuth, but whenever I test it on localhost:3000, log in, and let it redirect back it'll redirect to localhost:3000/# instead, AND supabase.auth().user is null. But if I reload the page on localhost:3000/#, I'll be logged in. How do I fix this behavior? I expect it to just redirect back to localhost:3000, without the "#", and without me having to reload. Any help is appreciated : )

loser78

08/08/2021, 10:46 PM

An additional question is, if I want to store the user info in the database table, when should I do it? Should I do it after the line

let { user, error } = await supabase.auth.signIn(...)

? It'd seem natural except, the login triggers a redirect and so I'm not sure if that terminates any code I put afterwards. So should I instead always duplicate check it when I read the user variable i.e.

let user = await supabase.auth.user()

and then see if it exists in the USER TABLE, then add it if it doesn't? Seems ideal if I could just do the first option

acpatrice

08/08/2021, 11:05 PM

I believe it's recommended to use a public.user table rather than add content to the auth's user record. as far as when to trigger events, one option would be to use a function trigger.

loser78

08/08/2021, 11:27 PM

For the first part, it seems using

onAuthStateChanged

fixes it, although I don't know why it still redirects to "#"

loser78

08/08/2021, 11:28 PM

And yes I will indeed create a mirror doc separately in a database, just want to know the best timing to do so - I might consider using a function trigger (though I'm leaning towards doing a simple if else statement on the client side : )

Dhaiwat10

08/09/2021, 12:29 AM

May I get the

Contributor

role pls? (My Github is Dhaiwat10, linked to my Discord profile & my discord username is mentioned in my Github profile readme 🙃)

user

08/09/2021, 1:54 AM

Hello everyone! Using the JS library, I've been trying to subscribe to a table, only listening to rows where a column is

null

, but could not manage to make it work. Tried things like (works without the filter):

Copy code

javascript
supabase
    .from("posts:parent_uuid.is.null")
    .on(...)
    .subscribe()

Any hints on what is the correct way to do it?

nicholaschiang

08/09/2021, 2:16 AM

Is there anyone here who can help me update this

user_tag

enum that is being used in the

tags

array column?

Copy code

pgsql
-- The enum I want to update:
create type user_tag as enum ('meeting', 'tutor', 'tutee', 'parent');
-- The table the enum is being used in:
create table users (
  tags: user_tag[] not null
);

GingerMonkeyKing

08/09/2021, 2:42 AM

Hello everyone, i was wondering if it's possible to filter inside the query when selecting nested ?

GingerMonkeyKing

08/09/2021, 2:42 AM

Copy code

const {data, error} = await supabase
        .from("scholars")
        .select(`
        *,
        daily_slp:scholar_id ( amount,amount_start,amount_end, date )`)

GingerMonkeyKing

08/09/2021, 2:43 AM

Here in the daily_slp i'm wondering if it's possible to get only the 2 first items of the array? Like sorting and limiting it.

knight

08/09/2021, 3:05 AM

hi all, need some help here, I m trying to query the object storage with API by doing the basic GET /bucket but getting no route match error, is that I can't query it with the service API key ?

xeon06

08/09/2021, 8:32 AM

Hey folks! Any documentation on

generateLink

? Would like to generate internationalized magic link emails

Strift

08/09/2021, 9:49 AM

Any different between @LetMeKnow and @SpreadTheWord roles? Seems like a duplicate (see #867322586915799041)

copple

08/09/2021, 10:36 AM

Just updated the text - basically

LetMeKnow

is for big events,

SpreadTheWord

is when we post on social media (so that you can help amplify)

Kosh

08/09/2021, 11:33 AM

Filter nesting

Mohamed Osman

08/09/2021, 12:49 PM

Hi guys I need support

silentworks

08/09/2021, 12:58 PM

Please be specific with what you need support with and not just I need support.

Mohamed Osman

08/09/2021, 12:59 PM

I'm paying customer and I need My upload size increased

Mohamed Osman

08/09/2021, 1:01 PM

@silentworks help if you can or redirect me to someone who can

silentworks

08/09/2021, 1:01 PM

@User you can make that request from inside the dashboard using the feedback widget or sending an email to beta@supabase.io

Mohamed Osman

08/09/2021, 1:02 PM

I've tried all of that

Mohamed Osman

08/09/2021, 1:02 PM

And I'm still waiting

enricenrich

08/09/2021, 2:57 PM

Is it possible to update (not replace) multiple rows with one API request? 🤔

TechmandanCZ

08/09/2021, 3:21 PM

Does POSTGREST check if the user ID from JWT exists? Or can I just generate JWT token (signed with the same JWT secret Auth signs it with) with arbitrary ID (taken outside of supabase) and use that? I'd like to manage user accounts outside of supabase and generate tokens only for settings and files (so users can manage only their own stuff)

Steve

08/09/2021, 3:32 PM

Steve

08/09/2021, 3:34 PM

user

08/09/2021, 4:16 PM

Hey guys - question...is it possible to change a table's id type?