- Postico client for mac
- pgcli - Postgres CLI with autocompletion and syntax highlighting
- pghero - Server and query performance dashboard
- PEV - Query planning / Explain analyze visualisation
- PostgreSQL's explain analyze made readable
- 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…
As a newcomer, this PGCon presentation on overlooked data types was super valuable: https://www.youtube.com/watch?v=BLX8N3HB8sQ
I nearly used the
money
type : O