|
Several tables, including books, use sqlite triggers that ensure the data written to the table are correctly processed. The triggers reference functions in calibre's db layer, for example title_sort(). This is why using SQL browsers to modify the db often doesn't work. The only safe way to do it is by using calibre's API via a python script run with calibre-debug or via a python template.
|