Bug 135613 - more than one database
Summary: more than one database
Status: CONFIRMED
Alias: None
Product: kphotoalbum
Classification: Applications
Component: Backend (show other bugs)
Version: unspecified
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: Tuomas Suutari
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-10-14 10:15 UTC by Tomasz Padzik
Modified: 2012-10-05 07:14 UTC (History)
7 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tomasz Padzik 2006-10-14 10:15:49 UTC
Version:            (using KDE KDE 3.5.4)
Installed from:    Gentoo Packages
OS:                Linux

As in subj.
Use separate databases for separete folders. File->new database, File->open etc.
Comment 1 Shawn Willden 2007-05-10 21:24:39 UTC
Can you define a use case for multiple databases?  The purpose of KPA is to make it easy to aggregate all of your images and then find whatever you're looking for quickly.  If you really need to segment your images, you can put them in different folders and then drill into the desired set using the folders category.  Does that not accomplish the same goal?
Comment 2 Tuomas Suutari 2007-05-10 21:44:51 UTC
I will have to implement this feature anyway for the SQL backend. Converting data from XML to SQL requires two different databases to be open at the same time, so it needs multiple database support.

With SQL backend there are more use cases too: Having separate image collections on different servers for example.
Comment 3 Jan Kundrát 2007-05-10 23:11:56 UTC
CCing Jesper back so that people watching him get mail notifications.
Comment 4 Ritesh Raj Sarraf 2007-05-18 16:03:13 UTC
Hi,

I wanted to file a new feature request but I'll see if what I'm requesting falls under this category.

I agree with Comment #1 about keeping simplicity. That's exactly what the goal of kphotoalbum is. I see only one difficulty currently. Say if I have images in folder A and videos in folder B and the database backend was created with the path "Folder A", then I don't see a clean and simple way of telling KPA to keep an eye on "Folder B".

What I'm simply requesting for is Amarok's library management.
In Amarok, I can specify multiple folders at different locations telling amarok that all of them contain music and that it should monitor all those folders for activity.

Can we have this feature ? It'd be great.

Thanks, Ritesh
Comment 5 Baptiste MATHUS 2007-05-18 16:08:14 UTC
Please almost never hesitate to file a feature request (a wishlist in this bug tracker vocabulary) :), because anyway, the entered so called bug are then to be sorted and readed. So, they'll be reput in the right category if needed.

So, to sum up. Please file a separate bug so as not to mix things with the current bug. 

Thanks.
Comment 6 Jan Kundrát 2007-05-18 17:48:05 UTC
Actually this is report is likely what Ritesh would like to see. As a quick workaround befoer KPA supprts that, you can always add a sylink "videos" to directory A pointing to directory B.
Comment 7 Risto H. Kurppa 2010-07-18 07:54:48 UTC
I guess this sits here waiting for the SQL backend to mature?
Comment 8 Tobias Leupold 2010-11-06 19:21:21 UTC
I would also like to see different databases. Simply one database per base diectory. If one defines multiple base directories, KPA should simply ask which one to use at startup. This won't address the issue described in comment #4, but if one has e. g. a "private" and a "business" collection or so, it would be cool to have multiple selectable base directories.
Comment 9 Joe 2012-01-08 07:55:34 UTC
I keep my photos on a usb disk that is often not mounted.  I'd like KPhotoAlbum to be able to use a directory on my local disk *and* be able to (automatically) access the usb drive when it's present.  This should be implemented in some way so that KPA doesn't "thrash" my index files by deleting all the entries for pictures on the usb drive when it's not there and then adding them all back in when it is mounted.  Maybe the file tree (or whatever the internal data structure is) could have certain branches marked as "remote" so that they get ignored when they're not there and used when they are.

I have exactly the same issue with Amarok.
Comment 10 Andreas Schleth 2012-10-04 18:31:45 UTC
Here is a usecase for multiple databases:

We use Kphotoalbum within a family of 5 users.  The setup is multiple PCs and a central server where the /home dir sits.  Everybody sees the same files independent of the PC he/she is sitting at.

Everybody has its own album to keep large "gifts" (eg. a CD with images from a school outing) from crowding our family album.
Additionally we keep a shared family album where the good images from everybody go (copy via import/export).  This is where we look for pictures to show/print.
I even keep several albums: one for digital fotos (~20k images, tagged with KPA since 2005), one for my slide scans (~10k)

The various albums are used by more or less everybody.  Therefore we use rw-rw---- permissions for all files and the ownership of files vary inside one dir.  This is messy but OK for us.

I would greatly appreciate a solution that would make the cumbersome export/import step unnecessary.  
It would be nice to be able to share or reconcile category names and image tags between databases (our tags tend to diverge).

[[Did you know, that the WAF of KPA ist really good?  Firefox, Thunderbird, Office, Kphotoalbum]]
Comment 11 Jesper Pedersen 2012-10-05 07:14:33 UTC
Thanks for a very elaborate email.

To be honest, I'm afraid your usecase is so specific that you will find it 
difficult to find any developers with the same need (which unfortunately is 
what drives development)

Just in case you don't know, you can use different databases by specifying the 
-c option to KPA: kphotoalbum -c private_colleciton.xml

Cheers