Tech Notes

Tech tips and new discoveries

claude-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.

ProjectDockerHomelab
8tickers - 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.

ProjectFinance
Why Databases Use B+ Trees

Why B+ trees became the default on-disk index structure for relational databases, and where they do not work well.

DatabasesPostgreSQLPerformance
Reading 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.

PostgreSQLDatabasesPerformance
8tickers - A small screener for undervalued stocks

Notes on 8tickers.com, a free stock and crypto screener I built to find undervalued companies.

ProjectFinance
Hardening an OpenWrt Router: SSH, LuCI, RPCD, and the Kernel

Five OpenWrt hardening steps: SSH keys only, forcing HTTPS on LuCI, regenerating the TLS cert, separating LuCI login from the system password, and tightening sysctl.

LinuxHomelabNetworking
Next →