Hi guys, I was thinking which is the best solution for me. I need to include file upload capabilities to my web app. But before I struggle to learn any other API's I'd like to be sure which method in my database should I use. Should I make a folder where I upload image and store the address of the folder to my database(String or varchar)? Or should I store it in my database as binary data? I need only to store pictures... Thanks!
Data integerity is one reason to store it in the DB; another way of looking at that is that you've only got one thing to back up.
One of the negatives is that image data is often big, and database storage can be substantially more expensive than regular disk storage (some Enterprise DBs use high-speed RAID arrays with fibre-channel controllers, for example).
So it depends a lot on the target database and the number of images. If I were to be writing a commercial image archiving product, I would try to support both ways.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads