Are there clients for Kotlin, Swift? I've found this for Kotlin -> postgrest-kt but it doesn't support realtime events

Hi. I am using **supabase-auth-helpers ** For some reason the endpoints with protected guarding returns "JWT Expired" error, even though the user has logged out and logged in to the application. Is anyone familiar with this?

Hey, any tips for debugging storage policies?

Hey guys, when using realtime, can i filter the rows i wanna listen with more than one column for the filter? For example, "countries:columnX=eq.FOO;columnY=eq.BAR"

js
const [user, setUser] = useState();
  useEffect(() => {
    setUser(supabase.auth.user());
  }, []);

Had to do this to prevent a NextJs hydration error, but now I have to refresh the page for conditional rendered components to be correct, anyone know a fix?

Anyone had any luck hosting their Supabase locally in docker, but still being able to hit it from an https frontend? Getting CORS errors trying to do this...

Is it just me or is the agolia on the supabase website down?

Trying to automatically create a stripe customer for each user with the supabase function hooks. Attaching the id and email after logging WORKS but I don't see the stripe_customer id being attached. According to the video by Jon Meyers I followed . My next guess would be to implicitly add the stripe_customer like I did with email but since SUPABASE is in ALPHA I want to ask first

hi, is there any way to add multiple file extensions to contentType using from.upload? - seems like the default is image/png - but we want to be able to upload .gif, .jpg and so on

Hey can you transfer ownership of a project to a team or a different account? A site I was working on as a personal project ramped up into a fullscale production app and I don't want to manage fees myself?

I have a small (less than 300 rows) database but for some reason it occupies ~150 MB storage. This is not natural, right? Investigating further, I found that

pg_class

and

pg_statistic

take up 95 MB and 43 MB respectively. What might be the problem here?

Wanted to override (not append) scopes of a discord login https://supabase.com/docs/reference/javascript/auth-signin#sign-in-with-scopes

const { user, session, error } = await supabase.auth.signIn(
  {provider: 'discord'},
  {scopes: 'identify'})

but the it seems the scope is appended in the url

&scope=email+identify+identify

Looked through the code https://github.com/supabase/gotrue-js/blob/2f183f421096755d3ae2bd4f698503422a6b8eea/src/GoTrueClient.ts#L246 and it shouldnt be the case, am i missing something? Or is the

email

mandatory for supabase to work properly?

#843999948717555735 Can I send email verification without paid account.

Hi there, I am getting an 404 error when I try to update a record and I am wondering why that happens. Any ideas what is going on?

js
async function update(newData) {
    const objId = newData.id;
    const { data, error } = await supabase
        .from('addresses')
        .update({city: newData.city})
        .eq('id', objId);

    console.log(data, error)
    if (null !== error) {
        return false;
    }

    return true;
}

data is null and error is an empty array. Reponse http is 404 but I have no idea why it happens at all. The record with the id (1) exists in the table and everything is spelled correct.

Unable to deploy to vercel since upgrading supabase-js. https://github.com/supabase-community/supabase-auth-helpers/issues/56#issuecomment-1083239610

Playing with supabase. Currently just using it as auth and a very rudimentary user profile. Using it in Sveltekit deployed to Cloudflare Pages. It's all working, but the Cloudflare build log returns this error:

Using @sveltejs/adapter-cloudflare
▲ [WARNING] Ignoring this import because "node_modules/@supabase/supabase-js/dist/module/index.js" was marked as having no side effects

     .svelte-kit/output/server/entries/pages/__layout.svelte.js:4:7:
          4 │ import "@supabase/supabase-js";
            ╵        ~~~~~~~~~~~~~~~~~~~~~~~

      "sideEffects" is false in the enclosing "package.json" file
    
        node_modules/@supabase/supabase-js/package.json:21:2:
          21 │   "sideEffects": false,
             ╵   ~~~~~~~~~~~~~

Is it something I should be worried about?

i'm having trouble with row based authentication. i want to use a table for form submissions. i have insert set to anyone can insert, and select set to only logged in users. the read is working properly but I can't insert using the anon key. do i need to set any other permissions?

Is there any way to listen for realtime updates with filters (To specific column)? For example, realtime:public:cities:cityID=eq.xxxxxx. I want to listen for update in row with cityID xxxx for the specific column eg."population"

Can you do an IF statment with SQL Editor on the Supabase webiste? I tried with

sql
    IF value1 <> value2 THEN  
//something happens
    END IF;

but when i did that as a trigger it bugged the entire app out xD

Hi 👋 ! Im sure this has been asked, but I cant find the answer. How do I export just the structure / schema of a database? My use case is if I have an open source website template that uses a Supabase DB, and I want people to be able to spin up their own DB with all the correct tables and connections. Thanks!

Does anyone know if this has been fixed in some recent updates? Planning to add authentication via Discord in one of projects sometime soon, so would be great if there wouldn't be a need to always ask people for the credentials and permissions 😄 https://github.com/supabase/gotrue-js/issues/131

Currently i am returning single value from "testers" as single(). Is it possible to return single values from nested select queries as well? So lets say i just want a single(first) value from "test" table .

const {error, data} = await supabase
    .from('testers')
    .select("assignments (*, test(*))")
    .single()

Hello everyone. I have one problem. I have made my function to get data from posts table, and it works fine, but I've tried to make the same thing with realtime (pic1) and for some reason its not working. I can get the posts but they appear only on page refresh. I've logged my variable and you can see the results (pic2).

Is the storage api supposed to work for local development? I'm getting an RLS policy error when I try to upload files

How do i go about flattening this request so it comes back as

const {data: initialPlayers} = await client.from('players')
  .select(`
    id: player,
    users (name)
  `)

{ id, name }

Right now it's coming back as

{id, users: {name } }

Hey! I'm unsure what the proper flow is for when a user tries to signIn/signUp with the same email that they used to create an account with a provider. So, if they sign in with google, I see a row added to my auth.users schema and I can see that in

raw_app_meta_data

it shows their provider. But now if they login with their email being the same as the google email, I get an error that their email is already in use, and if it's a create account, then it's an incorrect username and password. How can I get the app_meta_data? or what's the proper flow?

Has anyone from the community integrated Supabase Auth with Hapi dev? I am considering migrating my user auth from Auth0 to supabase

I am getting this error message when attempting to connect to Supabase table.

hi everyone, simple question, Im trying to use gmail smtp, is that possible ? I enabled Imap on gmail, but I keep getting error 500 .. thank you

Hey all, somewhat similar question to that above 👆 but I'm using Amazon SES hooked up via custom smtp — it's preventing users from completing the auth flow but not preventing existing users from signing in — just wondering if somethings hiccuping on the Supabase side, or if I need to go digging into SES (though nothing is reporting fowl over there) —  Error is:

code: 500
error_id: "f4d5968e-17e0-4129-b3fb-80e468a121e1"
msg: "Error sending confirmation mail"

If I disable custom smtp it works as expected.