Portland, Oregon is a unique place

All you have is a bunch of unrealized potential.
And all you are - is a canvas.
And the painter.
And the paintbrush.
The colors are the colors of your imagination, and the strokes are just as bold or gentle as you are.

You are the cosmos experiencing itself.

ive realized the only people that care about local communities getting on bitcoin are the local communities 💫

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)
    ))

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

source

Very well said !

nevent1qvzqqqqqqypzqngz8n5al4660uc8tw8guzzqpzlp0g0h2rrrkh08y8nwlzp6m3m9qqs0xttdd9447pqx0k367nd7p5ahta7ewevfjna0utmdatwlsnfyf5q6a2fhe

I wonder if Nintendo is gunning to be the new Pixar

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

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)

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

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

@TNStacker way! Ahah

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

Yesterday's comment

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!

A very philosophical friend asked me, “What is Earth without art?”

I just looked at him and said, “Eh?”

first ever SN shirt replicafirst ever SN shirt replica

Originally printed by Lightning.store

• 🌐 worldwide shipments
• All in ⚫ graphite and ⚪ white ivory
• 🛡️ No data retention
• 🟠 Bitcoin-only payments

Now available at https://agora.ftp.sh/product/vintage-lngtstore-stacker-news-t-shirt/

deleted by author