I believe I am concating to my jsonb array wrong. if I have declare like

mylist jsonb := '[]';

and in loop want to push opjects into it

mylist = mylist || jsonb_build_object(
      'id', my_id::uuid,
      'myfield', some_text,
    );

I think this is actually making the list like jsonb[] type without string around '[]' its like []. Error is

operator does not exist: character varying = jsonb

for overall func and I think something like this is issue

Is there a way to get width/height of an image in storage.objects so I can have aspect-ratio without having it sent on client from js or sent incorrectly. I slightly feel like saw article on this somewhere but ill keep looking

How can i get user info on relationship?

Hi everyone! Does anyone how can I raise an exception from a Database Function with custom hint, message, code?, I want to handle it correctly in the front-end according to my own "exceptions" collection. Thank you so much in advance!

This is my first time trying to use Supabase and I have no experience with the backend, so this may be a dumb question. I'm trying to link my front end app to my DB with a magic link.

Hello everybody I'm connected to the DB from my machine but if i try to do a backup (pg_dump), it says I don't have enough permissions. I'm connected with the postgres credentials in a free project. am I doing it wrong?, or do I need a Pro project?, or even like that is it not possible at all to backup my database? thanks!

I've got a number of small apps I'd love to create with Supabase, however I don't want to pay $25 a month for every one. Is there any way to get more free instances (for example by paying for a Pro subscription) or should I just figure out a way to self host under nginx or something? Thanks!

I am building a game and using firebase, considering switching to Supabase. My main concern with firebase is lack of rate limiting. I saw that this was being worked on, but couldn't find if it has been added. Is there built in protection against ddos like attacks?

Hey everyone, Im trying to use supabase with typescript and I noticed that the

.eq

method doesn't support joined tables. Could someone help me out? I'll include details in the thread

I am trying to download a file from a public bucket

publicfiles

using this function:

const downloadFile = async (pathToFile) => {
    const { data, error } = await supabase
      .storage
      .from('publicfiles')
      .download(pathToFile)
    if (error) throw error
    return data
  }

I logged out

pathToFile

and the Url seems to be correct since I can view the image in my browser. The error I'm getting is:

Uncaught (in promise) 
{message: 'Access Denied', status: 400}
message: "Access Denied"
status: 400
[[Prototype]]: Object

My bucket is public and I'm using the standard

Enable read access for all users

SELECT

policy for storage.objects. (public bucket itself has no policies) Is there anything else I need to do?

Hii, Does anyone Know How we can send extra details with third party sign in like we can do with signup with email I can see these options but cannot verify how to use any of it Thanks!

Hi, I have a small problem here, I creating a gallery in next js, and with supabase I will try it out with backend. In supabase I have a table called, GalleryTable, and in storage i have a bucket called gallery. In my bucket gallery I have folders and inside those folders I have some images. Could I somehow, when i upload a Image to storage from my website, connect that image and create a new row in the table GalleryTable, with a column called img, connect that image i uploaded to storage to that column img? My storage looks like And my table look like

Does anyone know what's causing this problem? Using the Table Editor, every time I try to modify a column of any table in my database, the editor gives me this error:

Validation failed (numeric string is expected)

I cannot do anything on my database right now because of this. Luckily there isn't a lot of tables and data yet but I have deleted a few tables three times and recreated them completely as a workaround.

Does anybody know whether the returned array from a bulk insert will match the order of the data that was sent to the insert? I couldn't find this specified in the docs

Hello, I cant connect to my table, or bucket, it's just loading, why is that?

I'm trying to run supabase locally but when i try to use auth i get the following error

running db migrations: Migrator: problem creating schema migrations: CREATE TABLE \"schema_migrations\" (\n\"version\" VARCHAR (14) NOT NULL\n);\nCREATE UNIQUE INDEX \"schema_migrations_version_idx\" ON \"schema_migrations\" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)

Does anyone have a clue to what I'm doing wrong?

Mutiple identities: Is is possible to add, eg., discord login to existing users?

What is the fail2ban policy on the PROD deployment? I accidentally used wrong password twice (

psql

from CLI) and now i cant connect and my app hosted on the server is failing too. Any way to unban my ip?

Is there any way i could get the queries generated by the supabase studio when i change columns/tables info? It would be nice, so i could copy it to my migration scripts

Hello everyone! is there any simple db-beginner-friendly way to manage the project locally? I did read the "local development" guide (https://supabase.com/docs/guides/local-development) , but I'm having trouble to understand how this actually works, for example; how can I rollback to a previous state of DB?, can I manage all of that with regular git?, I'm not getting the "migrations" concept that well but I would like to learn! thanks in advance.

Hello, question, is there a way to recover an email in Supabase? If one of my users loses his email, and consequently can not use it anymore, how he could change his email so he can login normally with his new email? Thanks before hand

Is the realtime connection requests shown in the last panel on the dashboard available in the prometheus endpoint? If not, can I request for it to be added?

How can I double join in a query? I have a table called

images

which belongs to a

snapshot

which belongs to a

category

. (Snapshot is just an instance from when I scrape from the website). I want to find all images for a certain category by name.

Hello everyone! I was wondering if I define different RLS rules for the same method (SELECT, INSERT, etc); will it behave like a OR?, (as long as any of the policies passes, it will allow the operation), or will it act just like an AND?, (all the policies must pass to allow the operation? Thanks in advance!

Hi, I'm using Javascript SDK to invoke Edge Functions and it's seem that it call a server in south america when my users are located in EU, do you have an idea why ? Thanks !

Is there a way to restrict edge functions to certain users?

Hello everyone! I was wondering if there's a way to subscribe (realtime) to a table and retrieve the payload when it contains joins/relations, thanks in advance!

I've created a bucket

files

that contains one file,

private.txt

and a rule allowing select access for everyone. When I call

supabase.storage.from('files').download('private.txt')

, there is no response data even though the response code is 200. Am I doing something wrong?

I want to build a dashboard/service, where i can send a invitation for Signup , i have tried Auth0 but didn't work. Anyone tips?

I'm trying to upload an avatar file for a testimonial. Used to work without the restful api but now it's not working. Can anybody tell me what is wrong with my code? I double checked it and don't get it. I'm passing

event.target[2].files[0]

to the api but I wonder if i'm not losing data

js
// frontend code
saveTestimonial(evt) {
    this.isFetching = true

    const data = new FormData()
    data.append('description', this.description)
    data.append('identity', this.identity)
    data.append('picture', evt.target[2].files[0])

    console.log(evt.target[2].files[0])

    fetch('/api/testimonials-add', {
      method: 'POST',
      body: data,
    })

// --- API code

    const imageFile = data.files.picture[0]
    const imagePath = `public/${imageFile.originalFilename}`
    supabase.storage
      .from('test_images')
      .upload(imagePath, imageFile)
      .then(async (response) => {
        await this.supabase.from('testimonials').insert({
          description: data.fields.description[0],
          name: data.fields.identity[0].split('/')[0].trim(),
          occupation: data.fields.identity[0].split('/')[1].trim(),
          picture:
            'https://qroiybphgipjhkmfsvnj.supabase.co/storage/v1/object/public/' +
            response.data.Key,
        })
      })