Get the latest tech news
Nullable but not null
Tech Tales from a Software Craftsman
People often forget the final step which is updating the schema to make the field non-nullable once the data is fully populated. Leaving a field marked as nullable when it no longer contains nulls creates a mismatch between your schema and your actual data. Nullable fields that never hold nulls are often the result of incomplete migrations or forgotten cleanup steps.
Or read this on Hacker News