3 ms·
RSS is the core of my Reddit alternative. Still improving performance though http://handlr.sapico.me/Home/Newest http://handlr.sapico.me/Home/Newest I currentl
by NicoJuicy 9y ago
RSS is the core of my Reddit alternative. Still improving performance though http://handlr.sapico.me/Home/Newest 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-intelligence 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
- dc_gregory 9y agoI think we killed it :)
- bryanrasmussen 9y agoyou've got to double tap to make sure, rules of surviving rss is undead land.
- NicoJuicy 9y agoBack 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-calculated-sort-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
- pbalau 9y agoYou 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.
- NicoJuicy 9y agoIt's non deterministic because it has a time variation ( newer posts get ranked higher). Even then?
- erpellan 9y agoDon'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-algorithms-work-ef111e33d0d9 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.
- NicoJuicy 9y agoGood advice, thx!
- JD557 9y agoThe "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.
- NicoJuicy 9y agoYeah, I use it for myselve and I'm always logged in ( doesn't happen then). Will change that after improving performance
- superkuh 9y agoSame 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.