Re: Image database in mySQL

[Rick James]

The sharing, tagging and searching should definitely use a database.

Whether the images are also in the db or in a file system is a user preference.

I prefer putting them in the db to cut down on the likelihood of missing links (file gets deleted without the row being deleted, and vice versa).

If you put them in a db, be sure to have a table with nothing but an id and the image. All meta data (tags, etc) would be in another table for speed of searching. (It would also have the id, so that you can reach into the image table.)

Are you going to pre-compute thumbnails? And store them, too? What about other sizes?