https://supabase.com/ logo
Join Discord
Powered by
# help
  • a
    Copy code
    jsx
const { data, error } = await supabase
        .from("daos")
        .select()
        .eq(
          "signer_id",
          user.user_metadata != undefined ? user.user_metadata.provider_id : ""
        );
  • a
    cn someone help?
  • u
    Can we query other tables also in RLS policies?
    s
    a
    • 3
    • 3
  • b
    How do you download all the files in a bucket (say for backup, or to migrate to a new project) - I have about 100 files in a bucket - if I uses "select all" and download, it only gets about 10 files
  • a
    How do you update one cell for a particular row and column
  • a
    i want to update the location field for the row that mathes user id in users table
  • f
    how do you access the User model data property inside the confirm signup template. I can access email with {{ .Email }} but UserMetadata is an object with key value pairs. Would it be something like {{ .UserMetadata.Name }}
    Copy code
    const { user, session, error } = await supabase.auth.signUp(
  {
    email: 'example@email.com',
    password: 'example-password',
  },
  {
    data: { 
      first_name: 'John', 
      age: 27,
    }
  }
)
    Copy code
    <h2>Welcome {{ .UserMetadata }} to THHI Housing Finder</h2>
<h2>Confirm your signup</h2>

<p>Follow this link to confirm your user account:</p>
<p><a href="{{ .ConfirmationURL }}User/EmailConfirmed">Confirm your mail</a></p>
  • f
    Figured it out
  • b
    Hi there, quick one. I dont get how I could set the url for the recovery email message. I've tried to add it manually, but when doing it I dont get the params.. thanks.
  • a
    If I just wanted to use Supabase for image storage and user authentication is that possible? I'm more familiar with defining my database schema with prisma and using their ORM to interact with the DB. It's just not clear to me how the two can be connected.
  • t
    Yes a month or so ago I completed the https://supabase.com/docs/guides/with-svelte and its shows and example on how you upload your profile pic to supabase. Also I built upon this guide to make it also use twitter auth with a bit of configuration / api keys etc. I'm not familiar with prisma though it seems to be used together with https://dev.to/prisma/set-up-a-free-postgresql-database-on-supabase-to-use-with-prisma-3pk6
  • f
    Hi all! I have a repository on GitHub and my project makes use of Supabase! A person would like to help contribute to the repo - how can I safely allow access to the database so the contributor would be able to use/test locally? My database isn't anything special and I wouldn't mind it getting messed up so I invited them via email but still may be good to know in the future when I have the real database ready!
  • l
    Is there any way to access the 
    auth.identities
    table directly? The only option I seem to have found is to create a clone of it
  • s
    Hi everyone Good Morning from South Africa, is it possible to sign in (create user session) with an access token that I minted using the supabase secret? Thank you
  • k
    You can use `supabase.auth.setAuth(access_token)`: https://supabase.com/docs/reference/javascript/auth-setauth
  • k
    you can create a view with just the right data. Why do you want to access it?
  • s
    Hi, I am a frontend guy trying to create some table with references. Can anyone help me proof check and validate please?
  • s
    you should be able to, check the identities table and see if the entry is available
  • s
    @User You are a champ, it worked successfully. I am using auth0 actions to add MFA and other smart things to a SPA. Do you or @User know how I can contribute auth0 as an oauth provider. Struggling to navigate the repo 🙌
  • s
    why do you want to integrate Auth0, when supabase already have it
  • s
    Really?
  • s
    oh you want MFA, I think it's work in progress
  • k
    @User this suggests gotrue can integrate with Auth0 through the SAML provider: https://github.com/netlify/gotrue/pull/181 So that's one part of the battle
  • k
    The other part would be adding support to supabase studio (aka app.supabase.io), which lives in https://github.com/supabase/supabase, "studio" directory
  • s
    This is fascinating, the current dashboard does not allow me to add my own authserver url, clientid and redirectUrl ?
  • k
    Yeah, I would not be surprised at all if they decided to only support SAML2 in some "Enterprise 24/7" plan for "call sales for a quote" dollars 😛
  • s
    buts its open-source we shall now allow it 😆 , I want to raise a PR for an additional "custom" option as described. I am not too familiar with the codebase but very eager to put something out and see what happens
  • k
    Go for it!
  • s
    I can't seem to find any previous PRs which introduced the other providers, can you point or @User please point in some direction? 🙏
  • s
    https://github.com/supabase/gotrue-js/issues/131 this seems to be a concern in the community
1...172173174...316Latest