On 11/06/16 12:12, James Harper wrote:
Is there a database that can be used to store images? If so, what is the best
one to use for a small web project I have in mind?
Do you mean like an SQL database with an IMAGE/BLOB type?
Yes.
MySQL or Postgres are the obvious choices, and google has a few examples of code for
both. I've only ever done this with Microsoft SQL server though. It has a
"FILESTREAM" option where you manipulate the images as though they were columns
in a database table, but they are actually stored in a directory in the filesystem, which
has some advantages. If your project is really only small, storing them in the database
shouldn't present a problem. I would not recommend the approach I have used in the past
which is to store the images in the filesystem yourself and maintain links to them in the
database. If you do that you need a way to keep everything consistent.
Thank you, this is what I suspected but thanks for the confirmation.
_______________________________________________
luv-main mailing list
[email protected]
https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main
