3 ms·
I have a custom tool for this: https://datasette.io/tools/hacker-news-to-sqlite https://datasette.io/tools/hacker-news-to-sqlite It provides me with a command-
by simonw 5y ago
I have a custom tool for this: https://datasette.io/tools/hacker-news-to-sqlite https://datasette.io/tools/hacker-news-to-sqlite
It provides me with a command-line utility for fetching all of the comments in a particular thread into a SQLite database, for example:
hacker-news-to-sqlite trees hacker-news.db 27897211
For threads that I'm actively involved in (probably no more than a few times a year) I will run this script about once an hour - then I can use "select * from items order by time desc" (usually in Datasette) to see the most recent comments.
(The initial goal of the tool was to archive my own comments, which can be done with "hacker-news-to-sqlite user hacker-news.db your-username" - I run that on a cron)