Hacker News Reader

Comment by NicoJuicy | Hacker News Reader

RSS is the core of my Reddit alternative. Still improving performance though http://handlr.sapico.me/Home/Newest

I currently use it for personal bookmarking and posting stories to HN.

It's based on tags, eg. http://handlr.sapico.me/Home/ByTag?Name=artificial-intellige...

Ps. Performance is slow on the main page for sorting calculated columns ( eg. The Algorithm ), that's why I linked to the newest page

View on HN

The "receive new content" modal is really annoying. It appears every time my mouse exits through the top of the page, so it pops up every time I change tabs.

Yeah, I use it for myselve and I'm always logged in ( doesn't happen then). Will change that after improving performance

Same here. I had used RSS less frequently as I used aggregators like Digg and Reddit more. But after leaving reddit last month I found a lot of the old URLs had decayed.

No problem. Most had just moved URL slightly or changed format so finding them on the http site was easy enough. And while finding the new RSS URLs I often checked out the entire blogroll/webring/etc too and found new feeds to subscribe to.

For me RSS is wasn't ever dead. But it may have been left to itself in the nursing home for a few years.

I think we killed it :)

Back alive atm ( disabled RSS sync :p )

If anyone knows how to performantly sort on non deterministic computed columns ( eg. the ranking algorithm for votes of posts + comments) in MS SQL server -> https://dba.stackexchange.com/questions/203331/slow-calculat... i'd be very happy :p, it's killing my "trending topic" performance...

Edit: added non deterministic

You don't do the calculation on the fly, you do it at data mutation time (if the column should be the same for every client) or in a separate "thread" (eg, a script). Basically, you pre calculate the column and simply add it to your table, indexed.

It's non deterministic because it has a time variation ( newer posts get ranked higher).

Even then?

Don't modify the scores of old posts, start newer ones with a higher score.

Check out how reddit does it: https://medium.com/hacking-and-gonzo/how-reddit-ranking-algo...

The concept is that the time-based part of the score is immutable, fixed at post creation time.

That way you only have to recalculate when a score-modifying event occurs, not every time the page is refreshed.

Good advice, thx!

you've got to double tap to make sure, rules of surviving rss is undead land.

Reply on news.ycombinator.com