On 11/06/16 12:20, David Zuccaro via luv-main wrote:
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.
If it is a small database and will not be accessed by many users, Sqlite might be sufficient - it has blob data type. Daniel 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 luv-main@luv.asn.au https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main