Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 01-04-2020, 11:31 AM   #271
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 1,612
Karma: 255700
Join Date: Aug 2013
Location: Texas
Device: 10" Win10 Tablet w/Calibre64, CalibreSpy & Freda+
Read the Menu ToolTips

Quote:
Originally Posted by Angelo.Mascaro View Post
I searched the table _mcs_authors_by_book with DB Browser for SQLite with this query:
SELECT authorname, count(book) AS totalbook
FROM _mcs_authors_by_book
GROUP BY authorname
ORDER BY totalbook DESC
because I wanted to know the authors with more books.
I discovered that this table does not reflect the true content of the library and all the deleted/moved books are still considered. The field book in this table points to id of books that are no longer in the table books.
Would it be possible to fix this modifying the TRIGGER books_delete_trg in one of the next versions? Or maybe there is a way to realign the table to the library?

If you bother to read the MCS icon menu's tooltips, you will discover that the MCS search acceleration tables are automatically maintained by MCS. In other words, you have to actually use MCS to have MCS keep them refreshed and up-to-date.




DaltonST

Last edited by DaltonST; 01-04-2020 at 12:28 PM.
DaltonST is offline   Reply With Quote
Old 01-13-2020, 01:28 PM   #272
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,280
Karma: 5306
Join Date: Jan 2014
Device: none
Quote:
Originally Posted by DaltonST View Post
[1] The unique similarity group ID custom column is tag-like, so there only needs to be one (1) of it. To compare multiple columns for each book, simply execute the query for each column sequentially. The image shows that many queries for different comparison value columns have already been executed, with the many unique similarity group IDs for each book, if any, so indicated.


[2] The Value Comparison Percentage specifies how similar a comparison value has to be for one book to another book for a specific comparison value from the specified comparison value column. 100% means "identical".


Attached is an example that includes the Debug Log.

DaltonST
Would it be possible to add the percentage from the debug-log to Calibre? Or base the different tag-names on the percentages?

If it's a 100% match: Title_100_1 or so?
Tanjamuse is offline   Reply With Quote
Reply

Tags
columns, search

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Walk Search History kiwidude Plugins 13 01-17-2020 11:55 PM
[GUI Plugin] Search the Internet kiwidude Plugins 319 12-18-2019 04:20 PM
[GUI Plugin] Recoll Full Text Search Satas Plugins 16 08-05-2016 04:54 AM
[GUI Plugin] Full Text Search (SOLR) peterpisljar Plugins 2 08-09-2015 09:16 AM
[GUI Plugin] Clipboard Search kiwidude Plugins 9 08-12-2014 04:36 AM


All times are GMT -4. The time now is 07:24 AM.


MobileRead.com is a privately owned, operated and funded community.