Don't do this

Nikolay and Michael discuss several "Don't do this" lists about Postgres — picking out their favourite items, as well as some contentious ones that could be clearer, or not included.

 
Here are some links to things they mentioned:

• Don’t do this (PostgreSQL wiki page) https://wiki.postgresql.org/wiki/Don't_Do_This
• How to get into trouble using some Postgres features (how to by Nikolay) https://github.com/postgres-ai/postgres-howtos/blob/main/0016_how_to_get_into_trouble_using_some_postgres_features.md
• Don’t do this (jOOQ list) http://www.jooq.org/doc/3.19/manual/reference/dont-do-this
• Don’t use NOT IN (jOOQ) https://www.jooq.org/doc/3.19/manual/reference/dont-do-this/dont-do-this-sql-not-in/ 
• Our episode about NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown 
• Our episode on timestamps …

databases postgres postgresql sql technology