sqlite data

[Joel B. Mohler]

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?

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

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

[Joel B. Mohler]

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

Thanks.  I'm upgraded & pleased  :).
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users