News for hackers. Stuff that matters.
Re:JSONB Has Landed in SQLite by Someone on Wednesday December 06, 2023 @10:59AM (#38545602)
I haven’t delved into it, but you likely lose the ability to round-trip your json strings, just as in postgreSQL’s jsonb type.

  Jsonb_extract(jsonb(foo), '€')
likely

- will remove/change white space in ‘foo’,

- does not guarantee to keep field order

- will fail if a dictionary in the ‘foo’ string has duplicate fields

- will fail if ‘foo’ doesn’t contain a valid json string

There are no comments on this comment yet.