Suppose I have lots of key-value metadata that I wish to store for one or more books in my library. I do not know in advance what the keys will be, and there may be many of them, hundreds or thousands. The keys are small (word-sized) strings, and the values are integers.
Is there a better way of storing this information than as JSON-encoded data in a long-text (like comments) column?
Suppose further that I wish to store a similar set of key-value data, scoped to my whole library (or possibly one virtual library), rather than any one particular book. Does the Calibre plugin API offer any way of storing metadata for a library, instead of for a single book?
Thank you in advance.