Reading the .db file

[david-vj]

CONTENTS DELETED

The author has deleted this message.

[Milan Knížek]

davidvincentjones píše v Pá 07. 08. 2009 v 17:42 -0700:
> Is there a way to browse the .db file?
>
What about sqlitebrowse mentioned here:
http://ubuntuforums.org/showthread.php?t=1192655

Milan Knizek
knizek (dot) confy (at) volny (dot) cz
http://www.milan-knizek.net - About linux and photography (Czech
language only)

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

[Marcel Wiesweg]

> Is there a way to browse the .db file?

sqlite3 /your/digikam4.db
SELECT * FROM Images WHERE name='filename-with-problem.jpg';

>
> I would really like to see what 'flags' have been set that is prohibiting
> just a few of my images being seen within an album.
>
> What I find is that moving my "hidden" images and renaming then is not
> helping nor is a change in file permissions ... so I must assume that
> something in the db file is set to restrict their display.

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

[DIL23-2]

Firefox has an excellent sqlite "add-on"

https://addons.mozilla.org/en-US/firefox/addon/5817

browse, edit, create tables,queries/views etc - best and easiest I've used.

Good luck with the images!

DIL23
:)


On Saturday 08 August 2009 01:42:20 davidvincentjones wrote:
> Is there a way to browse the .db file?
>
> I would really like to see what 'flags' have been set that is prohibiting
> just a few of my images being seen within an album.
>
> What I find is that moving my "hidden" images and renaming then is not
> helping nor is a change in file permissions ... so I must assume that
> something in the db file is set to restrict their display.


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

[Morten Slott Hansen-2]

You can use sqliteman which is a GUI for messing around with sqlite databases - it is really a great tool. Use read only to avoid breaking digiKam.

On Sat, Aug 8, 2009 at 2:42 AM, davidvincentjones <[hidden email]> wrote:

Is there a way to browse the .db file?

I would really like to see what 'flags' have been set that is prohibiting
just a few of my images being seen within an album.

What I find is that moving my "hidden" images and renaming then is not
helping nor is a change in file permissions ... so I must assume that
something in the db file is set to restrict their display.


--
View this message in context: http://www.nabble.com/Reading-the-.db-file-tp24873895p24873895.html
Sent from the digikam-users mailing list archive at Nabble.com.

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

--
Best regards,
 Morten Slott Hansen

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

[david-vj]

CONTENTS DELETED

The author has deleted this message.

[david-vj]

CONTENTS DELETED

The author has deleted this message.