Quote:
Originally Posted by dmapr
Hmm… So, the collapsing of multiple series columns into a single collection when transferring to the reader — would that be done in Calibre or in the device plugin? If the latter, perhaps there could be a second Sony plugin with the collapsing behavior? That way it will not be interfering with the Calibre proper.
|
It is in the USB base plugin, which the sony plugin inherits from.
I would prefer a tweak over duplicating the driver.
Quote:
I wonder what the reason for the current schema is. The book-to-series has been set up as a many-to-many relationship and would've been complete had the series_index been also part of the books_series_link table instead of books table. Just out of curiosity — why was the series index not made a part of the link table?
|
The series index for custom columns is in the link table.
Kovid made a fundamental choice early in calibre's development, to use a denormalized view as the interface between the GUI and the DB. This choice makes a lot of sense when using a tabular interface vs a forms interface. A consequence is that there is a view column per display/sortable/searchable column. Naturally multiple fields like tags and authors are collapsed into a single comma-separated list.