blog
thoughts on software, security, and everything in between.
A ClickHouse segfault in query planning (and the 5-line fix)
A KPI query started killing ClickHouse after a harmless WHERE clause. It turned out to be a NULL type pointer created by unordered_map operator[] during partial evaluation of join filters.
Everything I Self-Host at Home
A grounded look at my home stack: three machines, a single public entrypoint, and the operational choices behind owning core services.
My Crypto Portfolio Strategy for 2026: A Deep Dive into Bitcoin, Ethereum, Solana, Polkadot, and Cardano
A disciplined 2026 DCA strategy across BTC, ETH, SOL, DOT, and ADA, with catalysts, staking economics, and risk management.
Postgres to ClickHouse, then the embeddings pipeline became the real migration
A ClickHouse backfill that surfaced a slow embedding worker, and the inference optimizations that made it behave like a GPU service (microbatching, TensorRT, caches, and the next bottleneck).
Secrets scanning for a 200+ repo GitHub org, with zero developer setup
An org-wide, push-triggered secrets scanner: webhook → Lambda → TruffleHog → hash-only findings → Slack + read-only dashboard.
From 4M comments to a style-controlled comment generator
How I turned 4M scraped comments into a style-controlled comment generator.
Why I built a semantic grep
I spend a lot of time auditing codebases I don’t understand. This is the tool I built so I could stop pretending I did.
Scanning IP ranges to find friends
How I built my own IP Scanner after tracking down someone that randomly connected to a Minecraft server using Shodan