View Single Post
Old 12-08-2018, 04:59 PM   #11
sherman
Guru
sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.sherman ought to be getting tired of karma fortunes by now.
 
Posts: 876
Karma: 2676800
Join Date: Aug 2008
Location: Taranaki - NZ
Device: Kobo Aura H2O, Kobo Forma
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!
sherman is offline   Reply With Quote