I have close to 900 submissions marked as favorite on HN. I'm trying to find all SQL related submissions from this list. Is there a quick way to search without scanning through 30 pages?
Ask HN: How to you manage your favorite HN submissions?
1–9 of 9 posts
Re: Ask HN: How to you manage your favorite HN submissions?
#2I set up a job posting sentiment analysis ML app on the Who's Hiring post recently and use a the public firebase REST API: https://github.com/HackerNews/API . It mostly works for my usecase but its search capabilities are severely lacking over REST so might not be the best in your case. I never got around to trying a firebase client so I have no clue if it interacts with a different interface, might be worth taking a quick look at.
Re: Ask HN: How to you manage your favorite HN submissions?
#3Since HN is such a beautiful old school websites, the pages of your submissions are denoted in the URL like https://news.ycombinator.com/favorites?id=YOURNAME&p=PAGENUM....
So you could just loop said page number in your favorite language, access the generated webpage and get the raw HTML. If you get all lines of class "storylink" and "title", you will have all the post titles and where they link. Save that into any format as simple as Excel and you have a nice searchable overview.
Always rate limit yourself sensibly when web crawling, and have fun!
Re: Ask HN: How to you manage your favorite HN submissions?
#4I have a service, on the way to do so. leave your email, and will send you mail when ready. thanks
Re: Ask HN: How to you manage your favorite HN submissions?
#5I wrote some tools to export your HN favorites to CSV or HTML in both JavaScript and Python.
Check out https://gabrielsroka.github.io/getHNFavorites.js or to view the source code, see JS: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... or Python: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/...
Previous discussion, other tools and more info:
https://news.ycombinator.com/item?id=22788236
Maybe I should add a SQL interface ;)
select *
from favorites
where username = 'amzpix' and
title like '%SQL%';Re: Ask HN: How to you manage your favorite HN submissions?
#6I wrote some tools to export your HN favorites to CSV or HTML in both JavaScript and Python. Check out https://gabrielsroka.github.io/getHNFavorites.js or to view the source code, see JS: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... or Python: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... Previous discussion, other tools and more info: https://news.ycombinator.com/item?id=22788236…
This worked perfectly! I found what I was looking for. Thank you so much for writing this and sharing with others.
Re: Ask HN: How to you manage your favorite HN submissions?
#7I wrote some tools to export your HN favorites to CSV or HTML in both JavaScript and Python. Check out https://gabrielsroka.github.io/getHNFavorites.js or to view the source code, see JS: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... or Python: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... Previous discussion, other tools and more info: https://news.ycombinator.com/item?id=22788236…
This worked perfectly! I found what I was looking for. Thank you so much for writing this and sharing with others.
You're welcome. I just added a little search feature (in the spirit of my bad SQL joke above) to the JS version. It uses a JS regex.
Re: Ask HN: How to you manage your favorite HN submissions?
#8ripgrep + fzf = love
Re: Ask HN: How to you manage your favorite HN submissions?
#9I wrote some tools to export your HN favorites to CSV or HTML in both JavaScript and Python. Check out https://gabrielsroka.github.io/getHNFavorites.js or to view the source code, see JS: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... or Python: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/... Previous discussion, other tools and more info: https://news.ycombinator.com/item?id=22788236…
Neat, thanks very much.