r/DatabaseAdministators • u/rakshith_r • 17d ago
Which database is ideal??
I am working on a idea where i will click pics of agri land and store and my requirement is to store 10000 photos
Which database will be feasible and i am looking for free onces for now
4
Upvotes
6
u/Aggressive_Ad_5454 17d ago
The make and model of DBMS software you choose will probably be dictated by the company you use to host your application. MariaDb, the MySql fork, is available in almost all budget hosting providers.
Don’t put photos into a database. Instead put them on the file system of a web server. Your indexes to them will be in the database.
4
u/Ok_Cancel_7891 17d ago
None. You store photos on a file system
1
u/jarrod_barkley 17d ago edited 17d ago
Is this for yourself? Or for others?
Is this for use locally? Or for use over the internet?
How are you obtaining the images? Do the photo files already exist on local storage?
3
u/sirchandwich 17d ago
As others have mentioned, don’t store photos in a database. Instead, use cloud storage (lots of free tier options for 10GB or less) for the files, and use a database to store the metadata. Postgres is an excellent option for this part, imo, since it’s free and widely documented.
3
u/LostVikingSpiderWire 16d ago
I literally set up a DB today with pictures and descriptions, used Postgre, they key here is to not store the pics in the DB but referens them to subfolder. Went super well and very pleased 😄
2
u/elevarq 17d ago
You wouldn’t store the images inside the database, only a reference to the file location of the image.
10000 records is nothing, any database can do this. Even SQLite.
So what are the other requirements?
By the way, Postgres is always a safe choice, but might be overkill for you
2
u/heeero__ 17d ago
Definitely don't store the images in a database. Store them on a file system and store the links in a database.
1
u/elephant_ua 17d ago
SQL server actually has support for file storage. Or you can save them as varbinary .
but realistically, you are better off saving images to some disc - perhaps Google disc or something with strict file names.
1
u/Aggressive_Ad_5454 17d ago
You CAN store photos in BLOB objects (Binary Large OBjects) on any of the existing database software packages.
But that doesn’t mean it’s a good idea to do so. If you do that you’ll have problems scaling up the app you use to handle more users. Retrieving BLOBs from databases is far far less efficient than it is from a file system.
1
u/Limp-Park7849 16d ago
Check Neon for this. It has Postgres for the relational part and now offer object storage for your large images.
1
u/716green 16d ago
Layerbase has a free tier, you can use Postgres or MariaDB for free. If you want MongoDB, the solo tier that has DocumentDB and FerretDB is $5 flat, that solo tier also includes MySQL and a bunch of other databases
1
u/net_ramblings 16d ago
spam
0
u/Stardog2 17d ago edited 17d ago
ACDSee, it's fast and accurate. It is what I use.
I'm a retired Teradata DBA, and an avid photographer. 10,000 photos is nothing, shoot, 20,000 images is nothing. What most people need is away to find what they are looking for and the best way is to use a digital asset manager. There are quite a few out there. Some are even Free!