Re:JSONB Has Landed in SQLite
by cztomsik on Wednesday December 06, 2023 @06:54AM
(#38542702)
Yes, I know, the point was not to say that it's safe to depend on this universally, but rather why it's safe in JS and why it's not elsewhere -> other languages use hash maps simply because authors were either lazy or unaware of the original behaviour. (which sucks, in my opinion, but nobody can fix it now)
[ Parent
| on HN ]
Re:JSONB Has Landed in SQLite
by ElectricalUnion on Wednesday December 06, 2023 @03:06PM
(#38548819)
> other languages use hash maps simply because authors were either lazy or unaware
Because it is idiomatic in that language, and you often don't need the higher overhead of tracking insertion order.
Before Python 3.7, json.loads used dict (undefined order) and you needed to explicitly need to override the load calls with the kwarg `object_pairs_hook=collections.OrderedDict` to accept ordered dictionaries.
Since Python 3.7 all `dict`s are effectively `collections.OrderedDict` because people now expect this kind of inefficient default behavior everywhere. ¯\_(ツ)_/¯