Tech Notes
Tech tips and new discoveries
A daily copy of my mirror machine with rsync and systemd
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.
LinuxHomelabclaude-subscription-to-api - a small API in front of the Claude CLI
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.
ProjectDockerHomelab8tickers - new features since June
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.
ProjectFinanceWhy Databases Use B+ Trees
Why B+ trees became the default on-disk index structure for relational databases, and where they do not work well.
DatabasesPostgreSQLPerformanceReading PostgreSQL Execution Plans with EXPLAIN ANALYZE
How I read EXPLAIN ANALYZE output in PostgreSQL: node types, bad row estimates, and how to use the plan to fix a query.
PostgreSQLDatabasesPerformance8tickers - A small screener for undervalued stocks
Notes on 8tickers.com, a free stock and crypto screener I built to find undervalued companies.
ProjectFinance