XBMC Community Forum
Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Development (/forumdisplay.php?fid=32)
+--- Forum: Feature Suggestions (/forumdisplay.php?fid=9)
+--- Thread: Pictures database and library mode; scan EXIF and IPTC metadata tags into a SQL db (/showthread.php?tid=22407)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


- jcouvaras - 2009-07-05 04:39

I Agree a Picture Database is now needed and would be a great feature to have :-)

I currently have about 33,000 Pictures and the newer ones are all about 5MB+ in size as I've moved up to a DSLR and XBMC does take a long time to read in all the information and load the directories that have 1500+ pictures in them.

Also scrolling and viewing the thumbs is slow where as if I use ACDSee (Image viewer) it's fast and seems to work well with it's internal Database.

It would be great to be able to catalog/'scan' all your pictures into the XBMC database even if it's just purely for thumbs creation for now as this alone will save allot of time when you want to view the pics they will be there for viewing whilst at the moment a folder with 1500+ pictures is about 8.2GB in size that XBMC has to read in and catalog only when you enter that folder and cannot to much else until it's finished else it does not keep scanning/creating thumbs.

Just a though that I believe might be nice to have a scan for changes on the pictures folder, I'm also not sure why when viewing large folders or pictures why scrolling and navigating through the picutres is so slow... I am using an older PC (Pentium 4 2.8Ghz with HT) so that could be why but other tasks on the PC seem to run fine... Perhaps XBCM is loading very high quality thumbs even though it's not needed and this could required a very large amount of RAM/CPU power? I'm not sure... any one know the answer and is there a solution to speeding the thumbs viewing up?

Thanks very much
Jonathan :-)


Library for pictures - m.savazzi - 2009-07-09 13:58

Maybe is not in the core focus of the topic but I would love to have a library for pictures like Picasa-Photoshop Elements etc...
so that I can filter pictures by the tags I've given them.

Mf


- steve1977 - 2009-08-03 17:21

jcouvaras Wrote:I Agree a Picture Database is now needed and would be a great feature to have :-)

I currently have about 33,000 Pictures and the newer ones are all about 5MB+ in size as I've moved up to a DSLR and XBMC does take a long time to read in all the information and load the directories that have 1500+ pictures in them.

Also scrolling and viewing the thumbs is slow where as if I use ACDSee (Image viewer) it's fast and seems to work well with it's internal Database.

It would be great to be able to catalog/'scan' all your pictures into the XBMC database even if it's just purely for thumbs creation for now as this alone will save allot of time when you want to view the pics they will be there for viewing whilst at the moment a folder with 1500+ pictures is about 8.2GB in size that XBMC has to read in and catalog only when you enter that folder and cannot to much else until it's finished else it does not keep scanning/creating thumbs.

Just a though that I believe might be nice to have a scan for changes on the pictures folder, I'm also not sure why when viewing large folders or pictures why scrolling and navigating through the picutres is so slow... I am using an older PC (Pentium 4 2.8Ghz with HT) so that could be why but other tasks on the PC seem to run fine... Perhaps XBCM is loading very high quality thumbs even though it's not needed and this could required a very large amount of RAM/CPU power? I'm not sure... any one know the answer and is there a solution to speeding the thumbs viewing up?

Thanks very much
Jonathan :-)

Perfect description of exactly my situation. Any hope short- or mid-term in sight?

Cheers!!!


- steve1977 - 2009-10-03 16:40

Any hope for the next release?


- lennon105 - 2009-12-09 04:32

Hello

I've been away from the scene for a little while but glad to see my requested picture database has some interest. I'm hoping with the added platforms this needed feature could find a talented coder. (little ass kiss couldn't hurt Smile ) I see in the tracker it's been changed to future.... does that mean it's being worked on?
Thanks again


http://trac.xbmc.org/ticket/3117


- zag - 2009-12-09 11:41

If anyone wants some code to start with MeediOS has a photo importer[svn] that works with EXIF and adobe XMP tags. I don't think its a difficult to write an XBMC patch because there are already well established tag reading DLLs.

What might be a little more difficult is is a way to see all the views like location, date, size, camera model, keywords, GPSinfo ect.

A little off topic but what programs do people use to tag photos?


- lennon105 - 2009-12-12 20:34

Adobe Lightroom has worked well for me with over 15,000 photos. Since I'm still on the Xbox I keep two photo collections, the originals and another resized to about 1920x1080 for faster loads. Is xbmc for linux or windows able to view camera raw files?


- Andrewishy - 2009-12-13 01:07

Hi All

I was thinking...

If a new db was going to be created for the Pictures then wouldn't it be better to create a more flexible db system where the user could create multiple db's based on some user tag (name)... the idea would be to set a separate db for different types of content, so we currently have Video and Music rather than extending these to have home movies within the video db why not have a new db for home movies?

It may be a little harder to set up where all the content is located (but xbmc so needs a wizard to set up where the content is anyway)

Each database should be able to have any content within it, picture, video, music, web pages, documents... this then allows a more generic media experience.

Anyhow I really wanted to say that i also have 1k's of pictures and would like to be able to watch them on my xbmc (Acer revo linux minimum install) and be able to add a picture to a screen saver db if i like it then when the screen save comes on it just goes through the screen saver db.

Andy

PS Just downloading the code but its been a while since i programmed and it doesn't seem to be easy to get into the code base

PSS If i get anywhere with a basic patch i'll release it here


Hi Andrew - lennon105 - 2009-12-20 19:55

Hi

Thanks for trying Andrewishy....wish I could help but I have zero programing experience. I do have a web site that does a great job of using photo keywords. Send me a private message if you would like to see it.

Good Luck


- mhdebokx - 2010-01-08 09:24

I hope there will be an exif-picture database soon. I also spend a lot of time tagging my photo's, so it will be neat if I can select the pictures my self.

Away around is not building an database, but implement something like a playlist feature (or makeing a picture plugin).
If it is possible to make a list of pictures (directory names & file names) you want to show, then we can start the slideshows with special interest photo's.
Eg. using ExifTool, we can easy select out interest
exiftool -if "$keywords =~ /Michel/i" -filename -r -s -v0 *.jpg . >playlist_michel.xsp

The plugin can show our own pictures. In fact it looks like the Flick XBMC plugin, but niw it will not scan the internet :-)

Waiting for the first release of such an option . . .