This seems to work fine, at least to initially enable the abstract query functionality and close #20 (full text search can be made a separate issue, if needed). An extension could be to have some way of limiting the query to a subset of title, authors, and abstract.
I tested a handful of queries in terms of speed between retrieving from a database with and without abstracts. There was no noticeable difference, queries took around 0.55 - 0.65 s in almost all cases.
For my library of ~500 items, the index.sqlite database is about 5x bigger with abstract. It went from 244K to 1.3M.
This seems to work fine, at least to initially enable the abstract query functionality and close #20 (full text search can be made a separate issue, if needed). An extension could be to have some way of limiting the query to a subset of title, authors, and abstract.
I tested a handful of queries in terms of speed between retrieving from a database with and without abstracts. There was no noticeable difference, queries took around 0.55 - 0.65 s in almost all cases.
For my library of ~500 items, the
index.sqlite
database is about 5x bigger with abstract. It went from 244K to 1.3M.