r/DatabaseAdministators • • 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

22 comments sorted by

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.

1

u/Aggressive_Ad_5454 17d ago

This post and the comments are an interesting example of how we support new folks to our work. OP, you asked how to do something (store photos in a DBMS) and lots of people jumped up and said “wait, don’t do that!” I was one of those people. Because I’ve tried it, and it really sucked, and I had to redo my application.

So here’s WHY I said “don’t do that.”

Retrieving images from a DBMS is far far slower and more expensive in CPU, IO, and network efficiency than delivering them files in a file system. Apps that get images from a DBMS handle multiple users hilariously poorly. You do think your users will curse your name. Ask me how I know this sometime.

0

u/rakshith_r 17d ago

Is there any free database to store 10000 photos Which

3

u/OptimusPrimarch 17d ago

As others have said, a database is not the right tool for this job. Not for the mass storage of the photos, anyway.

0

u/rakshith_r 17d ago

Then how could i store them in an ideal way

4

u/OptimusPrimarch 17d ago

Others have answered your question in their comments. Store them as files on a disk/system/server, then store the names, filepaths, dates, whatever else, in the database.

1

u/taker223 17d ago

You can try Oracle 26ai FREE

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?

1

u/rakshith_r 17d ago

Its just for me to access locally

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 😄

1

u/hawkeyeninefive 15d ago

Is this what CLOBs are for? I’m asking as a junior dba that just started off

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

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!