pull down to refresh

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!

0 sats \ 0 replies \ @k00b 16m

For the longest time all of our stats for display have been done via materialized views. This is convenient but grew aggravating as changing and iterating on their design is expensive; they're relatively inflexible. The move afaict is to create real tables that can be updated incrementally and in an idempotent way.

TIL about GROUPING SETS in postgres and the ability to create bitmasks with GROUPING which are really helpful because we want seven groups afaict (bucket is a time bucket):

    GROUP BY GROUPING SETS (
        (bucket),                                -- 7  GLOBAL
        (bucket, "payInType"),                   -- 6  GLOBAL_BY_TYPE
        (bucket, "subName"),                     -- 5  SUB_TOTAL         (kept even if subName is NULL)
        (bucket, "subName","payInType"),         -- 4  SUB_BY_TYPE       (kept even if subName is NULL)
        (bucket, "userId"),                      -- 3  USER_TOTAL
        (bucket, "userId","payInType"),          -- 2  USER_BY_TYPE
        (bucket, "subName","userId"),            -- 1  SUB_BY_USER       (kept even if subName is NULL)
        (bucket, "userId","subName","payInType") -- 0  USER_SUB_BY_TYPE  (kept even if subName is NULL)
    ))

0 sats \ 0 replies \ @Akg10s3 50m

35 sats \ 0 replies \ @Scoresby 2h

I love that Parker is keeping this updated (6.2% increase since June is rough!)

source

0 sats \ 0 replies \ @guerratotal 2h

0 sats \ 0 replies \ @DarthCoin 3h

Very well said !

nevent1qvzqqqqqqypzqngz8n5al4660uc8tw8guzzqpzlp0g0h2rrrkh08y8nwlzp6m3m9qqs0xttdd9447pqx0k367nd7p5ahta7ewevfjna0utmdatwlsnfyf5q6a2fhe

0 sats \ 0 replies \ @SimpleStacker 4h

I wonder if Nintendo is gunning to be the new Pixar

Nintendo Just Put Out A Weird Animated Short Film With No Explanation

0 sats \ 2 replies \ @RideandSmile 5h

0 sats \ 1 reply \ @DarthCoin 5h

4th monkey is just using shitGPT

0 sats \ 0 replies \ @RideandSmile 5h

or facebook or twitter or instagram or just playing or ....

0 sats \ 0 replies \ @DarthCoin 5h

0 sats \ 0 replies \ @anon 6h

0 sats \ 0 replies \ @suraz 6h

122 sats \ 4 replies \ @ek 7h

How I would flirt with a girl in my class if I had more confidence:

Making a heartbeat sound with an empty plastic bottle (dut-dut ... dut-dut), and when she looks at me, I make the heartbeat sound faster (dut-dut dut-dut)

0 sats \ 0 replies \ @SimpleStacker 4h

0 sats \ 0 replies \ @k00b 5h

That was fun to imagine

0 sats \ 0 replies \ @anon 6h

0 sats \ 0 replies \ @0xbitcoiner 7h

0 sats \ 2 replies \ @BlokchainB 8h

Hey @Car I need to ask you something what’s the best way to contact you

71 sats \ 1 reply \ @Car 6h

7 sats \ 0 replies \ @BlokchainB 6h

Sent thanks

207 sats \ 6 replies \ @Scoresby 8h

If you saw the discussion from yesterday about spark addresses being publicly searchable (#1251215) and you wondered whether this was true for Breez when it uses Spark...

Apparently, Breez SDK does not expose Spark addresses:

source

0 sats \ 0 replies \ @BlokchainB 6h

Well that good wonder what the WOS guys doing?

102 sats \ 3 replies \ @ek 7h

source of source

183 sats \ 2 replies \ @Scoresby 7h

oh cool! It's interesting to see a little bit about their decision. From what @moneyball said in his talk at bitcoin++ (05:25:04):

When I inquired, it's not a technology limitation but actually an intentional policy decision by their NC...uh...I can't steelman the argument. They feel like it's disingenuous to users to not publish it because of the risk of a Spark Operator potentially publishing it

It sounds like the reasoning is that in a world where there are many Spark Operators, users are vulnerable to this privacy leak if the operators choose to reveal the data or if they have a leak. So rather than have people lulled into a false sense of security, Spark chose to make it clear that your address is trackable.

It seems like this would have been okay if there had been a lot more communication about this as one of the trade-offs of using Spark.

It is still the case that Breez has access to all users spark addresses.

102 sats \ 0 replies \ @DarthCoin 2h

mark my words: in 2026 all "spark operators" will be declared as "money transmitters" and will have to KYC all their losers.

spark is the new coinbase business model

159 sats \ 0 replies \ @ek 6h

fwiw, there's a proposal for blind statechain transfers

10 sats \ 0 replies \ @0xbitcoiner 7h

"by default"

1021 sats \ 3 replies \ @0xbitcoiner 8h

@TNStacker way! Ahah

111 sats \ 0 replies \ @TNStacker 3h

MY PEOPLE!!!!! 🤣🤣🤣

21 sats \ 1 reply \ @DarthCoin 5h

LOL exactly that I am planning to do on my citadel premises... from fruits.

9 sats \ 0 replies \ @0xbitcoiner 5h

Essential oils or alcohol?

0 sats \ 0 replies \ @anon 8h

0 sats \ 0 replies \ @WeAreAllSatoshi 8h

Day 651 of posting mining earnings from the day before: 442 sats on 8Oct2025! Running total: 423,999 sats!

Yesterday's comment

0 sats \ 0 replies \ @cryotosensei 9h

Happiness Journal 9/10/25

My fifth graders’ hyperactivity is starting to get on my nerves. I understand that their prefrontal cortexes are not fully developed yet, so there is no excuse for bad behaviour. Clowning around, disturbing their classmates, treating my subject with scant respect.

Then, a brainwave came to my mind. In view of the meeting with the school leaders in November, I should start recording down every misdemeanor in my trusty notebook. (I often carry it to class.) I would use evidence to convey their misdeeds to the principals, if need be. They will not climb over Sensei’s head!