Daily discussion thread \ stacker news

pull down to refresh

7 comments \ @saloon 3 Apr 2022 \ yesterday

This is a thread for random discussions that gets posted everyday at 5am central.

Tell us what you're doing today, ask questions, or vent about your life. Whatever you want, let it rip!

31 sats \ 0 replies \ @BlokchainB 3 Apr 2022

AMA ON SN is 🔥

22 sats \ 5 replies \ @k00b 3 Apr 2022

Something kind of neat about Stacker News daily earning that I didn't realize until after it was implemented: it's implicit staking. We could at some point increase the cost to post/comment and because those sats are redistributed to the most trusted users, they will get those sats back and more.

31 sats \ 3 replies \ @k00b 3 Apr 2022

So happy.

I made the front page query much faster yesterday after fixing 2 things:

removing the sub-query and replacing it with a join
fixing a hack that I implemented wrong and was causing the front page query to execute twice when loaded

I made comments much faster today by using a lateral join of the subquery instead of a normal join ... when using the normal join I had to compute the entire subquery (very expensive) , but with the lateral join I can filter the subquery for just the stuff that I want (children comments) ... I did still have to use a subquery because the comments query is recursive and you can't use aggregates in a recursive query (but you can in a subquery).

0 sats \ 1 reply \ @BlokchainB 3 Apr 2022

What’s the difference better post and recent?

1 sat \ 0 replies \ @k00b 3 Apr 2022

Do you mean top? Recent are recent posts (sorted by time). Top are the posts that did the best for a give period of time

Post takes you to a form to create a new post

0 sats \ 0 replies \ @k00b 3 Apr 2022

There are still 2 queries that can probably be improved a lot:

determining how much a user has stacked - we currently sum up all tips they've received to do this ... we should just denormalize this ... this will shockingly save us >50ms per request for mature users
denormalizing some of the notifications

21 sats \ 0 replies \ @Martin 3 Apr 2022

Awesome idea, I'm all for it... I love the concept of sharing the fees among users... Thanks for such a brilliant platform... Stacker News is the future...