https://supabase.com/ logo
Join Discord
Powered by
# javascript
  • d
    hey, can someone point to me an example or reference of supabase storage api of uploading multiple files to the storage. I can upload single file but i want to upload multiple files. i can do this directly in supabase admin ui way, so i hope there is a way to do this with the api too..
  • s
    I have a form which on submission should create records in 3 tables, and in a specific sequence. Should this be done in my JS code, or should I be learning how to do stored procedures..? Or something else?
  • l
    if it's just inserting rows, you can just insert from the client (frontend js)
  • l
    supabase admin uploads each file separately. I would just loop through the files on the frontend and upload each one separately (though this is iffy if it fails halfway and can't guarantee a transaction)
  • d
    Oh, anyways thanks, i was just looking for a way to do this without the loop since the problem you mentioned exists..πŸ‘
  • s
    So it's fine to do ~3x connections per form submission?
  • s
    Insertions 2 and 3 need to happen together actually
  • j
    then triggers or stored procedures would be better for your use case
  • j
    an insert 1 triggers inserts 2 and 3
  • s
    cheers, another thing to learn 🀣
  • j
    haha it's just like the 
    handle_new_user()
    trigger function that's recommended, if you created a 
    public.users
    table
  • j
  • s
    Thanks!
  • s
    Copy code
    let { data, error } = await supabase.from("user_roles").select(`
            id, role,
            auth.users (
                email
            )
        `);
  • s
    am I unable to select from the auth schema? user_roles has a reference to auth.users
  • s
    getting an error when I am trying to do this
  • d
    Has anyone been able to get auth with a magic link working with Expo/React Native?
  • s
  • j
    Does anyone know why I am getting an array under the error property, if the WHERE clause has no match, in response to an UPDATE query via the supabasejs client? i.e. 
    supabase.from('some_table').update({some_column: 10}).match({'id': 1});
    My result is: { error: [], data: null, count: null, status: 404, statusText: 'Not Found', body: null } Not sure if this is intentional and should be handled in some particular manner, or not.
    s
    • 2
    • 7
  • j
    This makes it so the error property can be one of three things, an Array, an error Object, or null.
  • j
  • s
    Error is empty array
  • n
    Is there a way to build a query dinamically with the js client? For example, imagine we have a datatable and an input field to filter
    Copy code
    sql
let query = supabase.from('users').select('name')

if (name) query = query.filter('name', 'LIKE' `%${name}%`)
    s
    g
    s
    • 4
    • 9
  • n
    This doesnt seem to be working on my end 😦
  • g
    The docs say to call this in your UI:
    Copy code
    js
const { user, session, error } = await supabase.auth.signIn({
  provider: 'discord'
})
    so I do, and it redirects the user to discord and because of this 
    user
    , 
    session
    , and 
    error
    aren't actually returned? how am I supposted to handle auth
  • s
    @User Did you add anything to handle the returned values 
    { user, session, error}
    ? After they are redirected to discord, and they log in, it should be redirecting back to your url (or localhost)
  • m
    Hi! Is the following code example from the documentation correct?
    Copy code
    const { user, session, error } = await supabase.auth.signIn({
  provider: 'discord'
})
// my code
console.log('run!')
    When I run that function, it logs "run!" immediately and then I'm navigated away to discord.com for authentication and then I'm redirected back to my website, with the session and user data automatically set in localstorage. But I don't see how I'm supposed to get { user, session, error } directly in my JS code πŸ€” from examples seen on blog articles, it seems that the method "supabase.auth.onAuthStateChange" is used along with supabase.auth.signIn + provider
  • m
    @User lol I have the exact same problem
  • m
    my guess is that the docs are maybe inaccurate. since the user is leaving the website, there's no way to get a value back from supabase.auth.signIn
  • m
    @User seems to be having the same problem
1...161718...81Latest