2 ms·
There’s no point using json_* functions if you’re always reading/writing the full blob.
by oefrha 3y ago
There’s no point using json_* functions if you’re always reading/writing the full blob.
- lifthrasiir 3y agoOf 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.