Results 1 to 2 of 2
Aug 9, 2002, 05:23 #1
- Join Date
- Jul 2002
- 0 Post(s)
- 0 Thread(s)
SQL and Pictures database design ! Need help
No where better to seek advice that from a collective mind. I am setting up a site for the purpose of having people post any residence they wish to rent. Although I do have an idea of how I wish to set up the data I do wish to seek more advice incase I missed something.
The data layout would be as follows:
1) Alpha-numeric data will be placed within mySQL so its easier to perform searchs on certain strings, mostly would be by locale and price.
2) The problem I have is the pictures if someone wishes to submit them for his residence or building. Shall I have the data related to the pictures in the database and the pictures in another folder (which is what I am currently planning) ? Any other better ideas out there ?
Thank you for just reading.
Aug 9, 2002, 06:25 #2
You're planning to do it right. As I've said in another post, IMHO file systems are for storing files and databases are for storing data, so let both do what they're best at ... put your images in a folder and write the relative path to that image into the database. That's how I did it for a similar problem and it works a treat. Much better than using a file field.