[Digikam-devel] Re: stored path in mysql

[Marcel Wiesweg]

> 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)

Qt handles "\" problems, we never care

> 
> And all pictures would be stored like this:
> pics/2010/freanki/testing/testpic.jpg
> 
> This would also save some bandwith and storage...

You may want to have a look at the discussion of bug 261277