undefined | Better HN

0 pointsmasklinn4mo ago0 comments

Checking whether `deleted_at is null` should be extremely cheap, and it avoids the duplication and desynchronisation of having both “deleted” and “deleted_at”.

0 comments

nottorp4mo ago

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

indigo9454mo ago

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

j / k navigate · click thread line to collapse

0 comments

nottorp4mo ago

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

indigo9454mo ago

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

j / k navigate · click thread line to collapse