I get

TypeError: Do not know how to serialize a BigInt","code":"XX000"

when I run this function:

var users = plv8.execute(
  `select * from users`
);

return users;

any ideas?

Hey I don't know whom to ping, but someone please help me out. I'm trying to log in to supabase, and that doesn't work for a very long time, when I check the console, it's giving me a cors error. I'm recently trying to get into supabase as im planning to use it in an app, so if someone can solve this it would be great.

Hello, is there any way to use fivetran with supabase?

Hi guys, I've been experiencing an error with realtime and I've been pulling my hair out, I'm thinking its a bug because I can't see anything else I'm doing wrong. I'm using nextjs with supabase. When I run a .subscribe on my database, I've found that it duplicates the response on my front end whenever any action is taken. Currently I'm looking for inserts, and on every single insert, the subscribe function runs twice (and thus triggers twice), causing the code downstream to behave in a funny way.

Hi guyss, I want to ask about preventing user sign up from mischevious app that using our public key, is there any way to check app authenticity?

Just starting with Supabase + Cloudflare Pages and am reading the code at https://github.com/supabase/supabase/tree/master/examples/with-cloudflare-workers It seems like we are creating a new supabase client for each and every htttp request, which seems very unintuitive as normally we try to reuse a client (db connection) as much as possible in other servers. So, is it really ok to make a new supabse client every single http request, or should I try to reuse this

db

declaration in other parts of the app as well?

import { createClient } from '@supabase/supabase-js'

addEventListener('fetch', (event) => {
  event.respondWith(handleRequest(event.request))
})

async function handleRequest(request) {
  const db = createClient(
    'YOUR_SUPABASE_URL', // Replace with your project's URL
    'YOUR_SUPABASE_KEY', // Replace with your project's anon/service_role key
    {
      fetch: fetch.bind(globalThis), // Tell Supabase Client to use Cloudflare Workers' global `fetch` API to make requests
    }
  )
  const { data, error } = await db.from('YOUR_TABLE_NAME').select('*')

  if (error) {
    console.log(error)
    return new Response(error.message || error.toString(), {
      status: 500,
    })
  }

  return new Response(JSON.stringify(data), {
    status: 200,
    headers: { 'Content-Type': 'application/json' },
  })
}

is there any way to trigger stored procedures from a different language other than javascript? (i.e. golang?)

If i have a table like so

Can I do this...

const {data, error} = await supabase
        .from('SignalJourneyAudiences')
        .insert([
          {
            segment: newSegment,
            enabled: false,
          },
        ])

Hi folks! How do you change the redirect url using any of the External OAuth Providers?

is there a way to redirect back to the

/

when using

supabase.auth.signOut()

i can't find it in the docs

Hello @zeem! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! 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.

ok so another problem im accessing the

guilds

scope when authenticating with discord since i want to know what servers the logged in user is in but whenever i log

supabase.auth.user()

i don't get the guilds property at all like how can i access the guilds?

Hey, how would I make sure that when a record is deleted, the associated files from storage are deleted too?

Would anybody be open to doing screen share and helping out with a migrations mess I’m in with the CLI?

Hi I am using supabase with my nextjs api(basically nodejs). When I deploy my nextjs app to production, I get an error when I call my api : "error": "Invalid URL: \"https: ...", but when I use it locally it works. Not sure why this is, i tried changing the site url in settings from localhost to my url but it doesnt work

is it possible in anyway to use a custom phone auth api. May be creating a custom function which calls api and send OTP to user and saved the token in db. Once user enters OTP it gets checked and allow to login user.

How do I count foregin table? I want to count

kaguya_room_users

table, I'm doing as below, I query the users that associated with the room, then use

users.length

to get it. Is it the best way to do that?

js
    supabase
      .from<Room>("kaguya_rooms")
      .select("*, media(*), episode(*), users:kaguya_room_users(id)", {
        count: "exact",
      })

How do I join foreign table in realtime?

js
supabase
      .from(`kaguya_rooms:id=eq.${query.id}`)
      .on("UPDATE", (payload) => {
        console.log("Change received!", payload);
      })
      .subscribe();

Is there anyway to join table on the fly with realtime?

Hey everyone. I wanted to ask for advice. I built a basic crud application that uses magic Auth. Is there a way to have a whitelist of emails that are allowed to sign up ? I want to use the app internally, and only want certain usernames to be able to sign up and read / write the the DB.

Hi Supabase community! Been looking into the product and it looks amazing, and i wanted to know if you can easily just use only the Authentication part with a custom backend database and API layer in Golang etc..

What does

storage.foldername(name)

return?

I can't add tables or rows because the modal closes when I click on an input (or anywhere). Anyone else having this problem?

How comes after changing the site auth url (from my localhost) I am now getting a 404. I am using this

async function login() {
  const {user, session, error} = await supabase.auth.signIn(
    {
      provider: 'google',
    },
    {
      redirectTo: 'https://www.signal-journey.xyz/home',
    },
  
  )

Hi guys! In the doc, we have this:

1. A user signs up. Supabase creates a new user in the auth.users table.
2. Supabase returns a new JWT, which contains the user's UUID.
3. Every request to your database also sends the JWT.

I was wondering if the process is automatic, or is it the dev responsability to store the jwt and send it to. each request? Thanks!

Hello everyone. CAn Anyone help me with one-to-many relationship? In users I've created posts_id row (pic 1) and then relation between posts_id and posts (pic 2) , but it seems its not working. I can not iterate from users to posts to see which post the user made.

Hi i'm using two supabase projects. The first database is open, no RLS and contains the data. And the second database is used for admin. It has RLS and we using a JWT token for login. We are encountering an issue

JWSError JWSInvalidSignature

. We can't get the data from the 1st database when the user is logged in using the 2nd database. Does anyone experience this?

Hello there! Am using supabase and sveltekit for my project and works all fine but there's a problem with me...,Whenever user sign's in (through sign in function ,for now its github) they get signed in properly but their session or data doesnt reflect on client side in realtime instantly i.e in browser, I mean when I console.log user data it shows null but when I refresh page then it shows user session and all properly..,This is not a big problem though ,But For user it can be frustating that they cant see them signed in! Is there any way that it shows the auth activity changes instantly on Authchange? Plz help me as am little new on working supabase with svelte 🙂

I have deleted all the users only user test user I have added. But it is still showing me 9mb out 500mb used. How can I clean up database? should I remove all the audit log entries? anything else which I can remove to clean up database?

Hi everyone, I'm starting a new project and wondering If I can use supabase, it's a food delivery app (Web + mobile) and at each step/state, a user (admin/delivery man, restaurant) can act on the order depending on its role. I will also have to track the location of delivery men and compute the price depending on many properties. Would supabase be suitable for this kind of apps ?