Sorting, grouping in web ui

[ckuethe]

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.