Here's a horrifying idea for setting series info on initial book upload.
What if the calibre driver created a SQL trigger (may be an INSTEAD OF, or AFTER INSERT?) for each book it sends, with the appropriate series metadata. That way, when Nickel imports books, the SQL triggers fire and updates the record where appropriate.
I have no idea what the (ongoing) performance impact might be, as I don't know if there is a way of automatically dropping a trigger after it's been successfully fired.
Ugh... I feel filthy just thinking about it. Shower time methinks!
|