Re:What’s the most asinine technical requirement you’ve had ...
by wayneftw on Tuesday October 08, 2019 @09:57AM
(#21192346)
Just curious: was there some problem caused by the negativity of the IDs? Or, was the problem mostly having to do with the lack of indexes? Not sure I understand the problem.
[ Parent
| on HN ]
Re:What’s the most asinine technical requirement you’ve had ...
by oreglio on Wednesday October 09, 2019 @05:14AM
(#21201429)
The problem for me was that, they used negative ID to store unrelated data from the table intent. It's like having a kind of "hidden world" within your tables.
There is a lot of topics discussing the use of negative ID when the ID store the same datas all the way from negative to positive.
But storing unrelated datas - data reserved to the system for the developper - on the negative IDs of table ... to "save space" ? That for me is bad database design and a problem.