Don't do this | Postgres.FM 091 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try KZbin's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
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) wiki.postgresql.org/wiki/Don'...
* How to get into trouble using some Postgres features (how to by Nikolay) github.com/postgres-ai/postgr...
* Don’t do this (jOOQ list) www.jooq.org/doc/3.19/manual/r...
* Don’t use NOT IN (jOOQ) www.jooq.org/doc/3.19/manual/...
* Our episode about NULLs postgres.fm/episodes/nulls-th...
* Our episode on timestamps postgres.fm/episodes/timestamps
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to read the transcript, see guest profiles, and more.

[@wstrzalka]

Love your podcast. Its fun to listen for both advanced and basic topics as always something new will pop up. And the attached articles list makes waiting for the next episode more bearable 🐘

[@TimUckun]

Why doesn’t Postgres have unsigned integers? Also why doesn’t timestamp with Timezone actually store the Timezone of the timestamp? If my app is crossing time zones I really want to know the Timezone of the writer.

[@chralexNET]

One thing about timestamps. In my current project I only use timestamp without time zone, because I always save UTC for all my dates and times. If I do that I guess there are no problems with using timestamp without time zone then? Edit: Okay so reading more of the wiki article they suggest not doing that, because they think it is going to give you issues if you are going to do calculations with other timestamps that have time zones, but I am never going to do that, because all my dates and times will be in UTC.

[@kirkwolak6735]

I switched away from that, and one of the reasons was DST.

[@chralexNET]

@@kirkwolak6735 I don't know why that would cause any issues. UTC is not affected by DST. What a client application does when it receives a timestamp is to work with that timestamp in UTC in its logic, and for displaying the timestamp it explicitly converts it to the local time of the client by adding the time zone offset to the timestamp.

[@ilyaportnov181]

comparasion of timestamps is nontrivial topic at all due to timezones :)