[Digikam-devel] stored path in mysql

[Frank Hommes]

Hi,

at the moment (sorry, just using 1.9) the complete path is stored for
all files in mysql database.
I'm using mysql because there are more people with access to my
pictures. The path within the base directory is always the same but the
absolut path in the filesystem is sometimes different.
Example:
/home/freanki/win/pics/2010/freanki/testing/testpic.jpg
/home/directory/pics/2010/freanki/testing/testpic.jpg
z:\pics\2010\freanki\testing\testpic.jpg

This could be resolved with a basepath (stored local or with different
base path in mysql) and relativ path.

1 base path:/home/freanki/win/
2 base path:/home/directory/
3 base path:z:\ (with the addition that all / have to be converted to \
since it's windows)

And all pictures would be stored like this:
pics/2010/freanki/testing/testpic.jpg

This would also save some bandwith and storage...

Best regards
Frank


-- 
Frank Hommes, Bummelberg 37, 44149 Dortmund, Germany
Email: email at freanki.net, ICQ: 14621277
Homepage: http://www.freanki.net
PGP-Key: http://www.freanki.net/gpg/