[Bug 191494] New: Wish: search offline collections (e.g. removable medias)

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #19 from Gilles Caulier <caulier gilles gmail com>  2009-05-29 15:33:31 ---
>Is disk I/O the limiting factor? Then PGF is better because it creates so much
>smaller files.

Well, here we don't care about I/O files acess to HDD, because data will be
hosted in one DB file. Of course db file will be smaller than PNG or JPEG
format. I have also compared PGF compression 10 with JPEG quality 80 with the
same file. PGF is 30-40 % smaller...

Gilles

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #20 from Mikolaj Machowski <mikmach wp pl>  2009-05-29 21:33:03 ---
I was always proponent of internal thumbs database but those numbers doesn't
sound as good as they seem in first moment.

22kb for thumbnail means for modest collection of 15000 (yes, it is modest as
you probably know) means 330MB which will be loaded into memory just by opening
of digiKam. If someone shoots more and longer, have family and manages photos
for them, and last but not least uses digiKam for management of his
(semi)professional workflow 100000 is easy to achieve. In this case dadatabase
can reach 2GB of data!

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #21 from Andi Clemens <andi clemens gmx net>  2009-05-29 21:46:00 ---
Yes, I agree.
This is why I asked if this is only used for offline / remote collections. But
plans are to use it for local collections as well, which means that you might
end up with twice the thumbnails data, once in .thumbnails folder and then
again in the thumbs.db.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #22 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-05-30 14:07:41 ---
@ Mikolaj: Calculating for 100,000 is ok. I do tests with 30,000 because I dont
have more. If you open a database file I assume not all of this is loaded into
memory! That would not work at all.

So the question here is: What is the most efficient storage for 10,000s of
files of the size 10k-30k. The offered solutions are:
a) in filesystem, assumed standard Linux ext3/ext4
b) as BLOBs in sqlite

I have done some superficial research, came up with these pages:
http://stackoverflow.com/questions/757493/sqlite-blob-or-file-system-for-images
http://stackoverflow.com/questions/325126/storing-a-small-number-of-images-blob-or-fs
http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay

all of this is from the web development field and has some different
priorities, I did not really get a clear answer.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #23 from Andi Clemens <andi clemens gmx net>  2009-05-30 14:21:16 ---
I read somewhere that a sqlite db is not loaded to memory at all, only a very
small part for managing purposes.
This is why sqlite is quite slow when writing to the database. It creates a
journal on the harddisk to keep track of changes. When running ext4 with
barriers, you can see how much this technology can slow down digiKam.
So a 2GB database will definitely not waste 2GB of RAM, this would be insane :D
But even MySQL will never hold a whole database in memory, only the most used
one (I guess, not the big database expert).

Andi

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #24 from Andi Clemens <andi clemens gmx net>  2009-05-30 15:08:15 ---
From a performance view, I don't think we will gain more speed here, since
sqlite needs to write twice to disk on each transaction, once for the journal,
and then again for the actual data. It is not cached like in a real SQL server,
so speed gains in reading and writing should not be visible I guess.
Who knows, it might be even slower, but this can only be seen when we actually
use it.
Sure it could be packed into one big transaction, but I guess this will waste
memory and kill performance.

As I said before, I would think some hybrid would be better, store all remote
thumbs in the database, the local ones in the file system.
But this makes code more complicated again.

Andi

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Paul Waldo]

https://bugs.kde.org/show_bug.cgi?id=191494


Paul Waldo <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #25 from Paul Waldo <paul waldoware com>  2009-06-10 14:55:57 ---
I also would like to see this functionality, but allow me to explain a scenario
and this may help bring the problem into focus.

I have Albums that are stored on a network share to allow for backups and
redundant disks.  I use a laptop to do my image editing.  When the laptop is
connected to the network, I have full access to my images.  If I am away from
network, I can't do any image editing nor can I even browse the albums because
the albums are networked albums.  Because I shoot in raw, when I edit an image
I start with the raw file, convert it, edit it, and save it as a .png in a
different album.

I like the idea above of storing thumbnails that can be viewed offline, but
let's take it one step further.  I would also like to be able to mark images
for offline use then work on them while not connected to the network.  Here is
how I envision this working:

1. While connected to the network, mark an image for offline use.  This would
probably make a copy on the local drive somewhere.
2. Disconnect from the network and go sit under a shady tree with my laptop.
3. Navigate back to the image marked for offline use and start editing it.
4. Save as a .png to my "developed images" album that is also offline
5. Plug back into the network
6. Digikam knows about the new image I added to the Developed album and copies
it to the Network share.

I know that's a pretty tall order.  The resynchronization is not as important
as having specific images available to me, but it sure would be nifty!  Thanks
for your consideration!

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=191494


Amos Kariuki <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Michael G. Hansen]

https://bugs.kde.org/show_bug.cgi?id=191494


Michael G. Hansen <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #26 from Michael G. Hansen <mike mghansen de>  2009-11-27 12:25:52 ---
*** Bug 133638 has been marked as a duplicate of this bug. ***

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

https://bugs.kde.org/show_bug.cgi?id=191494


Jordi A. Cam <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #27 from Jordi A. Cam <camus arrakis es>  2010-03-13 20:51:08 ---
So... after all comments, there's nothing more since June 2009.
We have the possibility to add CD and DVD albums to digikam album collection,
but I can't make a search in these if CD/DVD is not inserted.
What's on with this wish? It will be add as a feature in the next digikam
version?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[nianderson]

