.tips
page 7 of 10, 238 small things in all. back to the first.
.april
2026, 3 tips.
.march
2026, 22 tips.
as const turns a list into a type
typescriptdig +short answers the DNS question without the essay
shelloperationsUse satisfies for config objects, not a type annotation
typescriptwatch runs a command every few seconds and highlights what changed
shelloperationscolumn -t lines up columns
shellA BRIN index for append-only time series
postgresqlperformanceQuote the heredoc delimiter unless you want expansion
shellTurn on pg_stat_statements before you need it
postgresqlobservabilityPIPESTATUS tells you which command in a pipe failed
shellprintf, not echo, in scripts
shellsynchronous_commit = off is fine for at-least-once work
postgresqlperformancepv shows progress on anything you pipe
shellEnforce idempotency with a partial unique index
postgresqldistributed-systemsssh -L reaches a database that is only on the private network
shelloperationslsof -i :3000 names the process holding the port
shelldebuggingRETURNING can give you the old row too
postgresqlcurl -w prints where the time went
shellhttpcomm compares two sorted lists in one pass
shellIndex the rows you query, with a WHERE on the index
postgresqlperformanceawk '!seen[$0]++' dedupes without sorting
shellAlways run EXPLAIN with ANALYZE and BUFFERS
postgresqlperformancerg and fd, and let the .gitignore do the filtering
shelltooling