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 \ 6 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.
reply
0 sats \ 1 reply \ @Undergotten 31 Mar 2022
What's WoT?
reply
0 sats \ 0 replies \ @k00b 31 Mar 2022
https://stacker.news/search?q=wot
reply
5 sats \ 3 replies \ @k00b 31 Mar 2022
Oh man, I've started actually looking at query performance and have already found 4 really bad ones.
reply
0 sats \ 2 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
reply
4 sats \ 1 reply \ @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
reply
22 sats \ 0 replies \ @k00b 31 Mar 2022
The AMA made the DB scream
![]()
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.
reply
42 sats \ 5 replies \ @Martin 31 Mar 2022
What sites do you guys use to earn sats on a daily basis?
Please share 🙏🏾...
reply
10 sats \ 0 replies \ @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.
reply
0 sats \ 0 replies \ @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.
reply
21 sats \ 2 replies \ @TheBTCManual 31 Mar 2022
We've curated these - https://thebitcoinmanual.com/apps/earn-btc/
if anyone knows of any others we'll happily add them to the list
reply
32 sats \ 1 reply \ @cointastical 31 Mar 2022
Cool!
Maybe add ~jobs to the What are bitcoin jobs?!
reply
10 sats \ 0 replies \ @TheBTCManual 1 Apr 2022
Thanks will add it in a bit
reply