Title: HN is a treasure trove of information. The primary way I read HN is to bookmark stories and read the comments when the discussion is complete. Others actively participate. Some get jobs via &quot;Who is hiring?&quot;. We all use HN differently.<p>There are ways to read HN other than this website. However, I have not found one that meets all of these requirements:<p><pre><code>  - Self-hosted.
  - Offline access of data.
  - Query data via SQL.
  - Full text search of stories and comments.
  - Notification of replies to comments.
</code></pre>
Some ideas:<p>1) A tool that maintains a copy of the HN API[1] in an SQLite database, with indexing and full-text search[2]. This supports the development of the other tools.<p>2) A command line tool that demonstrates how to use the database and supports the development of scripts. For example:<p><pre><code>  #!&#x2F;bin&#x2F;sh
  # Run notify whenever someone replies to a comment.
  $ hn replies username | notify
</code></pre>
3) A web UI for browsing and searching. This can be hosted locally or on a remote server.<p>What features interest you?<p><pre><code>  [1]: https:&#x2F;&#x2F;github.com&#x2F;HackerNews&#x2F;API
  [2]: https:&#x2F;&#x2F;www.sqlite.org&#x2F;fts5.html</code></pre>
Upvote: