https://supabase.com/ logo
Join Discord
Powered by
# help
  • c
    This has probably been asked a bunch, but I can only find references to really old answers that where before edge functions. But, is it possible to schedule/cron a edge function without using Postgres or a local computer?
    n
    o
    • 3
    • 4
  • s
    Are API calls unlimited in free plan ? And is it rate limited
    n
    g
    • 3
    • 2
  • t
    Hey folks, just found supabase. Sounds interesting but - with the SQL is coming via client app isn't that a SQL injection waiting to happen? What's the security mechanism there? I couldn't find that info in the docs.
    n
    s
    p
    • 4
    • 19
  • p
    I just tried the signedUrl that should make a file valid for 10 seconds (flutter), however I can still access it, am i missing something perhaps?
    n
    g
    • 3
    • 3
  • r
    hello everyone, I have just cloned git to run supabase locally and I have a problem with db.. exec /usr/local/bin/docker-entrypoint.sh: exec format error I'm trying to run it inside a Ampere in OCI any relation? or maybe some real issue with the docker db image?
    n
    n
    • 3
    • 5
  • u
    Hey guys, just wondering where is the best place to ask questions. Here or in the GitHub discussions?
    n
    o
    • 2
    • 7
  • s
    Does supabase have any caching layer integrated? Or should I simply hookup redis by myself?
    n
    s
    • 3
    • 2
  • b
    My site is not not letting people register now for some reason. I've had this happen one other time and restarted the server and seemed to work but not this time. Any ideas?
    n
    g
    • 3
    • 20
  • z
    Logical Replication with Supabase as Subscriber is not working. We're seeing this warning "out of background worker slots" even on paid plan. Could there be something else we're missing?
    n
    g
    • 3
    • 5
  • e
    I have the tables.. 
    reports
    bonds
    report_bonds
    Reports are basically just a list of bonds, or a list of documents. In my UI I want to display specific bond information. I know that instead of running another function, I can use something like this...
    Copy code
    js
  const { data: report, error } = await supabase
    .from("reports")
    .select("*, report_bonds(*)")
    .eq("id", params.id)
    .single();
    ... in hopes that it will give me back a nested obj containing all the 
    bond
    information / details to render to my UI. But, I get the error, 
    Could not embed because more than one relationship was found for 'reports' and 'reports_bonds'
    It is true that my 
    reports_bond
    table has 2 FK, 
    bond_id
    and 
    report_id
    ( I need both ). I have looked for answers online and in the documents but I cannot seem to get anything to work. I even tried removing 1 of the 2 FKs in the 
    report_bond
    table, but I still get the same error     Any ideas on how I can go about this ?
    n
    g
    • 3
    • 5
  • k
    I'm running into a peculiar problem. - I'm using 
    onAuthStateChange
    to set an auth cookie - I'm checking for the cookie in an edge function to guard protected routes 
    /dashboard
    - After signing up/in I redirect users to the dashboard page - Redirecting was happening before auth cookie was set, so the edge function forwarded them away - I fixed this by listening for 
    event === 'SIGNED_IN'
    , and after auth cookie is set, I redirect to 
    /dashboard
    - Worked great for signing in, but when a user signs up I first create the user, and then I create an additional row in another table - The user is being redirected before the additional row is created because 
    event === 'SIGNED_IN'
    is being triggered So, is there anyway to sign up without triggering sign in? Or is there a solution to one of these problems I'm not seeing?
    n
    j
    • 3
    • 3
  • h
    I'm trying to use supabase auth with prisma and getting this error. the github discussions about triggers seem a little confusing. any idea
    n
    o
    n
    • 4
    • 86
  • j
    When using sveltekit auth helpers following https://github.com/supabase-community/auth-helpers/tree/main/packages/sveltekit I get 
    <SupaAuthHelper> is not a valid SSR component
    Idk if need to add something in svelte.config.js
    n
    s
    • 3
    • 10
  • camel (2022-07-19)
    n
    Hello @Deleted User! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
    g
    • 2
    • 2
  • i
    Hey hey! First off, thanks so much for all this work team. Really been loving this product. I'm trying to figure out where to setup custom SMTP for authentication. I did it a couple weeks ago, but it seems the UI got updated and i can't quite find my way back to it again.
    n
    j
    • 3
    • 4
  • 김민석 (2022-07-19)
    n
    Hello @김민석! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
    • 1
    • 1
  • a
    I'm using Sveltekit-auth-helper with redirect to handle user invites. I have set the redirect URL in the Supabase dashboard, but the redirect, after confirmation, is still to the index route. I'm obviously missing something but I can't figure out what.
    n
    s
    • 3
    • 11
  • b
    Self-hosting with the docker image, supabase-studio cannot connect with the DB
    n
    o
    • 3
    • 8
  • n
    I am trying to do RLS with Prisma. There is a weird behavior I'm seeing with RLS policy with simple SELECT. Using the deprecated 
    auth.role() = 'authenticated'
    works however, 
    TO authenticated
    in RLS policy does not work FOR Prisma Client. (Supabase Client works for both) More details in thread
    n
    g
    • 3
    • 9
  • d
    anyone knows how to do queries with the postgist extension?
    n
    • 2
    • 1
  • n
    Hey everyone, is there a way to call a 
    locally
    hosted Edge Function inside a 
    PSQL Function
    with the 
    pgsql-http
    extension? I tried to POST the local Edge Function and I got *connection refused*: 
    "Failed to connect to localhost port 54321: Connection refused"
    Database function extracted:
    Copy code
    BEGIN
  ...
  SELECT status FROM http_post('http://localhost:54321/functions/v1/<functionname>', ...);
  ...
