https://supabase.com/ logo
Join Discord
Powered by
# help
  • r

    rudolfbono

    01/10/2022, 7:23 AM
    Hello! My Supabase organization has the wrong email address (it's using my secondary github email rather than primary). Is there a way to change this? I want my Supabase organization email to be my primary github email.
  • c

    CODeR

    01/10/2022, 8:05 AM
    hey folks, I'm facing an issue with auth. when I login with google provider it logs in and redirect to localhost again but problem is after redirecting back to localhost I see login page again rather than component I am using for already logged users.
  • c

    CODeR

    01/10/2022, 8:06 AM
    code
    Copy code
    js
    const App = () => {
      const user = supabase.auth.user();
    
      if (!user)
        return (
          <Routes>
            <Route path="/" element={<LogIn />} />
            <Route path="signup" element={<SignUp />} />
          </Routes>
        );
      else if (user) return <RootApp />;
      else return <p>loading</p>;
    };
  • c

    CODeR

    01/10/2022, 8:10 AM
    @User
  • t

    TremalJack

    01/10/2022, 8:46 AM
    Hello guys I made a new bug ticket about apply a custom JWT - ANON KEY - SERVICE KEY https://github.com/supabase/supabase/issues/4879 somobody had same issue or know how to fix?
  • s

    silentworks

    01/10/2022, 9:21 AM
    Please don't @ the team, if you asked a question here they are all a part of this channel so they can see it.
  • o

    octalpixel

    01/10/2022, 10:15 AM
    Is possible to force reset a password without going through and email flow ?
    s
    • 2
    • 8
  • g

    grem

    01/10/2022, 10:32 AM
    Hi! Really enjoying Supabase sofar. Especially with in conjuction with
    react-query
    and creating re-usable hooks for queries & mutations. Keeps stuff clean! I was curious however, type generation? Would something like... Defining models in
    prisma
    schema and pushing that towards the supabase DB instance to get some typings (and slightly more comfortable then raw sql creation I guess) work?
    w
    • 2
    • 1
  • d

    Daniel_pttb

    01/10/2022, 11:30 AM
    Hey there! Bit of a newbie question here, please don't mind me. I'm using an external service to sync Airtable to a postgres hosted on Supabase. The service creates its own user (let's call it "sync_user"), grants it a set of permissions, and does the writes to the Supabase postgres. However, I seem to be encountering issues on two fronts: 1) Replication: Realtime API does not seem to work with tables created by "sync_user". Oddly enough, when table is created by "supabase_admin" then ownership is transferred to "sync_user", realtime API still works 2) Auth API seems to break sync due to permissions: Everything was going fine, until we started to create a user on Auth API. Doing this seemed to break the sync by creating some permissions issue on "sync_user" Would someone be able to help us out here? Would there happen to be some sort of paid support? We'll be happy to have someone help us figure this out
  • i

    imtiaz

    01/10/2022, 2:05 PM
    is it possible to use RLS to prevent certain columns in a table from being visible publicly, while the other columns can be selected?
  • z

    Zyrto

    01/10/2022, 2:14 PM
    You can define access on columns using Postgres
  • z

    Zyrto

    01/10/2022, 2:14 PM
    https://www.postgresql.org/docs/9.5/ddl-rowsecurity.html
    i
    g
    • 3
    • 2
  • s

    Stuart

    01/10/2022, 2:23 PM
    if I am using supabase-js and I use the .insert method on a query, is that parametrised and safe from injection?
    s
    • 2
    • 2
  • i

    imtiaz

    01/10/2022, 2:47 PM
    postgres RLS allow access to specific columns
  • v

    Village

    01/10/2022, 2:49 PM
    Hello, I'm having some trouble running Supabase on ARM. I'm running Ubuntu 20.04LTS on aarch64 and when I run the docker-compose only half the containers launch and stay up, the rest continue to restart cycle with
    standard_init_linux.go:228: exec user process caused: exec format error
    spamming my logs output. According to Google, this is due to platform issues but all the containers have builds for linux/arm64 (which is apparently the same as aarch64) on Docker Hub. Any help or ideas?
  • s

    Scott P

    01/10/2022, 2:54 PM
    Parameterised queries
  • d

    Daveo

    01/10/2022, 4:06 PM
    Is there an ETA on when functions will be released?
  • m

    millu

    01/10/2022, 4:28 PM
    Is there something called Column Level Security. I have some fields that shouldn't be updatable by the user
  • j

    jensen

    01/10/2022, 4:37 PM
    no, either need to split tables, use views, or make an rpc
  • m

    Mubo

    01/10/2022, 6:29 PM
    Hi there. How do I use transactions in supabase ?
  • g

    garyaustin

    01/10/2022, 8:04 PM
    You'll need to use rpc and a stored procedure.
  • m

    Mubo

    01/10/2022, 8:06 PM
    Could you give me an example of this rpc function ?
    g
    • 2
    • 4
  • k

    Kerosz

    01/10/2022, 8:50 PM
    hey guys can anyone point me to what is the function name for the
    pg_hashids
    extension ? I've tried
    hash_encode
    and
    id_encode
    and it doesn't seem to work
  • g

    garyaustin

    01/10/2022, 8:56 PM
    Unless you modified your search_path, you'll need extensions.function_name.
  • k

    Kerosz

    01/10/2022, 8:59 PM
    😅
    extensions.hash_encode
    seems to work, thanks @User
  • d

    dayvista

    01/11/2022, 3:05 AM
    When a user confirms their account by following the email confirmation link, supabase automatically signs the user in and creates a session in localstorage. Is there a way to disable this behavior?
  • d

    dayvista

    01/11/2022, 3:34 AM
    Found it out - I had to pass
    detectSessionInUrl: false
    while initializing the client (I'm handling sessions manually)
  • m

    MaySoMusician

    01/11/2022, 5:23 AM
    Is there the way to install the postgres extensions not available so far in your extensions page, e.g. pgroonga?
  • j

    jensen

    01/11/2022, 5:31 AM
    I've only been able to do this with a self-hosted version.
  • c

    cyner

    01/11/2022, 6:31 AM
    Hello 👋. I'm trying self-hosted Supabase (basically default docker-compose.yml with sample .env), but when I signup, I will get a confirmation email with a link without
    GOTRUE_SITE_URL
    prefix, just stuff behind the
    /
    portion. Any ideas?
1...191192193...316Latest