News for hackers. Stuff that matters.
Re:JSONB Has Landed in SQLite by ash on Wednesday December 06, 2023 @12:50PM (#38547211)
> Javascript environments ... guarantee that they'll preserve object key order when JSON is evaluated

Yes, but only for non-integer keys.

Re:JSONB Has Landed in SQLite by gmfawcett on Thursday December 07, 2023 @06:20PM (#38563175)
Is there such a thing as a non-string JSON key to be evaluated? https://www.json.org/ suggests not.
Re:JSONB Has Landed in SQLite by ash on Thursday December 14, 2023 @09:30AM (#38641692)
Yes, in the context of JSON handling by JavaScript. I meant string keys that can be interpreted as non-negative numbers. Those are traversed first, the rest of the keys are coming in insertion order. For example:

    > JSON.stringify({'one': 1, '3': 3, 'two': 2, '2': 2, 'three': 3, '1': 1})
    '{"1":1,"2":2,"3":3,"one":1,"two":2,"three":3}'
Re:JSONB Has Landed in SQLite by gmfawcett on Sunday December 17, 2023 @09:42AM (#38673157)
Thanks for explaining. That behaviour is... interesting!