Ask HN: Best “I brought down production” story?

Re:Ask HN: Best “I brought down production” story? by onion2k on Saturday June 26, 2021 @06:02PM (#27646337)

And this is why we use things like database users that don't have delete permission, and row-level security so users can delete things that don't belong to them.

I have learned this from a very similar experience.

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by bombcar on Saturday June 26, 2021 @11:27PM (#27648298)

And why it’s often best to mark a record deleted and then have a reaper remove the records at a later point. But you must make sure all normal queries don’t see deleted items.

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by truetraveller on Saturday June 26, 2021 @11:49PM (#27648409)

That's over engineering. At this point, just rely on PITR. FWIW, postgres does have a "reaper" via vacuum, but not for the purpose of safety. but rather to allow for mvcc.

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by brutal_chaos_ on Sunday June 27, 2021 @02:33AM (#27649161)

Hi, if I may, what does PITR stand for?

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by syncdk on Sunday June 27, 2021 @02:39AM (#27649182)

https://en.wikipedia.org/wiki/Point-in-time_recovery

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by brutal_chaos_ on Sunday June 27, 2021 @04:11AM (#27649613)

Thanks!

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by yyyk on Sunday June 27, 2021 @10:26AM (#27651817)

There are other advantages for soft-deletes, like not having to worry about FKs.

[ Parent | on HN ]