https://supabase.com/ logo
Join Discord
Powered by
# help
  • t
    i tried adding PostgrestResponse but it needs an argument.... am I on the right track?
  • s
    The generic argument is whatever interface you define as part of 
    .from
    . The structure of the other parameters returned from the query are known - e.g. 
    error
    will have 
    message
    and I think 
    code
    properties.
  • t
    I already defined interface ,,, used it from definitions
  • t
    I just can't understand how to pass anything to this postgrestresponse type in usestate
  • s
    const [boards, setBoards] = useState<PostgrestResponse<definitions['boards']> | null>(null)
  • t
    is possible set the user "confirmed" without send the email? if I use the api createUser he set in waiting_confirmation, always with the value AUTOCONFIRM into .env of docker
    s
    • 2
    • 2
  • t
    Im not founding nothing about how do it and inserting manually the current date into auth.users.email_confirmed_at not work
  • t
    I setted an STMP server as well to test email confirmation, but pressing the magick link from email not work in localhost
  • t
    didn't help.. 
    Argument of type 'PostgrestResponse<{ id: number; user_id: string; title?: string; description?: string; isComplete?: boolean; insertedat: string; brd_labels?: string; background?: string; }>' is not assignable to parameter of type 'SetStateAction<{ id: number; user_id: string; title?: string; description?: string; isComplete?: boolean; insertedat: string; brd_labels?: string; background?: string; }>'.
  • m
    Hey guys, I hope you can help me. I'm unable to find a button to add foreign key relationship (cloud hosted). Am I blind? On some screenshots its exactly at the same position where it shows me now the RLS option.
  • m
    Oh found out the foreign key relation only appears when I go to database -> tables and edit a single column. Wow this is hard to find when you have so many other ways to add/edit columns...
  • a
    Hey all! I’m wondering if anybody has set up any hierarchical data structures in Supabase? Working on a project that requires it and would love to see how others have implemented this for reference.
  • d
    Say more about what you mean by hierarchical data?
  • a
    So for example, a folder with sub folders. Each folder may have ONE parent, but could have MANY children. I want all children of a parent to inherit the row level policies of the parent
    s
    • 2
    • 1
  • t
    Hey everyone! I'm reasonably new to Postgres + supabase. I'm wondering if there's an easy way to assign a role other than "authenticated" to a user either on creation, or using the GUI. I see all the roles listed under "Database / Roles" in the GUI but whenever I call the supabase signUp function the role is automatically assigned to "authenticated" and I see no way of assigning an alternate role in the API Reference. If anyone could point me to the appropriate documentation or provide a solution that would be great! Thanks
    s
    • 2
    • 4
  • s
    I just set up Google Authentication for the first time, and I noticed that the consent screen says "to continue to qfyefwqfwefacjf.supabase.co" instead of my site URL. I can imagine this could be disorienting for users. Is there any solution for this problem?
  • g
    There are several discussions on this: here is one of the more detailed: https://github.com/supabase/supabase/discussions/2925#discussioncomment-1945427
  • s
    Thanks!
  • a
    how to do ilike or textSearch between multiple columns. I want to search if a text exists in either of 3 columns. I tried following but it does not seem to work: 
    query.ilike('columnOne|columnTwo|columnThree', '%' + searchTerm + '%')
    s
    y
    • 3
    • 6
  • s
    Hierarchical structure in a database
  • s
    Searching multiple columns
  • m
    my Facebook login is reporting the callback url not working and I'm getting:
    Copy code
    {
  "code": 400,
  "msg": "OAuth state parameter missing"
}
  • m
    this is the 
    https://<project-ref>.supabase.co/auth/v1/callback
    url as described on the tutorial (it was working for several days, the alert came today)
  • s
    Hi, I'm working on a schema migration script between that is supposed to update a hosted supabase db instance. The idea is to spin up an empty db with the target schema by running: 1. supabase/postgres:latest via docker 2. apply the 4 init scripts 3. run my own schema.sql file 4. run migra to generate a migration script My problem is this: The migration script includes a bunch of SQL dealing with supabase tables like storage and realtime, meaning my local instance is more "up to date" than my hosted version. How should I approach this? Is it safe to apply the changes, or do I need to reach out to the supabase team to upgrade my hosted db?
  • y
    Chaining ilike on foreign tables + potential issues with or()
    s
    • 2
    • 5
  • s
    query from datagrip
  • j
    Hi all, I'm getting started using Supabase within my local development environment but I'm unable to access the 'Storage' page in Supabase studio. This is accessible at 
    app.supabase.io/project/default/storage/buckets
    when using the hosted version. However, navigating to this page locally redirects me to the project home page. I have tried running Supabase using the CLI and also using Docker compose, both with the same result. Is there a way to access this page while running Supabase locally or is this only for the hosted version?
    g
    • 2
    • 2
  • g
    storage page with studio locally
  • d
    I'm trying to delete my user. I go to auth.users and delete my row. But when I try to sign in with username and password I'm told that the credentials are invalid instead of null
    g
    • 2
    • 3
  • a
    Is it possible to use the Supabase admin dashboard table editor “impersonating” an actual user? I wanna test some triggers and such that use auth.uid() but I keep getting errors when adding new rows. It’s like there is no authenticated user set or something
1...235236237...316Latest