JSONB Has Landed in SQLite

Re:JSONB Has Landed in SQLite by ako on Wednesday December 06, 2023 @09:05AM (#38544038)

Assume you're writing an editor for JSON files. Don't think many users of that editor would be very happy if you change the order of the attributes in their json files, even though technically it's the same...

[ Parent | on HN ]

Re:JSONB Has Landed in SQLite by jchanimal on Wednesday December 06, 2023 @09:47AM (#38544576)

According to the JSON spec it's also legal to round all numbers to zero.

[ Parent | on HN ]

Re:JSONB Has Landed in SQLite by golergka on Wednesday December 06, 2023 @10:21AM (#38544990)

If you’re writing an editor, you will need to separate in progress text that user is editing from the parsed and validated data, and keep both.

[ Parent | on HN ]