.tips

page 8 of 11, 261 small things in all. back to the first.

.april

2026, 1 tip.

openssl s_client shows the certificate the server actually sends
Apr 1
shellsecurity

.march

2026, 24 tips.

as const turns a list into a type
Mar 31
typescript
dig +short answers the DNS question without the essay
Mar 30
shelloperations
Use satisfies for config objects, not a type annotation
Mar 28
typescript
watch runs a command every few seconds and highlights what changed
Mar 28
shelloperations
column -t lines up columns
Mar 26
shell
A BRIN index for append-only time series
Mar 25
postgresqlperformance
Quote the heredoc delimiter unless you want expansion
Mar 24
shell
Turn on pg_stat_statements before you need it
Mar 22
postgresqlobservability
PIPESTATUS tells you which command in a pipe failed
Mar 22
shell
printf, not echo, in scripts
Mar 20
shell
synchronous_commit = off is fine for at-least-once work
Mar 19
postgresqlperformance
pv shows progress on anything you pipe
Mar 18
shell
Enforce idempotency with a partial unique index
Mar 16
postgresqldistributed-systems
ssh -L reaches a database that is only on the private network
Mar 16
shelloperations
lsof -i :3000 names the process holding the port
Mar 14
shelldebugging
RETURNING can give you the old row too
Mar 13
postgresql
curl -w prints where the time went
Mar 12
shellhttp
comm compares two sorted lists in one pass
Mar 10
shell
Index the rows you query, with a WHERE on the index
Mar 10
postgresqlperformance
awk '!seen[$0]++' dedupes without sorting
Mar 8
shell
Always run EXPLAIN with ANALYZE and BUFFERS
Mar 7
postgresqlperformance
rg and fd, and let the .gitignore do the filtering
Mar 6
shelltooling
--first-parent reads a merge-heavy history as a timeline
Mar 4
git
An UNLOGGED table is a cache that speaks SQL
Mar 4
postgresqlcaching

.tips

.april

openssl s_client shows the certificate the server actually sends

.march

as const turns a list into a type

dig +short answers the DNS question without the essay

Use satisfies for config objects, not a type annotation

watch runs a command every few seconds and highlights what changed

column -t lines up columns

A BRIN index for append-only time series

Quote the heredoc delimiter unless you want expansion

Turn on pg_stat_statements before you need it

PIPESTATUS tells you which command in a pipe failed

printf, not echo, in scripts

synchronous_commit = off is fine for at-least-once work

pv shows progress on anything you pipe

Enforce idempotency with a partial unique index

ssh -L reaches a database that is only on the private network

lsof -i :3000 names the process holding the port

RETURNING can give you the old row too

curl -w prints where the time went

comm compares two sorted lists in one pass

Index the rows you query, with a WHERE on the index

awk '!seen[$0]++' dedupes without sorting

Always run EXPLAIN with ANALYZE and BUFFERS

rg and fd, and let the .gitignore do the filtering

--first-parent reads a merge-heavy history as a timeline

An UNLOGGED table is a cache that speaks SQL