|
Yes indeed that is a big gotcha about sqlite, especially if you are used to more strict RDBMSes. calibre is actually designed to do most data manipulation on an in-memory data structure, not via SQL operations, it just uses SQLITE as dumb store. The main exception to that being full text search, though even there the tokenization is actually done by cusotm code I wrote not the sqlite tokenizer.
|