Daily discussion thread \ stacker news

pull down to refresh

27 comments \ @saloon 31 Mar 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!

22 sats \ 13 replies \ @k00b 31 Mar 2022

I think I'm done with this round of tuning WoT ... we'll go from 100+ fully trusted users to ~10 with a long tail of partially trusted users. The biggest impact of this will be on earning, and on getting a post into the front page without more users upvoting it ... it might be a little too aggressive wrt front paging an item but I can tune it to trust more users if need be.

0 sats \ 3 replies \ @Undergotten 31 Mar 2022

What's WoT?

0 sats \ 1 reply \ @k00b 31 Mar 2022

https://stacker.news/search?q=wot

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

5 sats \ 7 replies \ @k00b 31 Mar 2022

Oh man, I've started actually looking at query performance and have already found 4 really bad ones.

0 sats \ 5 replies \ @k00b 31 Mar 2022

DB is also using a lot of CPU as of yesterday too (unrelated to queries because queries haven't changed). Lots to do

4 sats \ 3 replies \ @k00b 31 Mar 2022

Plan for speeding up the site which I should be able to do before Miami:

bigger DB instance
if I can't further optimize queries, denormalize some of the data in the DB ... right now two aggregate queries dominate the CPU of the DB: the front page query for items (most of the time is spent counting all votes for items) and counting comments for items ... I hate denormalizing data but it'll work

22 sats \ 1 reply \ @k00b 31 Mar 2022

The AMA made the DB scream
https://snimgs.s3.amazonaws.com/cpus.png
The left axis is CPU "demand". The dotted line is the number of CPUs we actually have - 2. The blue in each bar are queries for the front page. The yellow is counting the comments for each item on the front page.

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

42 sats \ 11 replies \ @Martin 31 Mar 2022

What sites do you guys use to earn sats on a daily basis?
Please share 🙏🏾...

10 sats \ 1 reply \ @Undergotten 31 Mar 2022 freebie

This is the first site I've ever used where that is possible. Love the idea of this site, too, for a lot of reasons. I wish this would replace reddit.

0 sats \ 0 replies \ @247bf84fda 25 Aug 2025 freebie

deleted by author

0 sats \ 1 reply \ @cointastical 31 Mar 2022

Not sure if this is what you are looking for, ... but I'll share it:

Freelancing platforms which pay in Bitcoin
https://cointastical.medium.com/freelancing-platforms-which-pay-in-bitcoin-e38be56166df

For the most part, .... earning sats is done the same way you earn fiat. Provide value -- either by selling goods and services, or by investing capital and earning a return.

Because bitcoin is still not reached mass adoption, it can be actually quite a bit harder in many ways to earn bitcoin than it is to earn in fiat.

But as more people have either bitcoin accumulated from investment wealth or they earn a salary in bitcoin, etc. a circular economy will form further, and earning in bitcoin will become easier.