Don't bite the hand that eats you.

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.

The best way to generate a Bitcoin seed is to shuffle a stack of 24 Magic the Gathering cards and rubber-band them.

MTG-Bip39 | Magic Cards for Bitcoin Seed Phrases

Convert Bitcoin BIP39 seed phrases to Magic: The Gathering cards and back. A secure and creative way to store your seed phrase.

Selling all my Bitcoin to buy Pokemon cards. It's an investment.

Ditto Wallet is secure ly vibe coded 😎 View quoted note →

My programming lesson from this "don't gracefully degrade". Curb your enthusiasm. Let it throw.

GitHub

micropython/ports/stm32/rng.c at 4107246f8a080807b62c3b4838e71e812ea68b6f · Coldcard/micropython

MicroPython - a lean and efficient Python implementation for microcontrollers and constrained systems - Coldcard/micropython

I downloaded the Claude models in Shakespeare AI to 4.x because the newer models are trying way too hard. I want to replace these with open source models once I have time to test them with Shakespeare.

I've been sleeping on Undertale. I'm feeling inspired. And full of determination.

Happy birthday, @RogueHashrate! 🎂🎉

Groundbreaking

Armada now supports disappearing messages in DMs 👀