A genuine gift for Postgres users (and those who should be using it but aren't): https://challahscript.com/what_i_wish_someone_told_me_about_postgres
What I Wish Someone Told Me About Postgres

I’ve been working professionally for the better part of a decade on web apps and, in that time, I’ve had to learn how to use a lot of different systems and tools. During that education, I found that the official documentation typically proved to be the most helpful.

ChallahScript
Just Use Postgres for Everything

Replace Redis, MongoDB, Kafka & more with PostgreSQL. Reduce complexity, boost development speed. Complete guide with real examples.

Amazing CTO
@gvwilson good post. I have used MySQL extensively through the years and just started looking into postgres. Can see many things are the same about indexes and JSON. Nice to know about the char/varchar/text didn't know that.

@gvwilson

Nice idea to make null values (mostly) unambiguously visible with one of these:

\pset null '␀'

or

\pset null '∅'