Tech Notes
Tech tips and new discoveries
How I keep a fresh copy of the /infra folder from my offline mirror box on a spare workstation partition, with rsync over ssh, a read only key, and a systemd timer.
Notes on a small container I run at home, which gives HTTP access to the Claude CLI, so I can test API clients without an API key.
Notes on what I added to 8tickers.com over the summer: a dark redesign, a live home page, insider transactions, a richer news feed, and more.
Why B+ trees became the default on-disk index structure for relational databases, and where they do not work well.
How I read EXPLAIN ANALYZE output in PostgreSQL: node types, bad row estimates, and how to use the plan to fix a query.
Notes on 8tickers.com, a free stock and crypto screener I built to find undervalued companies.