Tech Notes
Tech tips and new discoveries
All Posts#Architecture#CSS#Database#Databases#Docker#Finance#Homelab#JavaScript#Linux#Networking#Node.js#Performance#PostgreSQL#Project#React#TypeScript#Ubuntu
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 Reach for 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
A Practical Look at JavaScript Garbage Collection
How V8 manages memory: generational GC, scavenging, mark-sweep, and what it means for the code you write.
JavaScriptNode.js