END
    Is there maybe a Docker alias of the Edge Function service?
    n
    s
    • 3
    • 5
  • k
    Heyo, i've wanted to ask how to set it up. I tried with kubernetes, but i got stuck on a CORS Error. I then tried the offical docker-compose setup, this time no cors error but a 401 Unauthorized when loading the default Project. Because of that, it cannot load the default Project. Anyone has a Idea, on how to fix this or even maybe get it to run on kubernetes?
    n
    • 2
    • 3
  • a
    Hey! I'm using Supabase Auth in my NextJS app as below:
    Copy code
    ts
//import from packages
import React from "react";
import { Auth } from "@supabase/ui";
import { supabaseClient } from "@supabase/auth-helpers-nextjs";
//import from context and utils
//import from components
//import assets

export default function AllLoginOptions() {
  return (
    <div className="all-login-options">
      <Auth
        supabaseClient={supabaseClient}
        providers={["google"]}
        socialLayout="horizontal"
        socialButtonSize="large"
        className="text-warmwhite"
        redirectTo={`app.${process.env.APP_DOMAIN}/dashboard`}
      ></Auth>
    </div>
  );
}
    I've changed the Site url for auth redirects in my the Supabase Project Authentication settings to my production domain. I've also added 
    localhost
    to the list of allowed redirect urls. However, when I login in during dev (on localhost), the redirect happens to the production domain after auth. How can I redirect to 
    localhost
    ? Note: the 
    APP_DOMAIN
    environment variable is set as 
    localhost
    in dev, and as the production domain in prod.
    n
    s
    • 3
    • 7
  • r
    When you create a teams table, does the user_id should be an array ?
    n
    g
    • 3
    • 16
  • m
    How to set the default value of a column to the row id or an auto incrementing number? Can this be done with a short expression in the default value input box or does it need an SQL expression?
    n
    s
    n
    • 4
    • 5
  • s
    RPC function issue with UPDATE
    n
    s
    • 3
    • 49
  • j
    Anyone know if theres a way to prevent edge functions from hanging up after 1 minute? Code execution finishes, but the remote server (supabase) hangs up at 1 minute.
    n
    s
    • 3
    • 6
  • Julien (2022-07-19)
    n
    Hello @Julien! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
    • 1
    • 1
  • a
    I'm having some trouble with OTP auth:
    Copy code
    await supabase.auth.signIn({email})
    This triggers an email, and when the verification link is clicked, it redirects to http://localhost:5173/#access_token=[...]&expires_in=3600&refresh_token=[...]&token_type=bearer&type=magiclink AFAIK that Supabase -> GoTrue -> redirect flow should set browser cookies, but that's not happening and I'm not sure why
    n
    s
    • 3
    • 51
  • s
    Hello, I am trying to implement custom claims with my web app. How would I go about setting a custom role of a user on signup. for example if a user signs up from the teacher portal their custom claim role becomes "teacher"?
    n
    s
    g
    • 4
    • 48
1...303304305...316Latest