Was just told to put 0 if field doesn’t exist In database instead of marking the column nullable. That is driving me crazy bull and 0 are not the same two different meanings.

I inherited a database like that.

Every time I see it, I want to castrate myself.

@sariel i am like zero means something bull doesn’t they don’t care

@sariel they also use 01-01-1900 as null too

What's the column, just out of curiosity?

Ask them to put a default value then. Why do we have to write code when db can do it automatically? (Not mentioning all the times I don’t find foreign keys and delete/update rules defined)

0 and null are clearly the same, stop complaining!

*glitches into a wall*

THE SAME I TELL YOU!

@piratefox but wait there's more!

What if it's a zero reference to an ID that actually exists in another table?!

@sariel real life scenario:
“If we use GUIDs we don’t even need to link two tables! There will never be a collision!”

Spoiler: there were collisions.

Also: sorry for the randomness, your example just reminded me of that bs developer who seriously implemented that

@sariel I crashed my app before because I wrote the relationship and it referenced 1000 records.

@bananaerror foreign key

Leave the databases alone.... Poor things

@IntrusionCM never. DBs need to pay for their crimes.

@piratefox crimes... What crimes?

@IntrusionCM I am pretty sure police’s do have committed ALL the crimes >:)

@piratefox ?!!!???????

@IntrusionCM it was a joke about the fact police’s db(S) have crimes inside them, and that they were committed into them (e.g. via transactions)

@piratefox ok.... That joke was clever but too hard to grok. XD