Create Shelve based on Tags data from Calibre meta.db

[himlotia]

Hi,
Just request / suggestion to solve, shelve problem.

Just playing with Sqllite database, can you create some sort of script or button , where as setup new shelf automatically get created based on tags. For example, using Tags table, whatever tags is present in that table, should able to automatically convert in shelf.
Books_tag_link table will feed details of books which should be in that shelf. If user wants to create new custom or delete shelf than entry in shelf table should be created otherwise, by default whatever in above tables (tags & books_tag_link) should be the default entry to shelf table.

That way, every book which get entered in calibre with correct metadata (especially in tags), should be on shelf & it will resolve currently open issue that people can not find book which is not allocate on shelf (SELECT books.id, books.title
FROM books LEFT JOIN book_shelf_link ON books.[id] = book_shelf_link.[book_id]
WHERE (((book_shelf_link.book_id) Is Null));

Hope this helps.

[Yann-J]

Fully support this, in fact I had suggested a similar feature request in #1129

The current Shelves concept is calibre-web-specific, and makes it less portable to other Calibre-based apps and clients, so a solution based purely on the Calibre sqlite data (tags, author...) would be really nice...

[HStep20]

Id love to see a sort of 'smart shelf', like Plex does with Smart Collections, where you can set parameters for the shelf, and new books get added as the metadata of the item changes. This would be especially useful for keeping Read/Reading/To Read shelves up to date based on a column in Calibre, instead of having to manually manage, or mass add, books with the Advanced Search option