Get image width/height

[kasper9n]

I'd like to get the image width/height of files in Supabase Storage.

In my case, I'm storing image URLs in my database, and would like to do a migration to also store the image dimensions. It would be great to fill in them server-side, but I believe that would require downloading all the images and using some npm package to get the image dimensions. It would be great to have a more simpler way.

[GaryAustin1]

There is a metadata column in the storage.objects table that contains the size metadata of the file.

[kasper9n]

Sorry should've clarified I mean image width/height, not file size

[GaryAustin1]

Yeah, that is different. Wonder if the new image transformations could have an option to return the size.
#10918

[kasper9n]

Looked into that, and I don't think that would work because the transforms are part of getPublicUrl, which is a synchronous function that just returns a url string.

[GaryAustin1]

Ah, yeah. Did not think that thru at all. Transforms are just parameters in the URL. Sorry for the dead end.

[kasper9n]

All good, I didn't think about that at first either