https://supabase.com/ logo
Join Discord
Powered by
# help
  • u
    Hi everyone, is there a PHP SDK for Supabase?
  • d
    It seems I just need to paste the query in 
    .select('')
  • c
    Hi Hi. How do we perform a GROUP BY query?
  • m
    Morning All
  • j
    Hi! Im using the Supabase UI Auth component to enable Facebook login for my app. Having some issues with the signup/login-flow with the following error message after being redirected back from facebook. Anyone else faced the same issue? The strange thing is that it's working fine if I'm logged in to my own facebook account. But when I'm trying to log in using my wife's facebook account, I get this error.
    k
    • 2
    • 12
  • s
    Cannot INSERT a new record if SELECT policy is not satisfied
  • s
    How to handle complex queries
  • k
    Error getting user email from external provider
  • y
    if you use the secret key when creating a client, could you overwrite policies? aka do things that are denied via policies? kinda like using the admin sdk with a service account when using firestore
  • m
    If you use the secret key, you can bypass the policies from what i know
  • j
    Hey i'm having an issue where my react state is just a empty array in the db INSERT event
  • j
    Copy code
    jsx
const [todos, setTodos] = useState([])

    useEffect(() => {
        supabase.from("todos").select().then(res => {
            const list = [];
            for (let todo of res.data) {
                list.push(todo)
            }
            setTodos(list)
        })

        supabase.from("todos")
            .on("INSERT", payload => {
                setTodos([payload.new, ...todos])
            })
            .subscribe(payload => {
                console.log('schema ', payload)
            })

    }, [])
  • j
    The todos array actually does contain data
  • j
    It's just that in the supabase live callback that it's empty
  • y
    you have to enable realtime for your todos table by going to your dashboard, then database -> replication ideally you'd delete the supabase_realtime publication that exists by default and add only the tables that you want realtime enabled in
  • j
    I did
  • j
    Its jusr that in the callback my local state is empty
  • s
    I am trying to redirect a user if they’re logged in on page load and I can’t for the life of me figure out how. I’ve been using 
    supabase.auth.user()
    and 
    supabase.auth.session()
    but often the page loads before the auth values are fetched and updated. How are you guys handling this?
    s
    f
    • 3
    • 14
  • s
    Typically, if these functions returned a Promise everything would work great, but since they don’t I’m dumbfounded how to block my middleware or trigger a function when the values are updated and correct
  • b
    Are you using react by chance? If so, a useEffect with a session dependency may solve the problem
  • s
    Unfortunately, I’m not—I’m using Vue/Nuxt/Gridsome and SvelteKit. But thanks, I’ll file this away for when I do!
  • s
    I’m specifically using the 
    handle()
    hook that runs as on every route change in SvelteKit https://kit.svelte.dev/docs#hooks-handle
  • s
    supabase.auth.session
    is 
    null
    on page load when user is logged in
  • n
    How does one perform an 
    upsert
    when multiple columns have a 
    unique
    constraint? Ex: I want to insert a new row into 
    users
    if a row with the given ID doesn't already exist. If a row already exists with the same ID, I want to override that existing row BUT I still want to check that the new email and phone will be unique (i.e. if they're the same as the old email/phone, it doesn't matter BUT if they're different, than I want PostgreSQL to check that they're unique). Database schema:
    Copy code
    pgsql
create table public.users (
  "id" text unique not null primary key,
  "email" text unique,
  "phone" text unique
);
  • f
    What's the proper return type for a function which should order and return a list of rows in a table?
    • 1
    • 3
  • s
    I am using magic link of Supabase for passwordless signup/signin in a Nextjs project. The link sent is for the base url of localhost:3000. Today, I hosted the code on Vercel. The signup email still sends the link with localhost:3000. How do I change that to actual production url link?
  • s
    In the settings of the app on supabase
  • s
    At the top it asks your apps url
  • s
    oh ok. Let me check that right now
  • s
    I saw it. Thanks a lot for pointing that out.
1...343536...316Latest