Recording anthologies of stories

[Bill Gee]

Hi Robby -

Thanks!  I suspected this would be the case.  I think a comprehensive 
solution requires a relational database.  XML is just not up to the 
task.  That, in turn, makes the front-end application far more complex.

I also have an extensive music collection, nearly 5000 albums.  Two 
similar problems exist in that.  First, if any one album is given more 
than one disk, then EVERY album has more than one disk.  I have at least 
one album (a collection of Bach organ pieces) which has 18 disks.

Second, I would like to be able to get a list of songs.  It would be 
interesting to know, for example, which artists have recorded "Comes Love".

Also in a music collection, there are anthologies of music which have 
the same issues as anthologies of books.

Back in the day, like 20 years ago, I used a program called CATraxx32 to 
manage my music collection.  It is incredible what that program could do 
back then.  Unfortunately it is Windows-only.  The back-end database 
back then was Access.  I don't know what they use now.  CATraxx32 was 
one of the losers when I moved to Linux.

===============
Bill Gee

On 12/6/25 07:56, Robby Stephenson wrote:
> HI Bill,
> 
> On Thu, Dec 4, 2025 at 4:17 PM Bill Gee <bgee at campercaver.net> wrote:
>> I am looking for some advice on how to handle anthology books such as
>> collections of short stories.  I would like to have an entry for each
>> story and also an entry that collects them into a single bound volume.
>>
>> Each story should have at least a title, copyright date and author.  The
>> bound volume should have a title, ISBN and editor.
> 
> I wish I had a better answer right now, but Tellico doesn't do much in
> that regard. There are a couple of related wishlist bugs, for having a
> met-entry of sorts (https://bugs.kde.org/show_bug.cgi?id=255937) and
> for linking between entries
> (https://bugs.kde.org/show_bug.cgi?id=495726) that would help. but I
> haven't implemented them yet.
> 
>> It seems this has some similarities to a music collection where each
>> album can have a collection of tracks.  The analogy is not perfect,
>> though.  A major weakness I see is no way to get a list of all tracks
>> across all albums, sorted by artist.
> 
> Right, no way to really do that. The only small bit of functionality
> that Tellico offers is that if the table field is formatted as a name,
> then those names are included in the "People" grouping. That's how the
> video collection manages the Cast field, for example. So you could
> have a "Short Stories" field with 3 columns, author/title/date. It
> would take some work to create a report that pulls out the story
> titles across all books, sorted by author.
> 
> I'll see if I can take a whack at the report building, or another look
> at those wishlist items. Maybe there's some progress to be made there.
> I haven't thought through it in a little while.
> 
> Robby