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 > [email protected] > https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main _______________________________________________ luv-main mailing list [email protected] https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main
