View Single Post
Old 01-21-2023, 11:59 PM   #1
isarl
Addict
isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.isarl ought to be getting tired of karma fortunes by now.
 
Posts: 292
Karma: 2534928
Join Date: Nov 2022
Location: Canada
Device: Kobo Aura 2
Storing key-value metadata (for books, and for a whole library)

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.
isarl is offline   Reply With Quote