- Postico client for mac
- pgcli - Postgres CLI with autocompletion and syntax highlighting
- pghero - Server and query performance dashboard
- Anything by Craig Kerstiens, Postgres guide by Craig
- Unique partial indexes used for a toggle button
- The FILTER clause
- Citus Data's blog is full of gold
- Hash rocket's postgresql section is golden
- Bones Moses
More as I find things…