Hi, I've a doubt, supabase free version allows 500mb db space right? If i was to self host supabase, will i be still bound to these restrictions?

No selfhosting is up to your server capacity.

even for the file storage?

File storage is a separate thing to deal with in selfhosting. There is a connection to the local filesystem and the ability to tie in your own s3 bucket. I don't use it though, so you might need to research the limitations on the local file system versus hooking up an s3 bucket like hosted does.

As far as I've found with my own self-hosting, the only space limits are those imposed by the machine you're hosting it on. In theory, if you were to pay for 1TB of storage with your hosting provider, you'd be able to use all of it for storage.

So if i use AWS EC2 for hosting, i can use aws S3 for storage? I've a NestJS backend running right now I'm using aws-sdk to upload files to the S3 which not very convenient in case of managing the files, like if i wanna remove one manually or something, so can i set up a supabase storage and use that inside my Nestjs app to file uploads?

I'm pretty sure Supabase is using AWS EC2 instances for their hosted platforms and then a shared s3 bucket for the storage amongst multiple instances. (based on descriptions of feature options of database platforms)