What is better to store 0 or None in database?

Question

PostgreSQL

Actually, what is better to store in the database 0 or None? And why so? Thank you.

Answer 1

None is not 0 and not "", but type null is empty.
And what to store there depends on the logic of filling the field. For example, you store thermometer readings. Silly to store 0 in this case, if there is no data, agree. And the weight or height of a person is possible either way - there are hardly people with zero height or weight.

Answer 2

Answer 3

In many cases it is better to zero and add a default value of zero, it often happens that you need to increase the value counter or some other mathematical operations