Soft delete | Postgres.FM 103 |

Описание: [ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementations suit which use cases.

Here are some links to things they mentioned:

Soft Deletion Probably Isn't Worth It (blog post by Brandur) https://brandur.org/soft-deletion
Easy, alternative soft deletion (blog post by Brandur) https://brandur.org/fragments/deleted...
Our episode on auditing https://postgres.fm/episodes/auditing
CREATE FUNCTION … SECURITY DEFINER (docs) https://www.postgresql.org/docs/curre...
Principle of least privilege https://en.wikipedia.org/wiki/Princip...


~~~


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 produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.