Tech Notes
Tech tips and new discoveries
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.
PostgreSQLDatabasesPerformance8tickers - A small screener for undervalued stocks
Notes on 8tickers.com, a free stock and crypto screener I built to find undervalued companies.
ProjectFinanceHardening an OpenWrt Router: SSH, LuCI, RPCD, and the Kernel
Five quick OpenWrt security fixes: SSH keys only, forcing HTTPS on LuCI, a fresh TLS cert, a LuCI password separate from root, and tighter sysctl.
LinuxHomelabNetworkingA Practical Look at JavaScript Garbage Collection
How V8 manages memory: generational GC, scavenging, mark-sweep, and what it means for the code which you write.
JavaScriptNode.jsPostgreSQL Scales Further Than Most People Think
How to get more out of a single PostgreSQL instance before you move to a distributed database or a rewrite.
PostgreSQLDatabaseLinuxReact View Transitions: A Hands-On Look
A look at the View Transitions API in React: how it works, where it has problems, and whether it is ready for real projects.
ReactJavaScriptCSS