News for hackers. Stuff that matters.

A comment on JSONB Has Landed in SQLite. Parent comment

Re:JSONB Has Landed in SQLite by ash on Wednesday December 06, 2023 @01:24PM (#38547665)
There are situations where keeping order is useful. For example, human-editable json config files.

I also gave an example of two implementations that are compatible for a useful subset of keys. By the way, SQLite JSONB keeps object keys in insertion order, similar to Python: https://news.ycombinator.com/item?id=38547254

[ Parent | on HN ]
Re:JSONB Has Landed in SQLite by cryptonector on Wednesday December 06, 2023 @06:28PM (#38550908)
> There are situations where keeping order is useful. For example, human-editable json config files.

You might have to just normalize every time you want to edit that.

[ Parent | on HN ]