Daily discussion thread
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!
write
preview
31 sats \ 0 replies \ @BlokchainB 3 Apr 2022
AMA ON SN is 🔥
reply
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.
reply
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).
reply
0 sats \ 1 reply \ @BlokchainB 3 Apr 2022
What’s the difference better post and recent?
reply
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
reply
0 sats \ 0 replies \ @k00b 3 Apr 2022
There are still 2 queries that can probably be improved a lot:
  1. 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
  2. denormalizing some of the notifications
reply
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...
reply