hey everyone, as you know that supabase automatically creates CRUD APIs for every table. Is there a way I can disable an API? For instance I've a table where the client's job is to read only, so I want to disable post API that creates a new record. Because I want the records are inserted manually through sql or through supabase UI. Any help is appreciated. Thanks!

is there a way to deploy an edge function supplying Deno's --unstable flag?

Hi guys, I wanted to ask if it is possible to insert a record with an array value using the dart client or is it yet not supported? Thanks.

how do i select a particular database ? i have more than one, and i dont see in the examples where to select a particular one

How to check if a user is logged in and then redirecting to dashboard or login on page load?

supabase.auth.user()

doesn’t return a Promise, and returns null before it retrieves the session—making it hard to determine what the login state is.

I want to configure RLS in a way that a user can only see rows that they explicitly select with the id For example

sql
-- should return nothing
select * from connections 

-- should return the row where id = 1234
select * from connections where id = 1234

I know that I can compare things like the auth data (auth.email() for example) to values, but is that also possible with where parameters?

Hey i cant view my project dashboard. All requests to my project url are failing with CORS errors. I tried firefox and chrome and few days ago the same browser was working. Is this some extension/browser setting on my end or something on supabase?

Hi! I am launching my Supabase powered app to production, for that I need to create a clean copy of my public schema. I can not seem to be able to run pg_dump on the dashboard sql editor. has anyone done this before? any other suggestions on how to have two Supabase projects, one for development and one for production are welcome! Thanks

__PLEASE HELP__ How can I get this to load from Supabase instead of LocalStorage?

js
const [song, setSong] = useState(
    () => JSON.parse(localStorage.getItem("song")) ?? ninteenOne
  );

  useEffect(() => {
    localStorage.setItem("song", JSON.stringify(song));
    (async () => {
      const { data, error } = await supabase
        .from("song")
        .upsert({ id: 1, slug: song });
      console.log(JSON.parse(data[0].slug));
    })();
  }, [song]);

sandbox - https://codesandbox.io/s/friendly-poincare-ke7j6m?file=/src/App.jsx

Hi Guys, How to detect email confirmation when it was click or not?

Not sure how to formulate the question, but here goes 🙂 I have a front-end communicating with supabase, and i'm also running a server i'd like to have comunicating with supabase.. both front and back are on the same system i'm creating. How can i have the server communicate with supabase with RLS enabled ? Or do i need to setup a complete login routine for the server ?

Using postgres and plpgsql, I'm trying to create a function with takes in a parameter which is an array of objects.

sql
CREATE FUNCTION test_function(products_object_array_input some_data_type) -- what should the data type be? array? jsonb[]?

An array of objects that I would pass into the function could look like this:

json
[
  { "productID": 3, "quantity": 5 },
  { "productID": 1, "quantity": 2 }
]

First question: What should I set the products_object_array_input data type as? array? jsonb[]? Second question: I then want to loop over the array to insert the values of the object array. Again, using plpgsql. How?

sql
-- I want to loop over cart_array_input and do this for every object in the array. Sorry for pseudo-code. i = iterator
insert into order_item(product_id, quantity)
values(products_object_array_input[i].productID, products_object_array_input[i].quantity);

Is it possible to transfer the ownership of a Supabase project? I assume I have to talk to customer support?

Hello, I am planning to make an app where between 100-500 users at the same time will listen to the change in real time of a table field, and if the application goes well it will go up to +1000, I wanted to know what the user limit is that they can listen to changes at the same time, I have searched through several documents but they always say it depends, I don't want to be surprised if the app reaches 100 users and crashes because the limit of 25 dollars is only 100 users listening to a change in a column

im trying to get auth working with twitter, i'm calling

await supabase.auth.signIn({ provider: 'twitter' })

in my app, but instead of a "login with twitter" page as id expect, my browser gets sent to my supabase root url

Is it possible to use supabase storage with a Postgres orm? I want to upload files using gorm (golang's ORM) to a storage bucket.

Can I control what information is stored in the JWT of the Supabase Auth?

Hi, new here, what's the best way to add support for custom handlers, say for example I want to load an image to b2 and call some third party api to send an email, how can I write or combine supabase with some express / other backend code?

Hey all, is it possible to copy rows into Supabase/Postgres from a .CSV without using the psql shell? (like what's mentioned in Bulk Uploading: https://supabase.com/docs/guides/database/tables#bulk-data-loading) I'm trying to copy rows from a .CSV into a table with a client query and Supabase says I need superuser permissions, but I'm not sure how to assign them to myself.

Hi there, I have seen a few people commenting in discussion around the redirectTo property and it not respecting it after OAuth returns - I'm struggling to route to a simple /app after providing it to the signIn function e.g

await supabaseClient.auth.signIn({
      provider: "twitter",
    },
    {
      redirectTo: "http://localhost:3000/app"
    });

and in my Additional redirect URLs settings:

http://localhost:3000/app

I wasn't sure if it could be the # symbol appended on the URL that has the access_token param after it, so tried a few ways of hard-coding it on the URL but to no luck. I'm using the supabase-auth-helpers package but don't think it's related to this. Help is much appreciated!

What is the best way to bulk add users and their associated profile data with the user UUID in the profile records? Seems that I need to first add the users to auth and then add the profile record with the ID from the auth insert. Is there a best practice/migration for this kind of thing?

Hey everyone, i'm facing the following issue when testing locally only with PgBouncer:

Error: pgbouncer cannot connect to server

Not sure why this is occurring and forces me to restart the server. Any help would be appreciated

Can set RLS expressions on fields differently?

Hello, is it possible to set RLS on a view ? So you can have a view to select, a view to update, and a view to insert

having the same trouble as this chap in this (stackoverflow issue)[https://stackoverflow.com/questions/71726303/supabase-query-for-one-to-one-foreign-key-return-single-value-not-array]. tldr; how do you flatten the results from a foreign-table query when their is a one-to-one mapping? e.g this.

{
  "id": 1,
  "foreign": [
    {
      "id": 1
    }
  ]
}

to

```
{
    "id": 1,
    "foreign": {
            "id": 1
     }
}

```

Hey! I'm new here and been enjoying Supabase so far, however I'm having issues with GraphQL. Either my reading comprehension is horrible or the tutorial is unclear but I've followed all the steps I can find on how to enable GraphQL with no success. I'm also unable to retrieve the graphQl schemas. And currently I keep getting the following error

{
  "message": "The schema must be one of the following: public, storage, graphql"
}

Can I point my storage to b2 beckblaze on the self hosted version ?

Hello @NinjaNuur! 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.

Is there any chance I can use TLS when connecting from Deno? Below warning indicates something incompatible:

TLS connection failed with message: invalid peer certificate contents: invalid peer certificate: UnsupportedCertVersion
Defaulting to non-encrypted connection
Sending fatal alert BadCertificate

any idea why i am getting this?