Tech Notes
Tech tips and new discoveries
How I build one Debian 13 installer image for the whole homelab, create a directory storage on Proxmox over the API, and give every machine its own user and network without rebuilding the image.
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.