general query about database

Ask for help and post your question on how to use XnView Classic.

Moderators: XnTriq, xnview

Post Reply
dglp
Posts: 27
Joined: Mon May 19, 2008 11:37 am
Location: Birmingham

general query about database

Post by dglp » Sun Jan 04, 2009 4:48 pm

A few months back I asked about reducing the saize of my database. I am now wanting to know a bit more about the database generally. What is it storing; is it directly readable/editable; can it be copied/moved as part of a new XnView installation; is there an FAQ discussing the database?

Addendum: I have noticed that the database time attribute is about 70 minutes ahead of current system time. When I make a change to the databse, such as adding a new image, the date modified attribute on the database is updated, not to current system time, but 74 minutes ahead! Any comments on that?

bugmenot
Posts: 69
Joined: Sun Sep 16, 2007 10:29 pm

Post by bugmenot » Mon Jan 05, 2009 1:23 am

also, we have thumb+cat .db files
but they seem to mix info

User avatar
xnview
Author of XnView
Posts: 31261
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: general query about database

Post by xnview » Mon Jan 05, 2009 2:39 am

dglp wrote:A few months back I asked about reducing the saize of my database. I am now wanting to know a bit more about the database generally. What is it storing; is it directly readable/editable; can it be copied/moved as part of a new XnView installation; is there an FAQ discussing the database?
xnview.db stores thumbnails + rating & colour label
category.db stores categories
Addendum: I have noticed that the database time attribute is about 70 minutes ahead of current system time. When I make a change to the databse, such as adding a new image, the date modified attribute on the database is updated, not to current system time, but 74 minutes ahead! Any comments on that?
Not on my system
Pierre.

Post Reply