books/README.md

45 lines
1.6 KiB
Markdown
Raw Permalink Normal View History

2021-04-17 15:44:50 +00:00
# Books
This is a catalog of all the books in my calibre library!
If you see a title here you would like to borrow, let me know! I'd be happy to share :)
2022-03-31 15:24:47 +00:00
## How To (For me)
- go to calibre and "convert books" -> "create a catalog...."
- save it to the dir
- `j all`
## How To (For you)
2021-04-17 15:44:50 +00:00
2022-10-29 16:24:57 +00:00
If you want to browse the collection, I would look at `books.rec`.
If you're going to really explore this dataset, I recommend using the awesome csvkit.
2021-04-17 15:44:50 +00:00
=> <https://csvkit.readthedocs.io/en/latest/index.html>
It will allow you to do stuff like:
- see the headers: `csvcut -n books.csv`
- and the see just the columns you want: `csvcut -c 13,4 books.csv`
- look at some stats: `csvcut -c languages,size,formats books.csv | csvstat`
- find the largest pdfs in the collection: `csvcut -c title_sort,formats,size books.csv | csvgrep -c formats -m pdf | csvsort -c size -r | head`
- `csvjson books.csv | jq | whatever`
2021-05-09 17:16:24 +00:00
- show the most recently added books: `csvcut -c 13,1,3 books.csv | csvsort -c timestamp -r | head -n 20`
2021-04-17 15:44:50 +00:00
- You can also perform actual SQL queries on it, and convert the data between csv and sqlite database: <https://csvkit.readthedocs.io/en/latest/tutorial/3_power_tools.html>
2021-04-17 16:48:15 +00:00
## RSS feed
An RSS feed has been kindly provided by [the Rsszard of Syndication](https://tilde.town/~lucidiot)
2021-04-17 17:01:19 +00:00
and is available at https://git.tilde.town/dozens/books/raw/branch/main/feed.xml
2021-04-17 16:48:15 +00:00
Generating the feed requires you to have Python 3.7 or later installed, as well
as the [xmltodict](https://pypi.org/project/xmltodict) package:
`pip3 install xmltodict`.
To generate the feed, run `./geenfeed.py <books.csv >lefeed.xml`.
2022-10-29 16:24:57 +00:00
## TODO
- type definitions for Book