Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on JSONB Has Landed in SQLite. Parent comment
UPDATE: I think SQLite JSONB does maintain order. For example:
select json(jsonb('{"a": 1, "b": 2, "c": 3, "d": 4}'));" -- {"a":1,"b":2,"c":3,"d":4}
select json(jsonb_insert(jsonb('{"a": 1, "b": 2, "c": 3, "d": 4}'), '$.e', 99)); -- {"a":1,"b":2,"c":3,"d":4,"e":99}
There are no comments on this comment yet.
UPDATE: I think SQLite JSONB does maintain order. For example:
And it does maintain order when adding new keys: (tested on https://codapi.org/sqlite/)