MobileRead Forums - View Single Post

PaleoRDR · 03-22-2010, 10:20 PM

I also would like to be able to "bulk" delete all tags from my Calibre database, whether by a direct database update or by going through the GUI. What I'm finding is that Stanza does not actually make use (apparently) of the series and sequence information within the Calibre database, but the tags field is imported into stanza and used as a sortable subject field. If there were a simple way to eliminate all the existing garbage in the Tags fields, then I'd use that field to hold series/sequence information instead. Unfortunately, there doesn't appear to be a way to "bulk" delete except by specific Tag - and there's got to be at least several hundred unique tags in my db. I've currently got in excess of 2000 ebooks loaded into Calibre, and the cleanup is going to be a pain. Is there an interactive SQL interface for the db engine?

03-22-2010, 10:20 PM	#3
PaleoRDR Stone Tablet Reader Posts: 7 Karma: 10 Join Date: Mar 2010 Location: USA Device: iPhone	I've been asking the same question. I also would like to be able to "bulk" delete all tags from my Calibre database, whether by a direct database update or by going through the GUI. What I'm finding is that Stanza does not actually make use (apparently) of the series and sequence information within the Calibre database, but the tags field is imported into stanza and used as a sortable subject field. If there were a simple way to eliminate all the existing garbage in the Tags fields, then I'd use that field to hold series/sequence information instead. Unfortunately, there doesn't appear to be a way to "bulk" delete except by specific Tag - and there's got to be at least several hundred unique tags in my db. I've currently got in excess of 2000 ebooks loaded into Calibre, and the cleanup is going to be a pain. Is there an interactive SQL interface for the db engine?