Which database is good for storing small images

Question

I have thousands of images in a directory divided in subfolders. I want to get all these images out of the file system and put them in a database. I do not think that such data is good for a normal database such as sql server. is there a database that is good for storing thousands if not millions of small high-definition thumbnails? I would like to query this database by id, then it will provide me with an image

Answer 1

There are several recommendations.

• If the files are small (say, under 4K), and you have a lot (say, more than 10K), you can see the improvement with saving files to the database;

• If you want to simplify backups by storing everything in one database and receiving free replication (if you already have replication installed for your regular database), the database will have an advantage;

• If your files are large (say, over 100 thousand), storing them in a database is very likely not to be a good idea (SQL databases are not created for this). If you still want to save them to the database, find something else (for example, CouchDB, etc. );

• One big drawback of storing them in a database is that it will be harder to access images. First, retrieving images from a disk uses file system caching and optimized paths for streaming files directly from a disk over the Internet. You lose all this, and this can cause problems in certain circumstances (again, when your files are large);

• When your files often do not change (which images do not have), the database is most often not suitable, not suitable. Databases are good at storing and modifying small amounts of data. Large static data does not match this model.

Answer 2

A file system is usually the best way to store large blogs of binary data, such as images, that can be easily identified by identifier, URL, or unique.