Store a link to it. I see no advantage at all to storing binary data in
a database. It just creates a lot more work for you by putting the data
in a table. You have to create an interface to get at the data...or
select it out into a file to get back the image, etc.
---John Holmes...
At 4:45 PM -0700 24/4/02, PHP List wrote:
I was wondering about the following:
Should I store a picture directly in a MySQL table? Or just store the link
to a file on the system somewhere?
This should be a FAQ.
If you allow people to upload files via a web form, your only secure
option is to
Personally I think databases these days (MySQL in my experience at
least) are more than reliable enough and fast enough to serve up
binary data in quite large quantities. If you run into performance
issues, implement a caching solution run from a crontab.
I had a very, very bad experience
If your page is frequently access and the data does not change then by all
means store the image in the file system.
however, I have found it useful to store the images in the database for
certain applications which I want to maintain an additional level of
security over the images when using
4 matches
Mail list logo