View Single Post
Old 09-01-2010, 04:01 AM   #12
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,893
Karma: 1216548
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by dmapr View Post
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.

Last edited by chaley; 09-01-2010 at 04:45 PM.
chaley is offline   Reply With Quote