null == "" is true?

Kagamin spam at here.lot
Wed Jul 20 13:35:14 UTC 2022


On Tuesday, 19 July 2022 at 18:05:34 UTC, Antonio wrote:
> In a relational database, `NULL` is not the same that `""`... 
> and `NULL` is not the same that `0`.  Are semantically 
> different and there are database invariants (like foreign keys) 
> based on it.   Trying to "mix" this concepts in a database is a 
> mistake.

So, it's an implementation detail or a relational database that 
leaks into business logic because nobody thought about it? Just 
because a relational database has many features, it doesn't mean 
business logic must use them all, it must use only what makes 
sense for business logic.

> When you treat with Domain Models, you try to represent this 
> semantics in all levels of your software... including APIs

What semantics your domain models implement? Is it semantics of 
all features of a relational database or is semantics of business 
logic?


More information about the Digitalmars-d-learn mailing list