JSONB Has Landed in SQLite

Re:JSONB Has Landed in SQLite by chippiewill on Wednesday December 06, 2023 @05:26AM (#38542250)

Not specifically JSONB, but I do recall that with MongoDB's equivalent, BSON, the sizes of the binary equivalent tend to be larger in practice, I would expect JSONB to have a similar trade off.

There'll also be a conversion cost if you ultimately want it back in JSON form.

[ Parent | on HN ]

Re:JSONB Has Landed in SQLite by cowsandmilk on Wednesday December 06, 2023 @05:37AM (#38542298)

From the post:

> JSONB is also slightly smaller than text JSON in most cases (about 5% or 10% smaller) so you might also see a modest reduction in your database size if you use a lot of JSON.

[ Parent | on HN ]