> > 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. > > While you can do things this way, it's typically better to store the images > in a > file system, or even on a remote CDN, and use your relational database for > storing information about the images, but not the actual image content. > > Loading images from SQL BLOB storage means loading the whole image into > memory at once, which is not good for larger images, particularly if you are > serving multiple images on a page. It also saves SQL query overhead per > image, and whatever processes might sit between the DB and the web > server for the image requests. >
I don't think that's been true for a while, at least not for the bigger database products. This article explores some of the advantages and disadvantages of each approach, from a postgres point of view https://wiki.postgresql.org/wiki/BinaryFilesInDB TL;DR - the answer is "it depends" :) James _______________________________________________ luv-main mailing list [email protected] https://lists.luv.asn.au/cgi-bin/mailman/listinfo/luv-main
