https://supabase.com/ logo
Join Discord
Powered by
# help-and-questions
  • auth v1 user 500 Internal Server Error
    a

    Aaron Me

    09/08/2022, 1:42 AM
    when requesting [See Screenshot] I am getting an Internal Server Error, any ideas?
    g
    • 2
    • 7
  • Running Edge Functions at set interval
    s

    stu

    09/08/2022, 1:47 AM
    I was looking through the Edge Functions docs, but didn't see anything related to cron jobs. Is it possible to run an Edge function at certain intervals? For example, run a function every hour?
    s
    • 2
    • 3
  • Using OAuth (like FB) is .Net MAUI
    v

    Vincent Bernier

    09/08/2022, 1:58 AM
    Hello there! 👋 I'm looking for some examples of Supabase in a MAUI (or Xamarin) app to make my auth working. I tried to use the csharp community library, but the section on the 3rd Party Authentication is very vague... Everything is working fine with the email/password signin. - Does anyone have done this? - Does anyone have tried to use an "WebAuthenticator" in C# with Supabase? - What "supabase.auth.signIn({ provider: 'facebook', })" is really doing behind the scene? Also, if I'm developping an MAUI app without any backend, what would be the "Redirect_URL" in the Auth Section of Supabase?
    • 1
    • 4
  • Self Hosted issues. Bad Gateway, DB connecting issues.
    r

    rgfx

    09/08/2022, 2:56 AM
    Hello, Using Docker to install, all systems are green. I am also using traefik. SSL seems to be working. But am getting a Bad Gateway on the subdomain. supabase.app.app On the IP its working, well loaded. But it sits at "Connecting to Default Project" I am able to call the api via the IP. Do I have to change some ports in the yml file? Do you know what I should look into? Can you lead me into another direction not sure where to go next. Thank you.
    • 1
    • 1
  • Query with two inner joins Flutter
    o

    ortegaxc

    09/08/2022, 3:39 AM
    Hello! Does anyone know how to perform this query in flutter?
    s
    h
    • 3
    • 4
  • Rows not showing after deletion of column
    l

    LUNA

    09/08/2022, 4:28 AM
    I think there might be a bug with the sort persisting after the deletion of the column.
    • 1
    • 1
  • Can't delete storage folders
    w

    whiskeywizard

    09/08/2022, 7:16 AM
    Is this a bug or am I doing something wrong? When I delete a Storage folder in the base directory via Supabase UI, it deletes the contains files but not the folder itself.
    g
    • 2
    • 1
  • Permission denied on db push for schema private on GitHub Action
    n

    NARCISO

    09/11/2022, 12:25 PM
    Else is there a way to
    psql
    into the Postgres database with the
    supabase_admin
    ? So that eventually I could run
    ALTER USER postgres SUPERUSER
    before the migrations
  • Is it safe for me to update and delete data on the frontend with supabase?
    c

    Chriss

    09/08/2022, 9:08 AM
    Is it safe for me to update and delete data on the frontend with supabase? I feel like there is a posibility the user somehow changes the update query I have done and makes the data not authentic. Any help will be appreciated!
    n
    • 2
    • 18
  • How to conditionally filter?
    d

    Deleted User

    09/08/2022, 10:00 AM
    I have something like this: When you look at .match(), I am matching two variables. I want match to execute whenever the variables are not empty strings. In this case they are empty and it throws an error.
    n
    g
    u
    • 4
    • 8
  • Is there a good Auth and Auth Providers vanilla Javascript Documentation?
    s

    Shecky

    09/08/2022, 10:34 AM
    So a few werks ago i implementet Supabase Auth in my project and i had my difficultys understanding it because the official docs just providing like 5 lines of code for registration. I found online an example that helped me understand and build it. Today i want to implement the Google provider and again i did everything that the docs say implementez the 3 lines of google signin code and it works till google sends me back to my application. The User Account is created but nothing else works. Redirect is not redirecting me and after signing up with google i wont get signed in automaticly. So i tried to search for an example on how to do this but there is nothing. So my question is, why are the docs so badly made? There is so much information not in the docs that is needed and how do i fix my auth problem?
    s
    g
    m
    • 4
    • 16
  • How much resources does a self-hosted supabase instance take?
    c

    Chriss

    09/08/2022, 11:24 AM
    Hi, I am looking into transitioning some commerical projects on the self-hosted version of supabase and was wondering if it will be ok in the resource department. If anyone has useful intel to share I would appreciate it very much!
    o
    • 2
    • 1
  • Documentation for createClient doesn't match implementation? Bug in GoTrueClient.js?
    d

    davidmaxwaterman

    09/08/2022, 11:27 AM
    In this doc 'with additional parameters' [1] is shows options
    persistSession
    in an 'auth` object inside the options. Due to my browser environment not having localStorage, I'm trying to disable attempts to use it, so I'm setting
    persistSession
    to
    false
    . However, that doesn't stop the implementation from trying to access localStorage. Setting
    localStorage
    to null or something doesn't help either - it actually has to be set to something 'compatible', eg what I've ended up doing:
    Copy code
    const supabase = globalThis.supabase.createClient(supabase_url, supabase_key, {
      persistSession: false,
      localStorage: {
        setItem: () => {},
        getItem: () => {},
        removeItem: () => {},
        clear: () => {},
      },
    });
    Doing the same in an
    auth
    property as indicated in the docs, doesn't help, because of this line: https://github.com/supabase/gotrue-js/blob/master/src/GoTrueClient.ts#L99
    Copy code
    this.localStorage = settings.localStorage || globalThis.localStorage
    In my environment attempting to access
    globalThis.localStorage
    generates an exception:
    Copy code
    globalThis.localStorage
    Uncaught 
    Exception { name: "NS_ERROR_NOT_AVAILABLE", message: "", result: 2147746065, ...8<... }
    It seems like subsequent uses of
    this.localStorage
    are protected from being
    null
    but setting it to null in the settings doesn't have any effect (and, predictably, it isn't possible to assign
    null
    to
    globalThis.localStorage
    ), eg here:
    Copy code
    export const getItemSynchronously = (storage: SupportedStorage, key: string): any | null => {
      const value = isBrowser() && storage?.getItem(key)
    https://github.com/supabase/gotrue-js/blob/master/src/lib/helpers.ts#L62 I know my environment is somewhat unusual, but it seems like this is actually a bug (since localStorage cannot be nullish). What do you think? [1] https://supabase.com/docs/reference/javascript/next/initializing#with-additional-parameters
    s
    • 2
    • 9
  • Create a second supabase project in a self-hosted instance
    c

    Chriss

    09/08/2022, 12:08 PM
    How do I create a second supabase project in my self-hosted instance? I searched the github discussions but found no info there.
    g
    l
    • 3
    • 11
  • Is there a way to introduce new DB secret with ability to access it ?
    a

    a99111cc042b477e9f22eafe7

    09/08/2022, 12:41 PM
    Hi, Similiar to what is happening with JWT secret, I would like to have another secret which would be set and only readable by admin in Database. I want to use this secret for encrypting / decrypting data. How would I introduce this secret into DB and how would I retrieve this secret. I imagine something similiar to app.settings.custom_secret;
    g
    • 2
    • 2
  • Clone project for local dev
    l

    Ludvig

    09/08/2022, 1:22 PM
    I am logged in on the supabase cli and can see my project "testdb" hosted on supabase with
    supabase projects list
    Now, I want to clone my project hosted on supabase, so I can do local development and then be able to push changes from there, instead of loading supabases servers while testing/developing. What are the exact commands to clone the project and then getting it to run using the cli?
    e
    • 2
    • 9
  • Check whether or not supabase channel has connected?
    e

    ecrax

    09/08/2022, 1:23 PM
    Hello \:) I am a bit stuck and wanted to ask whether or not it is possible to check if a channel is subscribed and listens. I currently check this in the callback of the
    .subscribe
    method, but Insert events are only received a few seconds after the callback is triggered (and returns "SUBSCRIBED"). I am on version 2.0.0-rc.8 of the js sdk if that matters. I am also aware of "double useEffect renders" in React 18s strict mode (described here: https://github.com/supabase/realtime-js/issues/169). Thanks in advance
    g
    • 2
    • 1
  • Return related data (User_id)
    l

    lanbau

    09/08/2022, 1:28 PM
    hi i have a working piece of code.. however i'm not sure how to return the username (in another table) when i have the user_id
    Copy code
    useEffect(() => {
        if (!delayedStart) return () => null;
    
        const subscription = supabase
          .from("bids")
          .on("INSERT", (payload) => {
            // if (init) {
            console.log("message send recieved", payload);
            console.log(
              "Value of old messages:",
              bids,
              "Value of new message:",
              payload.new
            );
            setBids((b) => [...b, payload.new]);
            setDelayedStart(false);
            setTimeout(() => {
              setDelayedStart(true);
            }, 420);
            // }
          })
          .subscribe((state) => {
            console.log("DEBUG: subscribe", state);
          });
    
        return () => {
          supabase.removeSubscription(subscription);
        };
      }, [delayedStart]);
    Copy code
    amount: "12"
    case_id: 1
    created_at: "2022-09-08T13:24:48.99641+00:00"
    id: 46
    user_id: "b9d966fd-f47f-4b96-9025-55053ac6c290
    g
    • 2
    • 1
  • How to check if Signed Up or Signed In
    s

    Shecky

    09/08/2022, 1:50 PM
    On Auth provider Google how can i check if a user is first time signed up so i can implement all the data (name,profilepicture) from google in my public user table?
    n
    p
    • 3
    • 3
  • Impossible to join organization
    n

    nooz.t

    09/08/2022, 1:59 PM
    Hello, I have an issue. The admin of my company is trying to add me to the organization. Unfortunately, the link I'm receiving either ask me to log in (but doesn't make me join the organization) or is redirecting to localhost:3000. At the end, I can see the organization in my accont
    o
    • 2
    • 4
  • Confirmation Email Question
    r

    rlee128

    09/08/2022, 2:07 PM
    Is it possible to trigger a function when a confirmation email is requested to then switch the format of it?
    s
    e
    • 3
    • 5
  • Keycloak Provider - Error unable to exchange external code
    w

    W7T2A

    09/08/2022, 2:28 PM
    Hey guys, I'm currently setup keycloak for auth and tried using it with supabase auth. I've followed the instructions in docs to setup keycloak provider. I'm getting redirected as expected but when logged in I've got an error and redirect loop with error code in url: http://localhost:3000/?error=server_error&error_description=Unable+to+exchange+external+code I've double checked clientid + secret on both sides as well as callback urls. Any suggestions?
    g
    • 2
    • 6
  • Approach to testing
    h

    Haus Of Alejandro

    09/08/2022, 4:20 PM
    Hello everyone! I was wondering what would be the best approach to do TDD/testing for the API rest en Supabase?, for example; in Firebase I can use the local emulators to create some testing without actually hitting the db/functions in the back-end, that way I can run as many times as I want the testing without consuming or messing with production resources.
    c
    • 2
    • 2
  • Benefit of client-side connection vs server?
    c

    Cory

    09/08/2022, 6:59 PM
    I’m trying to connect and send data to my database. Is there a benefit to connecting to an endpoint which then uses the server to connect to the database or is it easier to just do it on the client side? I guess I am just trying to wrap my head around use case of client-side database connections vs sever side
    e
    • 2
    • 1
  • invite emails not using redirectTo parameter, defaulting to server url in supabase configuration
    a

    aaronksaunders

    09/08/2022, 7:17 PM
    Copy code
    return await supabaseAdmin.auth.api.inviteUserByEmail(
              inviteEmailAddress.trim(),
              {
                redirectTo: `${process.env.SERVER_URL}/incoming-invite/`,
                data: {
                  project: projectId,
                  organization: organizationId,
                  invitedBy,
                  role
                },
              }
            );
    i have deployed to netlify and set the SERVER_URL environment variable, but it is still using localhost
    g
    • 2
    • 4
  • Supabase with Electron
    s

    Scotty

    09/08/2022, 7:39 PM
    Has anyone used supabase with an Electron app? How was the experience? Is it much more difficult to get up and running than web? Are there any good tutorials or other tips you can recommend? Thanks!
    p
    g
    • 3
    • 3
  • How to get the caller's userID when using an RPC function
    d

    DanMossa

    09/08/2022, 8:13 PM
    Hello! I want to make an RPC function that is able to verify the caller's userID is inside of a table I have. How can I get that info from an RPC Function?
    g
    • 2
    • 5
  • Horizontal Scale Postgres?
    m

    mikeysee

    09/09/2022, 2:11 AM
    hey I have done some quick searching on this but the answers arent obvious. How easy is it to scale a Supabase postgres instance?
    h
    b
    t
    • 4
    • 3
  • Could not query the database for the schema cache. Retrying.
    h

    Hadi

    09/09/2022, 2:34 AM
    Hey there I receive this error when i call supabase from supabasejs with anon key.
    g
    • 2
    • 8
  • Better email verification flow?
    w

    whiskeywizard

    09/09/2022, 3:10 AM
    Hi, The current flow of email verification is not very user-friendly. It is: Signup with email and password -> UI tells user they have been sent a confirmation email -> User clicks confirmation email link -> User has to re-enter their email and password to login. Is it possible for the confirmation email to automatically log the user in? It should act as a magic link like almost any modern website, right? Am I doing something wrong or is this the only way? Thanks.
    h
    c
    • 3
    • 5
1...181920...230Latest