pull down to refresh

This post is part of a series. It is meant to be a place for stackers to discuss creative projects they have been working on, or ideas they are aiming to build. Regardless of your project being personal, professional, physical, digital, or even simply an idea to brainstorm together.
If you have any creative projects or ideas that you have been working on or want to eventually work on... This is a place for discussing those, gather initial feedback and feel more energetic on bringing it to the next level.
Thanks @Kontext @td @SHA256man @SimpleStacker @k00b @justin_shocknet for joining and sharing your ideas in the previous edition. How are you all doing with your projects? Any update?
₿e Creative, have Fun!
I’ve long wanted to combine two passions of mine. Bitcoin and poker. I want to do this in the form of a meet-up style poker game where it is mandatory to use Lightning to buy in and cash out.
Tiny game. The goal is to spread the word and use of LN, not have people lose a bunch of sats. It’s cool how well the LN could facilitate a game like that. You could play a game as small as 200 sat buy in with 1 sat 2 sat as the blinds! What other electronic payment network would make that seamless? None!
I’ve dreamt of it for a while. I haven’t done anything besides dream, but I imagine the game being held once a month at a facility that lets us buy food and drinks with sats, once a month, bitcoin books and zines all around for people to look through, Lessons from competent bitcoiners teaching others the tools and wallets available to us, awesome bitcoin conversation while we beat each other up on the poker felt.
reply
17 sats \ 3 replies \ @k00b 3h
I'm mostly bug hunting. The closest thing to something creative I've been thinking about is how to add incremental aggregate statistics to the micropayment engine. Currently we do periodic refreshes over recent time ranges, but that creates lag in the aggregate values that I find inelegant (and people get confused about them).
reply
Thinking something like running timescale in parallel and query that on the fly?
reply
17 sats \ 1 reply \ @k00b 3h
I find framework/tool/infrastructure additions to be more trouble than they're worth at SN's scale.1
We currently construct time buckets of stats in a normal table. Instead of continuously refreshing those time buckets, I'm thinking of doing some kind of incremental update atomic with a payment's state transitions.

Footnotes

  1. my general vibe is to abuse what we have (frameworks/abstractions/whatever) until they can't do the job anymore
reply
my general vibe is to abuse what we have (frameworks/abstractions/whatever) until they can't do the job anymore ↩
I think this is the way to go in general, even beyond your scale. New systems can be such a can of worms and should only be added with great care (of course there are exceptions)
reply
21 sats \ 0 replies \ @SHA256man 5h
well, i have started studying the Trivium and Quadrivium, are u familiar with those methods of education and design, @deSign_r? my logos are temporarily on hold, but the production is there! it is slowly being distributed, the logos will be applied over time;
check these out: Quadrivium Trivium there is also a book called DESIGNA in rhe same series, i oedered that one too;
reply
Hoping a re-think of shockwallet's node up screen helps Pub users not accidentally Bootstrap the wallet and end up down the wrong path😅
reply
17 sats \ 1 reply \ @k00b 3h
I dig the sketchbook styling
reply
Started wireframing in excalidraw recently, found I was wasting too much time on design and prototyping using a real tool... better results too I think because it forces us to use standard components
... and one less SaaS subscription
reply