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!
@cryotosensei
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.
No need to pay me anything!
I will gladly read it
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.
Of course there's high fees right now, everyone is trying to figure out their lightning setups for SN.
lol, I wish it was for this reason versus the actual reason 😞
…and when we all do, we’re all going to learn that the horses didn’t have anything to do with self-custody anyway.
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?
Buying different colors of cowboy hats.
And buy pistols and horses! 🤠
🌰🌰🌰🌰🌰🌰
Part #5/5
46JICJ9
🌰🌰🌰🌰🌰🌰
That’s it saloon nut complete!!!! Happy harvesting!!!
Wow! These guys are so fast 💨
Already claimed? How?
Under 1min
I didn't get it.
I thought for sure because it was broken into 5 parts someone wouldn't snipe it right away.
Not it! Is the sniper going to claim the credit? That’s what I wanna know.
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.
Home from from work. Time ice my knee for a bit and peruse SN.
I might be in a bubble but do you guys think Trump is way ahead right now in the race?
Posted by Toby Cunningham on X.
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} ...@chess
The
::dateat 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.
So it's not a rolling 24h window, but resets on midnight Chicago time? And anon gets an extra day?
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.
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
userIdin that case and then we check for their zaps from today.In the other context, it's called without
userIdto 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.
Thank you for the explanation!
No worries, glad people are interested in the code
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?
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);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)~ $ sudo reboot
just messing around with comment editing after 10 minutes
edit: Comment edited 15 minutes after creation.wdym with "comment edited 15 minutes after creation"?
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.
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
Part # 4/5
9LHsiaWQiOiIwMDUwMDU1MGYwNDk0MTQ2IiwiYW1vdW50IjoyNTYsInNlY3JldCI6ImJNYU5NSGF0S2g3NEFhcHNSMS9GNXdtTmN4YlFEUU1UZWZWbU5RUGRCZGc9IiwiQyI6IjAzYThjZDMzNTAxYTllNTMzZDdkYTYyM2EzZDM5MzZkYmIyMmY5YTZlMmFmZWU5MTYwZGJiZTJlYjMxMzM5YjJjNSJ9LHsiaWQiOiIwMDUwMDU1MGYwNDk0MTQ2IiwiYW1vdW50IjoxNiwic2VjcmV0IjoiWTl6dmRrL1hsbjZXSXd0ckpGTFplOSs5YUhnSWdwUCtubjN3SWN2alNUST0iLCJDIjoiMDNiYjk5NGM3OTJlNDIxNGYxNWMzODg3ZGI1ZGMxMTk1NDdiODkzMjY0NzU3NjA4ODNiZDkzZDI2ZDhmNTBjOGNhIn1dfV0sIm1lbW8iOiIxMDAgZGF5cyDwn
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
How many nuts are you giving today, man?
It’s one nut broken into 5 parts
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.
Oh baby. Here we go. Only one more part!
😂
“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
https://image.nostr.build/35287753a91131d501f3b09880f37843f2b76b8535ad7cf3f624c191ed966381.jpg
A Stoic Resurrection: #662497
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.
@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. 😂😂😂😂😂😂
He vanished without a "trace"?
hahahaha yeah at this level I think even that name "Trace" wasn't his real name.
deleted by author
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
then is not a secret anymore
got suspended from twitter today for no reason!
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
Part #3/5
3emxzbEoyN0FIRkdFaENSaFJuYz0iLCJDIjoiMDIxN2RkMTI2NWViOTExOWUzZWFjZmFlYjBkNWRjMzcxZjFkMmY5ZWM0ZGVkMWJlNjlmYzAwMzQwYWUyMDU3MDYwIn0seyJpZCI6IjAwNTAwNTUwZjA0OTQxNDYiLCJhbW91bnQiOjEwMjQsInNlY3JldCI6ImZ1YW0rM0grRCtJR3VkY1dKdkRnVSt1c25XOElpZlNlenZHVzI3a0xaeUE9IiwiQyI6IjAzOGU0M2RkYTViOGZhYjUzMzM1MjVkNzVmODZhNGIzMzg2NzU2YTdlYzUzZWNjMDBkNTBlNTQyMTUyMmUxOWQwYiJ9LHsiaWQiOiIwMDUwMDU1MGYwNDk0MTQ2IiwiYW1vdW50Ijo1MTIsInNlY3JldCI6IkRMNnZhVTFNOEFBR3BEMFdNOTM1dkpaU2UxeEx5UU91MGl3TnNjSEpMTkU9IiwiQyI6IjAyM2EwOGQyYzM1MDUwODMxMTJiODkyMjRmNzZiODc4YzY1MWRlMWY4NzliM2I1NDg5ODY1Y2ZlZTE5YTUxY2IzNyJ
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
forgive my ignorance @BlokchainB, but what is this stuff you are posting?
E-cash nuts. 1 nut = 1 sat at current conversion rates
So, you are giving us nuts/sats? Like it! How can we collect them?
Yup you need a cashu wallet and copy and paste the string into the wallet then boom you got nutted 🌰
deleted by author
You are a nuts giver! 😁
This is a long one
Day 132 POD (Proof of Donation)Day 132 POD (Proof of Donation)
Day 132 Cowboy Hat Streak
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.
#726502
My new friend got spooked by a snake. Hoofing it for now I guess.
Part #2/5
CJwcm9vZnMiOlt7ImlkIjoiMDA1MDA1NTBmMDQ5NDE0NiIsImFtb3VudCI6ODE5Miwic2VjcmV0IjoibDRTMGd2R0NFZzlCVWxQZzBJOGc5SWd
🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰🌰
Hmmm a 5 part series. Endurance wins over speed today. I have got a shot.
#bulish
Stuck in bed again.
Rest up!
@ek, @chess and @Scroogey are pumpping up the saloon!
153 comments
Yee-Haw 🤠Yee-Haw 🤠
What's the record for saloon comments so far?
359
Wow, that saloon was hopping.
Those were the @nemo days lol
LOL
Day #100 of nut 🌰 dropping 🥜 in the Saloon
Part #1 /5
cashuAeyJ0b2tlbiI6W3sibWludCI6Imh0dHBzOi8vbWludC5taW5pYml0cy5jYXNoL0JpdGNvaW4iL
Want to harvest this nut?
https://docs.cashu.space/wallets
Ha! I love where this is going.
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!
It's also your cowboy hat's birthday!
Indeed it is!!
PI planning at work today. If you know, you know!
lol you know
Anyone down for some chess?
@chess
A bot to play chess is really nit! Well done!
e4
1.e4Nf6
1.e4 Nf6Nc3
1.e4 Nf6 2.Nc3deleted by author
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
failed to insert item 726182 into db: FOREIGN KEY constraint faileddeleted by author
failed to insert item 726194 into db: FOREIGN KEY constraint failedfailed to insert item 726194 into db: FOREIGN KEY constraint faileddeleted by author
Did you mean Nf6?
no knight found that can move to f3no knight found that can move to f3he's consistent, i'll give him that
He has a hard head and hard, shiny stuff in his hands.
https://www.fountain.fm/episode/5x32eLH36hGUSFkNahSp
Very interesting listen regarding the potential size and magnitude of the AI bubble
https://i.postimg.cc/B6b412jt/no-AI.jpg
Day 300 of posting mining earnings from the day before: 863 sats on 15Oct2024!
Running total: 205,003 sats!
Yesterday's comment
Day 301's comment
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
My pistol 😩
365 days!
My horse must have stolen your pistol! 😩
Everyone's horses are running off in the night!
they must have gone to find a mare!
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)
GM Cowboys! ⚡☕🧡
Happiness Journal 16/10/24
previous
Getting ArrestedGetting 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.
next
part of:#586916so nocoiners will never have a GF ? :)
It's bitcoiners who won't have a girlfriend because it's hard to have 1 bitcoin :)
1BTC hodler...
Interesting point of view 🤔
You can't leave it too late! Ahahah
deleted by author
🤘