Howdy there, partner! Welcome on into the Stacker Saloon.
Saddle on up to a stool and spill the beans about your day, fire away with them questions, or let loose and give us the lowdown on your wild and woolly life. We're all ears, so don't hold back!
We're open round the clock, so mosey on in whenever you please!
Alright, just touched up the outline for my short story.
Its looking a lot better, and i'll probably have the whole thing finished by the end of the year.
I have 12 chapters planned out separated into 4 sections.
Right now the title is "The Cannibal Bus" Its aspiring to be something like The Wizard of Oz meets Anthem.
I'll probably have a super rough draft ready in November, I'd pay you sats for a lookover and solid critique.
reply
No need to pay me anything! I will gladly read it
reply
Yes, it's life and death. It's all life and death, brother. But not in a manic, fearful sense. It's all life and death in the sense that EVERYTHING MATTERS.
reply
Of course there's high fees right now, everyone is trying to figure out their lightning setups for SN.
reply
lol, I wish it was for this reason versus the actual reason 😞
reply
…and when we all do, we’re all going to learn that the horses didn’t have anything to do with self-custody anyway.
reply
32 sats \ 1 reply \ @k00b 16 Oct
reply
reply
Given the inability to exchange CC's for satoshis, will this create a system where users are incentivized to spend their entire daily allotment? Or, put another way, is there any economic benefit to holding onto these coins? Is that correct?
reply
Buying different colors of cowboy hats.
reply
And buy pistols and horses! 🀠
reply
🌰🌰🌰🌰🌰🌰 Part #5/5
46JICJ9 🌰🌰🌰🌰🌰🌰
That’s it saloon nut complete!!!! Happy harvesting!!!
reply
76 sats \ 0 replies \ @Taft 16 Oct
Wow! These guys are so fast πŸ’¨
reply
Already claimed? How?
Under 1min
reply
I didn't get it.
reply
I thought for sure because it was broken into 5 parts someone wouldn't snipe it right away.
reply
Not it! Is the sniper going to claim the credit? That’s what I wanna know.
reply
TELL ME WHAT DO I DO?
DO YOU NOTICE THE DIFFERENCE IN THE NUMBER OF COMMENTS?
THIS IS A SHIT EATER SUPPOSEDLY SCORING THE SHIT CURRENCIES GOING UP
THIS ONE IS SELF-EXPLAINING. ONE OF THE MAGNIFICENT PRESENTATIONS AT WOB, SPAIN 2024. It's about FINANCIAL PRIVACY.
TELL ME WHAT DO I DO?
That's why @DarthCoin acts the way he does.
reply
Home from from work. Time ice my knee for a bit and peruse SN.
reply
I might be in a bubble but do you guys think Trump is way ahead right now in the race?
reply
Posted by Toby Cunningham on X.
reply
When there's a userId, does this query actually pull up anything? And is the creation date after now? Maybe I'm reading this wrong.
const dayFragment = userId ? Prisma.sql`(now() AT TIME ZONE 'America/Chicago')::date` : Prisma.sql`(now() AT TIME ZONE 'America/Chicago' - interval '1 day')::date` ... WHERE ("Invoice"."created_at" AT TIME ZONE 'UTC' AT TIME ZONE 'America/Chicago')::date >= ${dayFragment} ...
reply
23 sats \ 4 replies \ @ek 17 Oct
The ::date at the end casts the current timestamp to a date so it's actually the current date that we're using, not the current timestamp in which case you would be right:
stackernews=# SELECT (now() AT TIME ZONE 'America/Chicago')::date; timezone ------------ 2024-10-17 (1 row)
So the query pulls all invoices that were created today.
reply
So it's not a rolling 24h window, but resets on midnight Chicago time? And anon gets an extra day?
reply
33 sats \ 2 replies \ @ek 17 Oct
Yes, it's not rolling but it checks every midnight Chicago time if the streak is still valid. This means you can gain a streak at any time but you can only lose it at midnight.
And anon gets an extra day?
No, this function is used in two different contexts. In the first context, it's called to check if a user has a new streak. We pass userId in that case and then we check for their zaps from today.
In the other context, it's called without userId to check if streaks have been lost. This means we want to get zaps from all users from the previous day since remember, we run this function at midnight which basically means slightly after midnight. Therefore, we need - interval '1 day' in that case.
Could have been communicated better through the code but it works.
reply
Thank you for the explanation!
reply
28 sats \ 0 replies \ @ek 17 Oct
No worries, glad people are interested in the code
reply
I don't understand the !userId part there, either.
But I notice all horses and guns are gone today.
@koob Why is worker/streak.js function checkStream() only called for hats?
reply
Or, rather, is it related to the seed job only doing hats (like, after a restart)?
./worker/streak.js:export async function checkStreak ({ data: { id, type = 'COWBOY_HAT' }, models }) { ./docker/db/seed.sql: INSERT INTO pgboss.job (name, data, priority) VALUES ('checkStreak', jsonb_build_object('id', NEW.id), -1);
Or how msat reduction triggers it
./docker/db/seed.sql:CREATE TRIGGER user_streak AFTER UPDATE ON public.users FOR EACH ROW WHEN ((new.msats < old.msats)) EXECUTE FUNCTION public.user_streak_check(); INSERT INTO pgboss.job (name, data, priority) VALUES ('checkStreak', jsonb_build_object('id', NEW.id), -1);
reply
23 sats \ 0 replies \ @ek 17 Oct
It's called for every streak, the type = 'COWBOW_HAT' only means that's the default streak that we're checking (for backwards compatibility reasons)
reply
11 sats \ 4 replies \ @chess 16 Oct bot
reply
~ $ sudo reboot
reply
just messing around with comment editing after 10 minutes
edit: Comment edited 15 minutes after creation.
reply
27 sats \ 1 reply \ @ek 17 Oct
wdym with "comment edited 15 minutes after creation"?
reply
yes!
To replicate the issue, try clicking 'edit' within the 10-minute window but don't confirm any changes during that time. I waited an extra 5 minutes after the 10-minute mark and it still recorded. I only discovered this by chance when I had to step away to use the bathroom mid-edit.
reply
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰 Part # 4/5
9LHsiaWQiOiIwMDUwMDU1MGYwNDk0MTQ2IiwiYW1vdW50IjoyNTYsInNlY3JldCI6ImJNYU5NSGF0S2g3NEFhcHNSMS9GNXdtTmN4YlFEUU1UZWZWbU5RUGRCZGc9IiwiQyI6IjAzYThjZDMzNTAxYTllNTMzZDdkYTYyM2EzZDM5MzZkYmIyMmY5YTZlMmFmZWU5MTYwZGJiZTJlYjMxMzM5YjJjNSJ9LHsiaWQiOiIwMDUwMDU1MGYwNDk0MTQ2IiwiYW1vdW50IjoxNiwic2VjcmV0IjoiWTl6dmRrL1hsbjZXSXd0ckpGTFplOSs5YUhnSWdwUCtubjN3SWN2alNUST0iLCJDIjoiMDNiYjk5NGM3OTJlNDIxNGYxNWMzODg3ZGI1ZGMxMTk1NDdiODkzMjY0NzU3NjA4ODNiZDkzZDI2ZDhmNTBjOGNhIn1dfV0sIm1lbW8iOiIxMDAgZGF5cyDwn
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
reply
87 sats \ 2 replies \ @Taft 16 Oct
How many nuts are you giving today, man?
reply
It’s one nut broken into 5 parts
reply
61 sats \ 0 replies \ @Taft 16 Oct
Oh, cool idea! I didn't realize it. I thought you were giving many nuts today. Tried to redeem one of them, but it failed, and I thought someone else received it.
reply
Oh baby. Here we go. Only one more part!
reply
πŸ˜‚
reply
β€œNever let the future disturb you. You will meet it, if you have to, with the same weapons of reason which today arm you against the present.” ― Marcus Aurelius
A Stoic Resurrection: #662497
reply
Also you could say, β€œNever let the past disturb you. For the past is done and cannot be redone differently.” Live in the ever present NOW.
reply
@siggy47 I think now we have completed the picture with "bitcoiners laughing on the secret island". I added Trace Meyer, the OG bitcoiner that is also the author of http://howtovanish.com/ and recently nobody knows anything about him... he literally "vanished" on that secret island. πŸ˜‚πŸ˜‚πŸ˜‚πŸ˜‚πŸ˜‚πŸ˜‚
reply
21 sats \ 1 reply \ @siggy47 16 Oct
He vanished without a "trace"?
reply
hahahaha yeah at this level I think even that name "Trace" wasn't his real name.
reply
deleted by author
reply
I saw what you did with Jon Matonis picture... Here is an old interview with Matonis from 2014 https://english.elpais.com/elpais/2014/02/27/inenglish/1393524604_999633.html
reply
then is not a secret anymore
reply
got suspended from twitter today for no reason!
reply
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰 Part #3/5
3emxzbEoyN0FIRkdFaENSaFJuYz0iLCJDIjoiMDIxN2RkMTI2NWViOTExOWUzZWFjZmFlYjBkNWRjMzcxZjFkMmY5ZWM0ZGVkMWJlNjlmYzAwMzQwYWUyMDU3MDYwIn0seyJpZCI6IjAwNTAwNTUwZjA0OTQxNDYiLCJhbW91bnQiOjEwMjQsInNlY3JldCI6ImZ1YW0rM0grRCtJR3VkY1dKdkRnVSt1c25XOElpZlNlenZHVzI3a0xaeUE9IiwiQyI6IjAzOGU0M2RkYTViOGZhYjUzMzM1MjVkNzVmODZhNGIzMzg2NzU2YTdlYzUzZWNjMDBkNTBlNTQyMTUyMmUxOWQwYiJ9LHsiaWQiOiIwMDUwMDU1MGYwNDk0MTQ2IiwiYW1vdW50Ijo1MTIsInNlY3JldCI6IkRMNnZhVTFNOEFBR3BEMFdNOTM1dkpaU2UxeEx5UU91MGl3TnNjSEpMTkU9IiwiQyI6IjAyM2EwOGQyYzM1MDUwODMxMTJiODkyMjRmNzZiODc4YzY1MWRlMWY4NzliM2I1NDg5ODY1Y2ZlZTE5YTUxY2IzNyJ
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
reply
106 sats \ 5 replies \ @Nadia 16 Oct
forgive my ignorance @BlokchainB, but what is this stuff you are posting?
reply
E-cash nuts. 1 nut = 1 sat at current conversion rates
reply
89 sats \ 1 reply \ @Nadia 16 Oct
So, you are giving us nuts/sats? Like it! How can we collect them?
reply
Yup you need a cashu wallet and copy and paste the string into the wallet then boom you got nutted 🌰
reply
0 sats \ 1 reply \ @Taft 16 Oct
deleted by author
reply
49 sats \ 0 replies \ @Taft 16 Oct
You are a nuts giver! 😁
reply
This is a long one
reply

Day 132 POD (Proof of Donation)

Day 132 Cowboy Hat Streak
reply
I've come up with a good article in ~privacy but that's not getting enough attention, imo.
I bet if you read it, you'll find it very interesting. Here's the link.
reply
My new friend got spooked by a snake. Hoofing it for now I guess.
reply
Part #2/5
CJwcm9vZnMiOlt7ImlkIjoiMDA1MDA1NTBmMDQ5NDE0NiIsImFtb3VudCI6ODE5Miwic2VjcmV0IjoibDRTMGd2R0NFZzlCVWxQZzBJOGc5SWd
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
reply
Hmmm a 5 part series. Endurance wins over speed today. I have got a shot.
reply
reply
Stuck in bed again.
reply
reply
@ek, @chess and @Scroogey are pumpping up the saloon! 153 comments

Yee-Haw 🀠

reply
What's the record for saloon comments so far?
reply
reply
Wow, that saloon was hopping.
Those were the @nemo days lol
reply
reply
reply
Day #100 of nut 🌰 dropping πŸ₯œ in the Saloon
Part #1 /5
cashuAeyJ0b2tlbiI6W3sibWludCI6Imh0dHBzOi8vbWludC5taW5pYml0cy5jYXNoL0JpdGNvaW4iL
Want to harvest this nut? https://docs.cashu.space/wallets
reply
Ha! I love where this is going.
reply
Today is the big day!!! 100 days of making nuts 🌰.
To celebrate I will be dropping a massive 10k sat 🌰 nut. May the best harvesters win!
reply
It's also your cowboy hat's birthday!
reply
Indeed it is!!
reply
PI planning at work today. If you know, you know!
reply
reply
lol you know
reply
33 sats \ 133 replies \ @ek 16 Oct
Anyone down for some chess?
reply
A bot to play chess is really nit! Well done!
reply
1 sat \ 0 replies \ @ek 16 Oct
reply
52 sats \ 130 replies \ @chess 16 Oct bot
reply
e4
reply
62 sats \ 128 replies \ @chess 16 Oct bot
1.e4
reply
Nf6
reply
52 sats \ 113 replies \ @chess 16 Oct bot
1.e4 Nf6
reply
Nc3
reply
42 sats \ 111 replies \ @chess 16 Oct bot
1.e4 Nf6 2.Nc3
deleted by author
reply
0 sats \ 7 replies \ @ek 16 Oct
Mhh, not sure why the bot didn’t pick this reply up. Maybe because it wasn’t paid fast enough and the bot ignores everything from 30s ago? This is good testing here.
Anyway, we can continue in #726181
reply
0 sats \ 0 replies \ @chess 16 Oct bot
failed to insert item 726182 into db: FOREIGN KEY constraint failed
reply
deleted by author
reply
0 sats \ 3 replies \ @chess 16 Oct bot
failed to insert item 726194 into db: FOREIGN KEY constraint failed
0 sats \ 0 replies \ @chess 16 Oct bot
failed to insert item 726194 into db: FOREIGN KEY constraint failed
deleted by author
reply
0 sats \ 1 reply \ @ek 16 Oct
Did you mean Nf6?
reply
0 sats \ 0 replies \ @chess 16 Oct bot
no knight found that can move to f3
reply
0 sats \ 0 replies \ @chess 16 Oct bot
no knight found that can move to f3
reply
he's consistent, i'll give him that
reply
He has a hard head and hard, shiny stuff in his hands.
reply
Very interesting listen regarding the potential size and magnitude of the AI bubble
Day 300 of posting mining earnings from the day before: 863 sats on 15Oct2024! Running total: 205,003 sats!
reply
day 76: 44 sats on 10-15-24. total 2750⚑sats!
"but this i say: he which mines sparingly shall get rewarded also sparingly; and he which mines bountifully shall get rewarded also bountifully." 2 corinthians 9:6
reply
My pistol 😩
reply
365 days!
reply
My horse must have stolen your pistol! 😩
reply
Everyone's horses are running off in the night!
reply
they must have gone to find a mare!
reply
Day 264 of the #100aDayTil100k challenge, sets breakdown: 3x36 normal/narrow, 36 normal on knuckles; Total: 144 (Day 368 of 100+ pushups per day in total; day 267 of 120+ pushups per day)
reply
GM Cowboys! βš‘β˜•πŸ§‘
reply
Happiness Journal 16/10/24
  1. Found some fun facts on dolphins and whales from a Science magazine to regale my son with.
  2. One colleague offered me breakfast. Another colleague gave me tons of papers to recycle.
  3. Finished writing my dreaded work review form.
reply
200 sats \ 1 reply \ @Lux 16 Oct

Getting Arrested

There are two ways to get arrested.
Arrest Number 1: By a constable of law who has probable cause.
They must have first-hand knowledge of the probable cause, they must tell you why you are being arrested, and they must tell you the name of the victim.
They are responsible for their actions if they get it wrong.
The victim must press charges or make the claim that you committed a crime against them, or the constable cannot act, as he does not have the authority to do so.
Arrest Number 2: By a constable of law, who will present you with a warrant, signed by a judge and backed up by a certified affidavit of the victim making the claim that you broke the law.
Anything else is kidnapping.
reply
so nocoiners will never have a GF ? :)
reply
It's bitcoiners who won't have a girlfriend because it's hard to have 1 bitcoin :)
reply
1BTC hodler...
reply
32 sats \ 1 reply \ @Taft 16 Oct
Interesting point of view πŸ€”
reply
You can't leave it too late! Ahahah
reply
33 sats \ 1 reply \ @anon 16 Oct
deleted by author
reply
🀘
reply