I am supposed to develop a web-based application for a real estate company, that includes a lot of pictures. My question is how to organize the pictures: database or filesystem? I have read somewhere that the filesystem is a more appropiate solution, does anyone have some experience with that? Can anyone give me some good reasons why I should proceed this way?
Furthermore: how should I organize the directory structure? A real estate company has more offices, each office employs more agents. One agent has more listings (houses to sell/lease). One house has a main picture, up to 24 additional pictures (a slideshow) and maybe a virtual tour/panorama. Each image should be available in different resolutions (2 or three). What is the best directory hierachy to store all these images? (The application will be developed in php+mysql and will probably run on a Linux box with an Apache server)
Any piece of advice concerning the design of this application is welcome.