[Digikam-devel] [Bug 261277] Windows and Linux Frontend using the same database

[julien.t43+kde at gmail.com]

https://bugs.kde.org/show_bug.cgi?id=261277

julien.t43+kde at gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |julien.t43+kde at gmail.com

--- Comment #20 from julien.t43+kde at gmail.com ---
Just as a follow-up of the following thread
http://mail.kde.org/pipermail/digikam-users/2012-September/016862.html
I tried today to share my collections (Linux, external disk, fat32 partition -
recently switched from ext4 to fat32 for sharing as sadly it is still the only
"universal" filesystem recognized by nearly any system) with a macos macbook.

Constraints: because of fat32, I had to move my db files to alternative
locations (instead of Images/) as thumbnails db is far above 2GB as both db
have to stay together. It seems there is no way currently to make it splitted
(by size or by period of time yearly/monthly/...)

Need
* change db path in ~/.kde/share/config/digikamrc or
~/Library/Preferences/KDE/share/config/digikamrc (both Database Name and
Database Name Thumbnails: if the second is different from the first, digikam
will rewrite it with the same previous pah)
* change root path of Images in database. for sqlite
$ sqlite3 ~/path/to/digikam4.db
SQLite version 3.7.14 2012-09-03 15:42:36
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers on
sqlite> select * from AlbumRoots;
id|label|status|type|identifier|specificPath
1|Images|0|1|volumeid:?uuid=1e369250-3d4f-40b3-b65b-7797264c712b|/path1/to/Images
sqlite> UPDATE AlbumRoots SET identifier='volumeid:?path=/new/path2/to/Images',
specificPath='/' WHERE id=1

after I started digikam, rebuild thumbnails and it seems working fine.
Still hope performances will not be too bad with fat32 and not too many
problems in case of crash (fat32 nothing against journaling and else of others)

Other reference
http://comments.gmane.org/gmane.comp.kde.digikam.user/18828
https://bugs.kde.org/show_bug.cgi?id=175923

-- 
You are receiving this mail because:
You are the assignee for the bug.