Tech Notes
Tech tips and new discoveries
A practical look at why B+ trees became the default on-disk index structure for relational databases — and where they start to creak.
A practical walkthrough of EXPLAIN ANALYZE in PostgreSQL — how to read node types, spot bad row estimates, and turn the plan into an actual fix.
A short review of 8tickers.com, a free no-signup stock and crypto screener I built for spotting undervalued companies.
Five concrete OpenWrt hardening steps from a real audit — disabling SSH passwords, fixing the LuCI HTTP/TLS setup, decoupling LuCI auth from the system password, and tightening the network stack with sysctl.
A walkthrough of how V8 manages memory — generational GC, scavenging, mark-sweep, and what it means for our code.
Practical strategies for scaling PostgreSQL before reaching for distributed databases or microservice rewrites