Alex Gleason's avatar
Alex Gleason
alex@gleasonator.com
npub1q3sl...d26p
I create software that empowers people online. I'm vegan btw.
Alex Gleason's avatar
Alex Gleason 2 weeks ago
What if your community had a fund that anybody could pay into. Any member could submit expenses, and any staff member could pay them out. A small Bitcoin OpenCollective right inside of your community.
Alex Gleason's avatar
Alex Gleason 2 weeks ago
It's no surprise Lightning software is full of vulnerabilities and getting taken offline. This is exactly the type of fragile, complex infrastructure we've been fighting against building Nostr. View quoted note →
Alex Gleason's avatar
Alex Gleason 2 weeks ago
A big thing Buzz did on the Nostr front is enable 1-click NIP-29 relays.
Alex Gleason's avatar
Alex Gleason 3 weeks ago
TIL hardware RNG works by edging the circuit millions of times per second and then checking whether or not it goons.
Alex Gleason's avatar
Alex Gleason 3 weeks ago
I have been forced to finally master Nostr SQLite. I started on SQLite, hit walls, moved to Postgres, hit further walls, and finally landed on ElasticSearch/OpenSearch with infinite scalability. But now I am forced to finally master SQLite for local database on Android/iOS. I've built 4 different variations of Nostr SQLite and I'm benchmarking them against each other. The current fastest implementation (for reads) stores tags in an FTS table like "t:hello e:abc123..." The naive way is to keep a separate nostr_tags table and JOIN it, but then the query planner behaves wrong. This way has 25x read performance for 100k+ datasets.
Alex Gleason's avatar
Alex Gleason 3 weeks ago
Selling all my Bitcoin to buy Pokemon cards. It's an investment.