Honestly the HN archive is very valuable. If you had it all on a local db with everything indexed you basically end up with a offline search engine.
Where is this archive located you speak of?
It's on firebase, per https://github.com/hackernews/api
found : https://huggingface.co/datasets/open-index/hacker-news
It's on firebase, per https://github.com/hackernews/api