Store Thumbnails database in photos folder

Ideas for improvements and requests for new features in XnView Classic

Moderators: XnTriq, xnview

aibolit
Posts: 2
Joined: Thu Mar 13, 2008 11:47 am

Store Thumbnails database in photos folder

Post by aibolit » Thu Mar 13, 2008 12:18 pm

I have network of computers and server with photoarchive. I'd like to be able to use server thumbnails database on all computers, instead of importing or updating it.

IMHO best solution would be to store database of folder right in the folder itself, like "windows picture and fax viewer" does.
Please add apropriate option to F12->Browser->Thumbnails->Cache->Use Folder
Last edited by aibolit on Thu Mar 13, 2008 12:45 pm, edited 1 time in total.

User avatar
oops66
XnThusiast
Posts: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: Store Thumbnails database in photos folder

Post by oops66 » Thu Mar 13, 2008 12:40 pm

aibolit wrote:...
IMHO best solution would be to store database of folder right in the folder itself, like "windows picture and fax viewer" does - please add apropriate option to F12->Browser->Thumbnails->Cache->Use Folder
+1 good idea, but as an option only.
XnViewMP 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Post by JohnFredC » Thu Mar 13, 2008 2:21 pm

This topic has been previously discussed in the forum!

Here, for instance.

There are clear benefits and costs on both sides of the issue.
John

User avatar
oops66
XnThusiast
Posts: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Post by oops66 » Thu Mar 13, 2008 2:49 pm

Yes JohnFredC, but here it is not exactly the probleme !
The benefit to have the thumbnails cache ( a xnview.db) directly in each folders is also to do not have to refresh all the tumbnails caches if you restructure your disque or change the name of yours directories, this is very usefull in this case to manage the tumbnails caches.
(same case for category.db, the link is lost if you rename your directories)

see here too:
http://newsgroup.xnview.com/viewtopic.php?t=14613
XnViewMP 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Post by JohnFredC » Thu Mar 13, 2008 3:31 pm

2 oops66

Actually I also would choose a schema where the thumbs are stored locally to the image! I'm also willing to take the performance "hit" that would necessarily occur for some XnView functions.

:)

But I would prefer if there was some way for XnView to use both methods simultaneously and employ a background task to keep the "distributed" stores in synchronization with the "central" store.
John

User avatar
oops66
XnThusiast
Posts: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Post by oops66 » Thu Mar 13, 2008 3:38 pm

JohnFredC wrote:But I would prefer if there was some way for XnView to use both methods simultaneously and employ a background task to keep the "distributed" stores in synchronization with the "central" store.
Me too.
XnViewMP 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

CoSpi
Posts: 10
Joined: Tue Aug 26, 2008 11:29 am

Post by CoSpi » Wed Aug 27, 2008 2:25 pm

It would be fine to save the category.db file to the folder with pictures as well. If the folder with pictures is moved to another computer, the information about categories and the rating will be lost

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Post by JohnFredC » Wed Aug 27, 2008 2:42 pm

We have spend a lot of time on the XnView GUI design in this forum. Because of that XnView has extremely good usability and looks great!

But...

This concern (db centralized or not) and the possibility of multiple simultaneous users of the db (see this recent thread) are now, IMHO, more critical issues than the GUI.

With the advent of XnViewMP, and before too much programming effort has been expended by Pierre on it, there is an opportunity to design a new XnView data infrastructure that addresses all of these issues, and input/opinions from everyone should start now!

Does any one else agree?
John

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Post by JohnFredC » Wed Aug 27, 2008 3:13 pm

By the way, my (centralized) XnView cache is 2.2 GB!!!
John

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

Post by xnview » Wed Aug 27, 2008 3:25 pm

JohnFredC wrote: With the advent of XnViewMP, and before too much programming effort has been expended by Pierre on it, there is an opportunity to design a new XnView data infrastructure that addresses all of these issues, and input/opinions from everyone should start now!
In next version of XnViewMP, i use a better DB structure, more extensible
Pierre.

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Post by JohnFredC » Wed Aug 27, 2008 3:38 pm

In next version of XnViewMP, i use a better DB structure, more extensible
Great!

One approach to the issue discussed in this thread would be to add a couple of new fields to the Folders table in the db...

Redirect: Integer

Whether to store a folder's data in the central db (Redirect=0) or in a db local to the folder (Redirect = 1) or in both places simultaneously (Redirect=2).

RedirectFilename: Text

The name of the "local" db in the folder. This field would only have a value for Redirect = 1 and Redirect = 2
John

User avatar
oops66
XnThusiast
Posts: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Post by oops66 » Wed Aug 27, 2008 5:11 pm

JohnFredC wrote:
In next version of XnViewMP, i use a better DB structure, more extensible
...
Redirect: Integer
Whether to store a folder's data in the central db (Redirect=0) or in a db local to the folder (Redirect = 1) or in both places simultaneously (Redirect=2)....
I agree with this concept: centralized DB or not or both.
Do not forget also, into MP version, a new field in the .db to store also the "IPTC keywords",... - Like in Digicam, to simplify and boost the search function:
http://newsgroup.xnview.com/viewtopic.p ... ht=digicam
http://newsgroup.xnview.com/viewtopic.p ... ht=digicam
XnViewMP 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Post by JohnFredC » Wed Aug 27, 2008 7:39 pm

I've had some time to think about this...

There needs to be a Synchronization field in the folder data record:

Synchronize: Integer

0=Don't synchronize | Redirect = 0
1=Local database (in folder) has authority/priority
2=Central database has authority/priority
3=Ask user what to do

There is much more to it, of course, than just fields in a table.
John

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

Post by xnview » Thu Aug 28, 2008 6:16 am

I disagree with the idea of
JohnFredC wrote:1=Local database (in folder) has authority/priority
. Too complicated, and will be too slow!
Pierre.

CoSpi
Posts: 10
Joined: Tue Aug 26, 2008 11:29 am

Post by CoSpi » Thu Aug 28, 2008 10:58 am

xnview wrote:I disagree with the idea of
JohnFredC wrote:1=Local database (in folder) has authority/priority
. Too complicated, and will be too slow!
:( If I burn images to DVD and distribute my friends?? everything will by lost

my idea is like Thumbs.db in windows

Post Reply