How to relationship with files in collections?

I find relatonships are so basic and support many less features than Appwrite's competitors. I can't create relationship with files I can't see buckets in the collections list as well as users.

How can we build a relationship system between files and also users. This is blocking me from going with the appwrite.

I tried supabase self-hosted but jesus, that's not okay for selfhosting. Thankfully appwrite has great self hosting support.

Please help this guy

TL;DR

Developers can create relationships between files and collections in Appwrite by using the files' IDs from storage buckets. This allows for assigning files to specific documents like product catalogs. For public accessibility, consider using permissions on storage buckets or a dedicated collection for user permissions. Appwrite may have basic relationship support compared to competitors, but additional functionalities can be achieved by exploring different approaches.

There's no built in support for creating relationships among Storage Files x User. What you could do is either use Permissions on Storage buckets, use User Prefs or create a dedicated collection for user with permissions so that only they can access them. You haven't described your usecase so this is just a very basic approach.

It will be like a product catalog. I want to assign files to each product document including pdfs, sheets and docx files. and same for images png and jpg. those files will be publicly assessible