Checking whether `deleted_at is null` should be extremely cheap, and it avoids t... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		masklinn 34 days ago \| parent \| context \| favorite \| on: The challenges of soft delete Checking whether `deleted_at is null` should be extremely cheap, and it avoids the duplication and desynchronisation of having both “deleted” and “deleted_at”.

nottorp 34 days ago [–]

Yes, if your database has null. I know this is about postgres, but a lot of stuff is nosql now.

indigo945 34 days ago | [–]

Even in MongoDB, you can can index `null` values, so I don't understand in what database system this would be a problem.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact