https://supabase.com/ logo
Join Discord
Powered by
# off-topic
  • s

    silentworks

    11/11/2021, 10:37 AM
    I've already directed you where to get the connection information from in a thread in this channel, you are asking for help but you aren't stating what you have tried as yet, please provide an example of what you have tried or what you are having an issue with
  • t

    Terry

    11/11/2021, 11:29 AM
    I'm confused about auth with Supabase + Next. I followed this quickstart to get going: https://supabase.io/docs/guides/with-nextjs But seems I actually want to follow this ssr w/ auth cookie approach? https://github.com/supabase/supabase/tree/master/examples/nextjs-with-supabase-auth
  • t

    Terry

    11/11/2021, 11:30 AM
    The quickstart uses a client-side effect to check for a session. I'm guessing that's not what most uses cases will use?
  • v

    VuNguyen

    11/11/2021, 12:16 PM
    u can add cookies whenever the session changed
  • v

    VuNguyen

    11/11/2021, 12:16 PM
    umm i think its called onAuthChange or something like that
  • v

    VuNguyen

    11/11/2021, 12:16 PM
    dont really remember the method name
  • v

    VuNguyen

    11/11/2021, 12:19 PM
    here it is
  • b

    Biondi Bagasta Wiko Putra

    11/11/2021, 1:33 PM
    #ASK I want to make customer registratio, but i have a problem with INSERT policies, How to make my insert policies working for public, i mean it doesn't need authenticated first just SELECT policies which is using
    Copy code
    true
    like this :
    Copy code
    CREATE POLICY "INSERT" ON public.customer FOR
    SELECT
      USING (true);
    But when i used
    Copy code
    true
    on my INSERT policies like this :
    Copy code
    ALTER POLICY "INSERT" ON public.customer WITH CHECK (true);
    I got this error :
    Copy code
    message: "new row violates row-level security policy for table \"customer\""
  • c

    Christopher

    11/11/2021, 4:06 PM
    If I have a VPS on AWS, does downloading media from object storage to the VPS count as outbound network traffic?
  • t

    Terry

    11/11/2021, 7:20 PM
    https://supabase.io/docs/reference/javascript/select#query-foreign-tables
  • t

    Terry

    11/11/2021, 7:21 PM
    This example doesn't really make sense to me
  • t

    Terry

    11/11/2021, 7:21 PM
    Copy code
    const { data, error } = await supabase
      .from('countries')
      .select(`
        name,
        cities (
          name
        )
      `)
    s
    • 2
    • 3
  • t

    Terry

    11/11/2021, 7:21 PM
    What is this actually querying? It's going to the companies table first, and from there?
  • s

    silentworks

    11/11/2021, 8:00 PM
    What is this query doing
  • t

    Terry

    11/11/2021, 8:14 PM
    I can't seem to figure out RLS. I can add rows as the current user no problem. But I want to have an account that's an Admin user, who can act on other rows.
    s
    • 2
    • 4
  • j

    jon.m

    11/11/2021, 11:54 PM
    Is there a way to grab additional information on sign up and add it to the public users table? Ideally, a full name field?
  • o

    Olyno

    11/12/2021, 12:17 AM
    Hi I think your question should be placed in #843999948717555735 or #869405720934744086, you gonna get more help there :p
  • p

    patrik

    11/12/2021, 10:29 AM
    @User any news when new version of supabase ui will be coming with theming?
  • t

    Terry

    11/12/2021, 1:34 PM
    Any thoughts on how to store users? I've got two user roles and I'm paralyzed about how to store their data. Should I put all users in one table or should I have a table for each role?
    s
    • 2
    • 4
  • t

    Terry

    11/12/2021, 1:38 PM
    Here's my question basically! https://dba.stackexchange.com/questions/75792/multiple-user-types-db-design-advice
  • t

    Terry

    11/12/2021, 1:38 PM
    The accepted answer is to have separate tables for each role.
  • t

    Terry

    11/12/2021, 1:39 PM
    That seem sensible? Just don't want to get too far and have to re-do 😄
  • t

    Terry

    11/12/2021, 1:44 PM
    And a separate workflow question. How do people manage their databases? At first, I was doing everything with the gui, but I've already had to recreate tables a bunch of times, so now I'm switching over to creating tables with sql. I'm storing a .sql file locally so I can just update it as I need tables. Are people typically just doing this and entering those sql commands into Supabase? Or is setting up something like Prisma more common?
  • s

    silentworks

    11/12/2021, 2:48 PM
    How best to store user data with different roles
  • n

    naegelin

    11/12/2021, 5:59 PM
    is there a best practice for setting up dynamic supabase environments for testing/qa/ etc ?
  • n

    naegelin

    11/12/2021, 6:00 PM
    ideally one could 'clone' a supabase project
  • m

    Marky

    11/12/2021, 7:23 PM
    Is there any chance to get our instance fixed, we just launched a product and we are completely dead in the water, all the testing worked fine with same load. Now we can't do anything.
  • h

    HarryET

    11/12/2021, 7:46 PM
    Can't do anything in what sense?
  • m

    Marky

    11/12/2021, 7:47 PM
    I am uploading 2KB images, and every 10 images the system freezes for 5-15 minutes, and it all goes off line
    e
    • 2
    • 25
  • m

    Marky

    11/12/2021, 7:47 PM
    it's been happening for the last few hours
1...132133134...392Latest