Hi I followed the example given here (https://supabase.com/docs/guides/functions/cors) and I my edge function is so -

// @ts-ignore: module not found
import { serve } from "server";
// @ts-ignore: module not found
import { corsHeaders } from "../_shared/cors.ts";
// @ts-ignore: Deno linting
let SLACK_WEBHOOK_URL = "";

// connect to slack API
serve(async (req: Request) => {
    // This is needed if you're planning to invoke your function from a browser.
    if (req.method === "OPTIONS") {
        return new Response("ok", { headers: corsHeaders });
    }

    // if the request is not POST, return 405
    if (req.method !== "POST") {
        return new Response("Method not allowed", { status: 405 });
    }
...

but i still get the error

I have user table with credits column I want to increment user credits by 10 on the existing credits they have , how ? this doesn't works

Just wondering if the 100/hr limit still applies if it’s my mail server. 🙂

Hey all, this is pretty silly, probably, but why can't I delete the bucket? I am pretty sure I typed in the name correctly.

I have a webhook that is triggered when a particular table is updated and it calls an Edge function. This flow was working perfectly a few days back but it is not working anymore. When I update the table manually, the webhook and, in turn, the edge function do run but when that table is updated form the front-end, the webhook is not being triggered. I am not sure how to even debug this. Can anyone guide me on what to do here?

Hey y'all, I am trying out some basic stuff with buckets and I am not sure what I'm doing wrong. So I want to access my bucket and I've been trying to do it like this:

const supabase = createClient(supabaseUrl, supabaseKey)
  const { data, error } = await supabase
    .storage
    .getBucket('images')
  if (error) {
    res.status(400).json({ error });
  } else {
    res.status(200).json({ data });
  }

and the policy in my public bucket is:

(bucket_id = 'images'::text)

alas, I am getting an error:

{
  "error": {
    "name": "StorageApiError",
    "message": "The resource was not found",
    "status": 400
  }
}

Any ideas?

Hi we making a app and we search for join in 1 querry result for loop in map in view react

js
const { data: catchData, error: catchError } = await supabase
                    .from('FiakomonCatch')
                    .select(`
                  *,
                  Fiakomon: fiakomonID (
                    *,
                    Rarity: rarity (*)
                  )
                `)
                .eq('twitchID', user?.identities[0].id);

we use this for return all Catch and in this sql table we have 2 collum channelID and userID and i want to return the auth.identities equal to this id for dont create a twitch api on catch map loop for get the display name of user if you have a idea who i can make this 😁 and we have try to create relation but can not because the auth.identities id is not unique

Like the title says I have a column that is an array of type text and I want the default value to be an empty array. This is easier to work with when retrieving the data because its still iterable that way.

I've got a technical question involving a more creative approach, if I need a posting control version that creator should make and editor should review before publishing I need something like db control version? Or can i put the table with 3 extra fields, like description0/description1/description2? So the editor after creator submits, can comment and suggest for changes (will happen same as description but with comments1;2;3) And both see all the changes was made in private but in the public post it will only shows the last version available.

Hello, I have a question: I started building my database locally with

supabase start

, now I have it in a state that I want to

push

it to remote, linked instance but I cannot see how you do that. How I can generate a SQL file with the schema from my

public

table into the local

supbase

folder?

Hey there. So I had this simple table in supabase and I just wanted to add a column so I can store the pseudo of my users... But I had an error that I didn't understand: "failed to create pg.columns: must be owner of event trigger pgsodium_trg_mask_update" or something similar So after trying again and again I just deleted the entire table entitled "users", it's just a draft for my first project anyway, and while trying to recreate it I have the same error... (screenshot attached) I have no clue of what is happening so any help is appreciated, also let me know if more information is needed.

Using the js client im trying to upload a file, this should only be possible by admins so I added the following policy to my storage bucket (see screenshots) However when trying to upload and console.logging the error from the reponse I get:

js
{
  statusCode: '403',
  error: '',
  message: 'permission denied for schema storage'
}

Anyone know why this is happening?

If anyone uses FlutterFlow with supabase I’ve been hunting for a way to add social provider auth as a method. FlutterFlow currently appears to support only email with (which is fairly mind boggling for how much work it required to add supa and explicitly code email as a limited option) -

Is anyone else struggling to get redirects working locally? The Auth UI component isn't triggering redirect on email sign-in.

Hello I have run the following command SET default_transaction_read_only = 'off'; but this doesn't work. It stays read-only. Even if I put it between begin and commit. How do I get my db out of read only mode? default transaction read only is set to off when I read it from the db and the db is not in recovery mode. What is preventing me from making changes to the db?

Hi there, I’ve been trying to subscribe to channel notifications in my c#, up in supabase I’ve got a table trigger and function setup which executes a pg_notify to send a broadcast ( from my understanding) yet my C# doesn’t seem to be getting them. My first question is Can the channel subscription approach receive pg_notify broadcasts ?? And if it can Is there an example anywhere ?

Hey! I'm getting the error code

UNABLE_TO_GET_ISSUER_CERT_LOCALLY

when I try to read from my database using the supabase-js client. I installed the SSL certificate from my dashboard and haven't had this issue before, as I've run a few projects on Supabase before. Any suggestions on what I could do? The only code I'm running is

supabase.from('casts').select('*').limit(100)

after creating a Supabase client.

I'm just asking how to store the user to momgo db

I'd like to use SupaBase for social login on my website. Is there a PHP library which is recommended? I saw what looked like an experimental one from the community, and one which did email authentication. But I couldn't find an oAuth one. Thanks!

I've successfully added a SQL function in the sql editor. I was expecting to see the function appear in the same area that lists tables and views but didn't see it. Where can i view all the functions ive added?

I am trying to use Github actions to deploy my edge functions. The import maps works locally but github actions errors out . please see attached. Import the libraries and cors headers into the function worked with github action. can @thorwebdev create a video with import maps? tia

I used to be able to see the latest connection stats, e.g. the number of requests per 5 minutes, allowing me to gauge the traffic quickly. Now it's gone, what happened?

I'm able to insert rows just fine in the dashboard but when I try to insert using

supabase-js

, I get this error:

{"code": "XX000", "details": null, "hint": null, "message": "http_request.content is NULL"}

. This is a recent situation that's occurring with code that has proven to work before. Could there be an external situation with my account causing this issue?

If I don't expose the anon/public key anywhere in my frontend, and only use it on my backend, will this allow me to basically whitelist user signups in my backend?

With superbase-js, how can I decode or log in myself using the

TokenHash

from a Magic Link?

My function for reorder elements: create or replace function reorder(payload json) returns setof games language sql as $$ update games as p set order_index = x.order_index, status = x.status from ( select id, order_index, status from json_populate_recordset(null::games, payload) ) as x where p.id = x.id returning p.*; $$; How do I make this function return only updated data (id, order_index, status) ?

Have you planned on integrating WebAuthn as an authentication provider? https://webauthn.guide/ Thanks

One of our users is registered via his email "test@example.com". He would like to change it to "test2@example.com" but he can't because supabase tells there is already a user with this email (although there isn't). The problem I'm assuming: his user account (which is using test@example.com) also has a Google and GitHub account connected which are using "test2@example.com" which now restrict him to change the email of his user account. Sadly I can't even manually edit the entries in the "auth.identities" table so I'm a bit stuck helping our user here. Any suggestions?

1. I want to understand clearly which parts of the code are run on the server-side and which are run on the client-side when using Next.js with Supabase in conjunction with Vercel. 2. regarding the payload and send functions in Supabase Realtime Broadcast feature, how can I enable the client to send its own data without sending all the data of other users on the same channel? 3. I have some confusion regarding the understanding of broadcasts, and I'm not clear on the difference between using the

on

and

subscribe

functions for channels.

Hi I'm attempting to setup native apple login, and I'm getting errors in my app, which is leading me to think it's a problem in my setup of the process, I've come across a few resources from supabase (https://supabase.com/docs/guides/auth/social-login/auth-apple) and (Mark Burrgraf YouTube) , but I can't figure out what I did wrong, here is the relevant information. 1. I've made sure to enable my app as the primary id in the app id part of the setup. 2. I've created a services_id but I'm not sure what to put into that screen when it asks for the urls given it doesn't accept by primary bundle id as a parameter neither my supabase project v1/auth/callback link. I would love for it to be native, so the user doesn't have to go into the in app browser to login via apple, but either way is fine. I just get a

invalid_client

error on my mobile component. Any guidance on what to put for redirect urls would be very helpful. I've seen in some docs that the service_id is only necessary if you have some web interface, and that if I were to use the native sign_in_with_apple function I would only have to get my bundle_id part working, but I have a feeling that all the steps are necessary when fitting this in with supabase. Source on what I just said https://pub.dev/packages/sign_in_with_apple