https://supabase.com/ logo
Join Discord
Powered by
# help
  • v
    Copy code
    (EXISTS ( SELECT books.user_id, books.id FROM books WHERE ((books.id = pages.book_id) AND (books.user_id = uid()))))
  • v
    Is what I currently have, but I need to go one level deeper
  • v
    you're right. looks like the feature request is still open https://github.com/supabase/gotrue/issues/142
  • r
    Anyone else running into issues with Supabase Auth? I'm trying to sign in and it keeps timing out for me
  • r
    Just started happening within the past few hours I think
  • m
    It worked fine to me
  • j
    working fine here.
  • r
    Ok thanks. I mean an app using Supabase Auth by the way, not the Supabase Dashboard
  • m
    Hey guys! A Little question about project structure i think. I am making an invoice app that will generate some pdfs. Im using supabase on the frontend (React app) for authentication and data storage. I want to generate some pdfs using an express app, and from React Take the jwt and sent it to express to validate it there and generate the pdf. Is it ok to do it this way? Or should i move all the supabase logic to the express server, and make the calls to my api for data storage also
    s
    • 2
    • 1
  • s
    React, Express and Supabase
  • j
    There's no way to get username and avatar_url from supabase auth via any provider (Goodle, Discord, Twitter...)?
  • n
    Hello! We are currently on the process of migrating our app from Firebase to Supabase. I am on the process of migrating the users currently. So far what I have done is export our firebase users in a json format and create a script, that walks this json files and outputs basic 
    INSERT INTO auth.users
    queries. Of course pwd are NULL and will have to be reset manually. Question is: Am I missing something? Because when I go to the users dashboard, and hit 
    Send password recovery email
    , I get an error: 
    Send password recovery failed: Database error finding user
    This is an example of the insert query that I am making
    Copy code
    sql
INSERT INTO "auth"."users" ("instance_id", "id", "aud", "role", "email", "encrypted_password", "raw_app_meta_data", "raw_user_meta_data", "is_super_admin", "created_at", "updated_at") 
VALUES ('00000000-0000-0000-0000-000000000000', 'ba917c4e-a67c-5e00-b737-0012829b9ff2', 'authenticated', 'authenticated', 'email@email.com', NULL, '{"provider": "email"}', 'null', FALSE, '2021-08-20T19:27:46.427Z', NOW());
  • n
    Migrating auth users from Firebase to Supabase
  • l
    hi m trying to upload a file to my bucket via js api, but i get this error: new row violates row-level security policy for table "objects" l added some policies to allow update/read to the bucket, but it doesn't seem to solve it. any clews?
  • a
    Question on Discord auth - if I'm building an app that I want to restrict to members of a specific Discord server, is it possible to do that as part of using Discord for auth?
  • j
    I'm getting this on email and password sing up
  • j
    "Database error saving new user"
  • j
    anyone encountered that before?
  • u
    anyone have a good guide when it comes to deploying with nextjs ?
  • j
    vercel is very easy to deploy to with next
  • u
    ok so no tricks just use vercel and configure the supabase on there? thanks!
  • j
    @User the new UI way to create tables is not doing auto-increment by default with the uuid type for primary keys, it also does not appear in the selector after the table is created, after clicking for the second time on edit column, the option to automatically generate the uuid appears
  • j
    @User you will probably only need to add the config vars through the vercel UI for your supabase keys
  • j
    the issue was a trigger I had created on my new user table
  • j
    but I'm not sure why it started causing problems
  • j
    hm, I'm thinking this is a bug.
  • j
    Well, scratch that. You gotta make sure you don't have non null columns 😩
  • s
    Please report this via the feedback widget in the dashboard, It's quicker and easier to track than tagging the entire team here on Discord.
  • r
    I have disabled signup. I want to create records in the public.users table and then corresponding records in the auth.users table via trigger/function and I have this working BUT the auth.users records are not exactly the same as what gets created when signup is enabled. The encrypted password and confirmation token fields are not populated. When this new user tries to sign in it returns "user not found" or something like that. Any ideas on what I should be doing differently?
    j
    • 2
    • 8
  • k
    any one test the storage api for move file ? seems like the API doc is outdated
1...686970...316Latest