Get bucket size

[PaperPrototype]

Description

As noted here https://www.answeroverflow.com/m/1186881391233863751

Basically some way to get the current bucket size via the storage API. Something like supabase.storage.from("mybucket").getSize()

Suggested solution

There is seems to already be an RPC function called "get_size_by_bucket", so just reuse that?

Alternative

Calling supabase.rpc("get_size_by_bucket") manually, though it is not documented and I don't know if it will break in future versions (or if it is already broken in the latest release)

Additional context

No response

Validations

• Follow our Code of Conduct
• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that request the same feature to avoid creating a duplicate.

[PaperPrototype]

Doing this mainly as a way of trying to control max total storage per bucket for a SaaS app with free tier storage. The idea is to use one bucket per user project and limit the projects max storage.

Something like a maxBucketSize could also serve this purpose.

const { data, error } = await supabase.storage.createBucket('avatars', {
  public: true,
  allowedMimeTypes: ['image/*'],
  maxFileSize: '1MB',     <--  max size for each file in the bucket
  maxBucketSize:'1GB'   <-- max size of the entire bucket. 
})

Related discussion here supabase/storage#134 (comment)