View Full Version : Database Organization, Best Practices

08-25-2009, 04:03 PM
I am designing a website about Car audio. users can sign up and customize their own "garage" with a little about their car and current projects. They can upload pictures, (and videos eventually) to my server, which other users can search by brand or vehicle.
I wanted some advice on the best way to organize this. My host only allows me 50 Databases with a combined storage space of 100 MB. I am allowed 250GB monthly transfer volume so right now uplaods are stored in my images folder.
I want the site to be organized and searchable, with room for future expansion(i am just with a host for now). i also want to be able to know what user has posted up what and allow others to see this as well, and i want it to be self-organizing after the structure is made. thanks for the input, it is much appreciated.

08-25-2009, 06:35 PM
my bad i said that wrong, its 100mb each DB.