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