So maybe my search-and-replace code "kung-foo" isn't as sharp as I wish
Using that search-and-replace window somehow managed to embed the title of the book ... within the tags of the book
in most of my library of 7,000 books
====
Honestly, I'm shy about using that window again unless I preface it with a filtering of book selection in the main window ahead of time
====
(full disclosure: I made a copy of the metadata.db file and explored the copy with SQLite Browser... this is my disposable copy)
Question for you (kovidgoyal) directly... just curious... what would happen if I manually deleted the rows with title text in the metadata.db/tags table?
Would the database see the missing rows and freak out or would there be corrective action -- interpreting the missing rows as negated tags?
~~~~
I figured deleting the rows in "tags" table would be easier than a higher complexity full-on-sql search syntax between the table relationships :-?
|