[Digikam-users] Some questions about digikam4.db

[Anders Stedtlund]

Hi,

I installed:
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

Then removed the tables. Everything seems to work. The indexes
connected to the tables were removed automatically. The db size shrunk
even more.


Now, what can I do with the stray images without any album? I can see
that there's a trigger for removing an image in the db. When is that
triggered? I asume not when moving files? Is it safe to remove these
and all records in the other tables for these images?

/Anders



2011/11/9 Gilles Caulier <caulier.gilles at gmail.com>:
> Make a backup and drop table using sqlite manager.
> http://www.sqlitemanager.org/
>
> If it work, perhaps somebody can write a script to automatize this task
> Gilles
>
> 2011/11/9 Anders Stedtlund <falolaf at gmail.com>
>>
>> Hi,
>>
>> I have just tested anyway. (Have backup of course...)
>>
>> Deleted Thumbnails and compacted. Now the size of digikam4.db is
>> ~20MB. digiKam starts and everything seems to be working...
>>
>> I can see that there is actually 4 tables that have been removed:
>> CustomIdentifiers
>> FilePaths
>> Thumbnails
>> UniqueHashes
>>
>> How about removing them all from the old db? What might happen?
>>
>> /Anders
>>
>> 2011/11/9 Gilles Caulier <caulier.gilles at gmail.com>:
>> >
>> >
>> > 2011/11/9 Anders Stedtlund <falolaf at gmail.com>
>> >>
>> >> Hi,
>> >>
>> >> I have now tested 2.3.0 with a new fresh profile. In this version the
>> >> Thumbnails table doesn't exits anymore.
>> >>
>> >> Would it be safe to just drop the Thumbnails table in the old db file?
>> >
>> > I think yes, but the right response must come from Marcel or Francesco,
>> > to
>> > be sure.
>> > Gilles Caulier
>> > _______________________________________________
>> > Digikam-users mailing list
>> > Digikam-users at kde.org
>> > https://mail.kde.org/mailman/listinfo/digikam-users
>> >
>> >
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>