Re:JSONB Has Landed in SQLite
by oefrha on Wednesday December 06, 2023 @02:59AM
(#38541494)
There’s no point using json_* functions if you’re always reading/writing the full blob.
[ Parent
| on HN ]
Re:JSONB Has Landed in SQLite
by lifthrasiir on Wednesday December 06, 2023 @03:09AM
(#38541547)
Of course (and I never said that), but if you need to store a JSON value in the DB and use a JSONB-encoded BLOB as an optimization, you eventually read it back to a textual JSON. It's just like having a UNIX timestamp in your DB and converting back to a parsed date and time for application uses, except that applications may handle a UNIX timestamp directly and can't handle JSONB at all.