Mar 13, 2010 was the last update on this bug. This would still be a nice feature to have. NAS and removable drive storage only seems to be increasing for people. The ability to search for pictures, and see thumbnails while "offline" would be great. As would the ability to direct me to the media the picture is stored on. Anything stored on DVDs or CDs, or even USB hard drives can be difficult to locate.

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
            Summary|Wish: search offline        |Support search in offline
                   |collections (e.g. removable |collections (e.g. removable
                   |medias)                     |medias)

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #28 from Gilles Caulier <[hidden email]> ---
Marcel,

Since we use a database to host collections item thumbs, this feature must be
easily done now. Right ?

Gilles

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #29 from Marcel Wiesweg <[hidden email]> ---
Yes, we can show offline collections.
What is missing is UI handling: If you open such an image in the editor, the
user must be told that the image is offline. Etc. for all editing tools.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #30 from Gilles Caulier <[hidden email]> ---
Thanks Marcel,

It must be not to hard to implement

Gilles

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #31 from Gilles Caulier <[hidden email]> ---
his entry is also relevant indirectly  of bug #114539

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #32 from Gilles Caulier <[hidden email]> ---
Git commit 3daab2fc8a17e20d68a69c319ab65edcca3fc876 by Marcel Wiesweg.
Committed on 15/11/2014 at 17:14.
Pushed by mwiesweg into branch 'master'.

Allow to use the notification tooltip with some more safety also from other
sources than overlays

M  +13   -0    libs/widgets/itemview/dcategorizedview.cpp
M  +1    -0    libs/widgets/itemview/dcategorizedview.h

http://commits.kde.org/digikam/3daab2fc8a17e20d68a69c319ab65edcca3fc876

diff --git a/libs/widgets/itemview/dcategorizedview.cpp
b/libs/widgets/itemview/dcategorizedview.cpp
index 1f1b406..d98069b 100644
--- a/libs/widgets/itemview/dcategorizedview.cpp
+++ b/libs/widgets/itemview/dcategorizedview.cpp
@@ -769,6 +769,11 @@ void DCategorizedView::contextMenuEvent(QContextMenuEvent*
event)
     }
 }

+void DCategorizedView::leaveEvent(QEvent*)
+{
+    hideIndexNotification();
+}
+
 void DCategorizedView::mousePressEvent(QMouseEvent* event)
 {
     userInteraction();
@@ -835,6 +840,14 @@ void DCategorizedView::mouseMoveEvent(QMouseEvent* event)
         unsetCursor();
     }

+    if (d->notificationToolTip && d->notificationToolTip->isVisible())
+    {
+        if (!d->notificationToolTip->rect().adjusted(-50, -50, 50,
50).contains(event->pos()))
+        {
+            hideIndexNotification();
+        }
+    }
+
     DigikamKCategorizedView::mouseMoveEvent(event);

     d->delegate->mouseMoved(event, indexVisualRect, index);
diff --git a/libs/widgets/itemview/dcategorizedview.h
b/libs/widgets/itemview/dcategorizedview.h
index f07fc3f..31d1adb 100644
--- a/libs/widgets/itemview/dcategorizedview.h
+++ b/libs/widgets/itemview/dcategorizedview.h
@@ -143,6 +143,7 @@ protected:
     // reimplemented from parent class
     void contextMenuEvent(QContextMenuEvent* event);
     void keyPressEvent(QKeyEvent* event);
+    void leaveEvent(QEvent* event);
     void mouseMoveEvent(QMouseEvent* event);
     void mousePressEvent(QMouseEvent* event);
     void mouseReleaseEvent(QMouseEvent* event);

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #33 from Gilles Caulier <[hidden email]> ---
Git commit 6c9241b209855a40a731b1918eff0c5d557f6e94 by Marcel Wiesweg.
Committed on 15/11/2014 at 17:16.
Pushed by mwiesweg into branch 'master'.

Support listing of images on not-available collections

M  +3    -1    kioslave/digikamalbums.cpp
M  +1    -0    kioslave/digikamdates.cpp
M  +1    -0    kioslave/digikammapimages.cpp
M  +1    -0    kioslave/digikamsearch.cpp
M  +2    -0    kioslave/digikamtags.cpp
M  +10   -0    libs/database/imageinfo.cpp
M  +7    -0    libs/database/imageinfo.h
M  +25   -4    libs/models/imagealbummodel.cpp
M  +2    -0    libs/models/imagealbummodel.h

http://commits.kde.org/digikam/6c9241b209855a40a731b1918eff0c5d557f6e94

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #34 from Gilles Caulier <[hidden email]> ---
Git commit 44ed4eacf9c9439c3b892f9a3a65c9231dd88e28 by Marcel Wiesweg.
Committed on 15/11/2014 at 17:16.
Pushed by mwiesweg into branch 'master'.

Enable showing albums on collections which are not available (removable media)
There is currently no option in the UI to switch this off,
though there is a simple method in album manager to toggle this setting

M  +120  -21   app/album/albummanager.cpp
M  +6    -0    app/album/albummanager.h

http://commits.kde.org/digikam/44ed4eacf9c9439c3b892f9a3a65c9231dd88e28

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=191494

--- Comment #35 from Gilles Caulier <[hidden email]> ---
Git commit 8fa0304a3144cbf9da29a734622fa6f501c4a1b6 by Marcel Wiesweg.
Committed on 15/11/2014 at 17:17.
Pushed by mwiesweg into branch 'master'.

If the user tries to open an image which is not availabe, display a tooltip to
explain the situation

M  +5    -0    app/items/imagecategorizedview.cpp
M  +2    -0    app/items/imagecategorizedview.h
M  +14   -5    app/views/digikamview.cpp

http://commits.kde.org/digikam/8fa0304a3144cbf9da29a734622fa6f501c4a1b6

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel