So I built a bulk book loader (see #2) to ingest a large directory of books...
sqlite> select count(*) from books;
7031
Unfortunately they appear to be inserted by inode order, since I just recursively walked the file directory and inserted book/file records based on whatever order readdir(3) returns them. When I load the web ui, I don't see any way to sort, filter, or group by various attributes, eg. can't search search for "author:smith", "publisher:nostarch", or "date:2019", ...
If I search for "Collins", I get matches both for books published by "HarperCollins" and authors named "Collins"... which is fine since I didn't/can't restrict to just searching on author, title, publisher, or description.
So I built a bulk book loader (see #2) to ingest a large directory of books...
Unfortunately they appear to be inserted by inode order, since I just recursively walked the file directory and inserted book/file records based on whatever order
readdir(3)
returns them. When I load the web ui, I don't see any way to sort, filter, or group by various attributes, eg. can't search search for "author:smith", "publisher:nostarch", or "date:2019", ...If I search for "Collins", I get matches both for books published by "HarperCollins" and authors named "Collins"... which is fine since I didn't/can't restrict to just searching on author, title, publisher, or description.