Have Geek Brain

EXIF data storage and retrieval solutions

I have thousands of photos on my site (each with a numeric PhotoID) and I have EXIF ​​data (photos may have other EXIF ​​tags as well).

I want to be able to store and search data efficiently.

Some photos have more EXIF ​​data than others, some are the same, so ..

Basically, I want to be able to request "Select all photos with GPS location" or "All photos with a specific camera"

I can't use MySQL (it won't scale well with massive data size). I was thinking about Cassandra, but I don't think it allows me to query for fields. I've looked at SimpleDB, but I'd rather not pay for the system and I want to be able to run more complex queries on the data.

Also, I am using PHP and Linux, so it would be great if it interacts perfectly with PHP.

Edit . I'd rather stick with some form of NoSQL database.

Any ideas?

+2


a source to share


2 answers


I would probably personally stick with MySQL, but if you're looking for a NoSQL style system, you can look into Solr.This allows things like faceted searches (for example, tell you how much of your current search result fits into each resolution / format / and etc. And lets you narrow your search that way).



+1


a source


I also doubt MySql will have problems loading, but look at CouchDB:

Apache CouchDB is a distributed, fault-tolerant, and contactless document-oriented database accessible through the RESTful HTTP / JSON API.



+2


a source






More articles:


All Articles