Re: sqlite data

Posted by on
URL: http://digikam.185.s1.nabble.com/sqlite-data-tp1735355p1735356.html

Joel B. Mohler wrote:

> Hi,
>
> I'm new to digiKam (just getting my digital camera today) and it looks like
> just the thing to organize photos in a wife-friendly manner.  I have one
> question though.  I'd like to archive the photo captions/tags etc in a human
> readable format.  I'm under the impression that all of this information is
> kept in the digikam.db in the root album folder in an sqlite format.  I
> thought I could then have the sqlite CLI program dump the data for backup.  
> However that doesn't work on my computer with the following issues:
>
> **************************
> $ sqlite3 digikam.db
> SQLite version 3.2.1
> Enter ".help" for instructions
> sqlite> .tables
> Error: file is encrypted or is not a database
> sqlite> .database
> Error: file is encrypted or is not a database
> sqlite>
> **************************
>
> Am I understanding the file digikam.db correctly?  Is there another way to
> export this information which is automatable for daily backup?

digikam.db is <sqlite3 = digikam < 0.8.0
digikam3.db = sqlite3 = digikam 0.8.0 (released soon)

Toma

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users